Changing the APPS password in 11i

Steps to change apps password 

1. Backup entire system
2. Stop concurrent manager

  cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME

  adcmctl.sh stop apps/<apps password>

3. Backup FND_ORACLE_USERID table

  sqlplus apps/<apps password>

  drop table FND_ORACLE_USERID_BAK; (if there is any table like this)

  create table FND_ORACLE_USERID_BAK as select * from FND_ORACLE_USERID; 

  exit;

4. Change apps password

  $FND_TOP/bin/FNDCPASS apps/<old apps password> 0 Y system/<system password> SYSTEM APPLSYS <new apps password>

5. Change apps password in configuration files

  $IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app

  $IAS_ORACLE_HOME/listener/cfg/wdbsvr.app

  $ORACLE_HOME/listener/cfg/wdbsvr.app

  $FND_TOP/resource/wfmail.cfg

  $OA_HTML/bin/appsweb.cfg

  $AD_TOP/admin/template/CGIcmd.dat

Known Issues 

1. Symptom : Can not login to Oracle Applications

  Cause   : Invalid apps password in $IAS_HOME/Apache/modplsql/cfg/wdbsvr.app

  Solution: Change apps password in $IAS_HOME/Apache/modplsql/cfg/wdbsvr.app