How to change APPS password in Oracle Apps/EBS 11i
Steps to change apps password in 11i
1) Shut down the application on all nodes
2) Take the backup below files on all application nodes.
$IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app
$ORACLE_HOME/reports60/server/CGIcmd.dat (8.0.6 Oracle_home)
$FND_TOP/resource/wfmail.cfg
3) Backup below tables
create table FND_USER_BK_<YYYYMM> as select * from FND_USER;
create table FND_ORACLE_USERID_BK_<YYYYMM> as select * from FND_ORACLE_USERID;
4) Change apps password using the below command.
FNDCPASS apps/<appspwd> 0 Y system/<pwd> SYSTEM APPLSYS <new password>
**Changing APPLSYS user password will automatically change APPS user password.
5) Change APPS password in the following files.
$IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app
$ORACLE_HOME/reports60/server/CGIcmd.dat (8.0.6 Oracle_home)
$FND_TOP/resource/wfmail.cfg
6) Start the Application on all the nodes.
7 ) Validate services.
8) Recreate DB links if any needed.
9) Check any cron job/scripts/OEM that have apps password hardcoded.
Post a Comment
Post a Comment