Remote IT Support!! Please contact us

For Any Remote Support,Implementation/Upgrade Projects,Queries,Collaborations please mail us at support@funoracleapps.com

How to change APPS password in Oracle Apps/EBS 11i

No comments

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.





If you like please follow and comment

No comments :

Post a Comment