Tuesday, 8 March 2011

Change APPS password

    1. Take Backup of the below files on the db node and all the apps nodes.
    2. wdbsvr.app --> cd $IAS_ORACLE_HOME/Apache/modplsql/cfg/
      CGIcmd.dat -->cd $ORACLE_HOME/reports60/server/
    3. Bring down all the Application services.
    4. FNDCPASS apps/<old apps pwd> 0 Y system/<pwd> SYSTEM APPLSYS <new apps passwd> ( on db node)
    5. Manually change the password  with the new password on the below location on db node and apps nodes
    6. wdbsvr.app
      CGIcmd.dat
    7. Bring up all the services on all the nodes.
verify the db links as they might be using the apps password , so need to drop and recreate them with the new apps password.

No comments:

Post a Comment