Change Apps Password For Oracle EBS 11i and R12 with FNDCPASS
Oracle E-Business Suite provides a command line utility called FNDCPASS to change passwords.
4 mode is avaliable for FNDCPASS, details below
Note: To use this command line utility set application enviroment file (for example APPSORA.env)
1. Usage: FNDCPASS <logon> 0 Y <system/password> SYSTEM <username> <new_password>
Example: FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME
Note: Passwords for APPLSYS and the APPS schemas must be the same.
If you change the password for one, FNDCPASS automatically changes the others.
Change password for APPS and APPLSYS when concurrent manager is down.
After changing APPLSYS and APPS password in 11i should change hardcoded password manually in wdbsvr.app file under $IAS_ORACLE_HOME/Apache/modplsql/cfg. Also recommend to run autoconfig
Also there are some files to modify listed below but for new versions of 11.5.x is not necessary
Example: FNDCPASS apps/apps 0 Y system/manager ORACLE AP passwd1
3. Usage: FNDCPASS <logon> 0 Y <system/password> ALLORACLE <new_password>
Example: FNDCPASS apps/apps 0 Y system/manager ALLORACLE WELCOME
Note: Usernames must appear in the FND_USER or FND_ORACLE_USERID tables.
FNDCPASS utility and ALLORACLE functionality was designed for applications users/schemas.
Other users passwords must be manually changed(Examle: ABM,CSS,DBSNMP,EVM,SYS,etc.)
4. Usage: FNDCPASS <logon> 0 Y <system/password> USER <username> <new_password>
Example : FNDCPASS apps/apps 0 Y system/manager USER SYSADMIN WELCOME
4 mode is avaliable for FNDCPASS, details below
Note: To use this command line utility set application enviroment file (for example APPSORA.env)
- SYSTEM ==> To change the APPS and APPLSYS schema password
- ORACLE ==> To change single Application Schema password (other than APPS/APPLSYS)
- ALLORACLE === To change all ORACLE schema passwords
- USER ==> To change Oracle Applications user password
1. Usage: FNDCPASS <logon> 0 Y <system/password> SYSTEM <username> <new_password>
Example: FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME
Note: Passwords for APPLSYS and the APPS schemas must be the same.
If you change the password for one, FNDCPASS automatically changes the others.
Change password for APPS and APPLSYS when concurrent manager is down.
After changing APPLSYS and APPS password in 11i should change hardcoded password manually in wdbsvr.app file under $IAS_ORACLE_HOME/Apache/modplsql/cfg. Also recommend to run autoconfig
Also there are some files to modify listed below but for new versions of 11.5.x is not necessary
- $FND_TOP/resource/wfmail.cfg
- $COMMON_TOP/admin/scripts/<context_name>/adcmctl.sh
- $AD_TOP/admin/template/CGIcmd.dat
- $OA_HTML/bin/appsweb.cfg
2. Usage: FNDCPASS <logon> 0 Y <system/password> ORACLE <username> <new_password>
Example: FNDCPASS apps/apps 0 Y system/manager ORACLE AP passwd1
3. Usage: FNDCPASS <logon> 0 Y <system/password> ALLORACLE <new_password>
Example: FNDCPASS apps/apps 0 Y system/manager ALLORACLE WELCOME
Note: Usernames must appear in the FND_USER or FND_ORACLE_USERID tables.
FNDCPASS utility and ALLORACLE functionality was designed for applications users/schemas.
Other users passwords must be manually changed(Examle: ABM,CSS,DBSNMP,EVM,SYS,etc.)
4. Usage: FNDCPASS <logon> 0 Y <system/password> USER <username> <new_password>
Example : FNDCPASS apps/apps 0 Y system/manager USER SYSADMIN WELCOME
How to change the Apps Password in 11i Oracle Application
Everyone knows Apps Password changing policy or process. But after changing the password, We have to run autoconfig in Application Level. Sometimes, After autoconfig run, Custom level setting will be lose. So, Better We can choose manually way the apps password.
Two Method for Changing Apps Password using FNDCPSS
A. Autoconfig method after password change
B. Manually method after password change.
A. Autocong method after password change:-
1. Shutdown all the application nodes.
2. Issue the commands at the Unix command line similar to the following:
To change the APPS and APPLSYS passwords:
$FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS apps123
3. Check the apps password is working using "sqlplus apps/apps123".
4. Run the autoconfig in application nodes.
5. Start the application services.
6. Check Application Health checkup.
B. Manually method after password change.
1. Shutdown all the application nodes.
2. Shutdown the concurrent node.
3. Backup the below given 3 files before changing the apps password:
i) $IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app
ii) 8.0.6 Oracle_home : $ORACLE_HOME/reports60/server/CGIcmd.dat
iii) $FND_TOP/resource/wfmail.cfg
4. Issue the commands at the Unix command line similar to the following:
To change the APPS and APPLSYS passwords:
FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS <new password>
$FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS apps123
NOTE 1: Changing the APPLSYS password automatically changes the APPS password
to match as these two must always agree.
NOTE 2: VERY IMPORTANT!!
When changing the password for APPS it is important to manually change the APPS
password in the following files as well as necessary:
5. Change the apps password in the following files:
i). $IAS_ORACLE_HOME/Apache/modplsql/cfg/wdbsvr.app
(Otherwise users will not be able to login to the Personal Home Page or Self-service web apps.)
ii). 8.0.6 Oracle_home : $ORACLE_HOME/reports60/server/CGIcmd.dat
iii). Workflow Notification Mailer - $FND_TOP/resource/wfmail.cfg
6. Start the concurrrent manager script.
7. Start all the application nodes.
8. Application Health checkup.
8. Submit a concurrent request and check that request completes successfully.
No comments:
Post a Comment