Saturday, September 11, 2010

Changing Apps password using FNDCPASS

Oracle provides a utility called FNDCPASS to change apps password,schema passwords,user passwords.There are a few points to remember->APPS and APPLSYS passwords are always same.Changing applsys password will automatically change the apps password

To change apps password->
FNDCPASS apps/<apsppassword> 0 Y system/<systempassword> SYSTEM APPLSYS <newappspassword>
eg->FNDCPASS apps/apps123 0 Y system/manager123 SYSTEM APPLSYS APPS321

To change an application schema password->
FNDCPASS apps/<appspassword> 0 Y system/<systempassword> ORACLE <SCHEMANAME> <newschamepassword>
eg->FNDCPASS apps/apps123 0 Y system/manager123 ORACLE GL GL123

To change all application schema passwords at once. This feature is available from 11i.ATG_PF.H Rollup 3. Also there is a one off patch-4745998 for this feature->
FNDCPASS apps/<appspassword> 0 Y system/<systempassword> ALLORACLE <newschamepassword>
eg->FNDCPASS apps/apps123 0 Y system/manager123 ALLORACLE schemapass123

To change an application user(front-end) password->
FNDCPASS apps/<appspassword> 0 Y system/<systempassword> USER <username> <newuserpassword>
eg->FNDCPASS apps/apps123 0 Y system/manager123 USER ANMGUPTA ANMGUPTA123.
Please note that when changing apps password it is important to run autoconfig to propagate the change across the application or you will need change the apps password in following files manually if it exists.
1. $IAS_ORACLE_HOME\Apache\modplsql\cfg\wdbsvr.app file
2. $FND_TOP/resource/wfmail.cfg
3. $COMMON_TOP/admin/scripts/<context_name>/adcmctl.ch
4. $OA_HTML/bin/appsweb.cfg
5. $AD_TOP/admin/template/CGIcmd.dat

No comments:

Post a Comment