Pages

Tuesday, October 2, 2007

How to Change APPS Password without running ADCONFIG

Any other ORACLE database user password can be changed simply by the 'alteruser username identified by xxxxx' command. However the APPS user password change procedure in an Oracle Applications 11i instance has got a few more additional steps. In this post i will outline all the steps required without running the adconfig utility as well as the verification process after changing the password

APPS password change procedure WITHOUT running adconfig

Login to any of the admin tiers of the 11i instance

FNDCPASS apps/old_pwd 0 Y system/sys_pwd SYSTEM APPLSYS new_pwd

Edit $ORACLE_HOME/reports60/server/CGIcmd.dat and update with the new password

Login to all of the middle tiers of the 11i instance (or just one of them if its a shared appl tier configuration)

Edit the following files and update them with the new password

$FND_TOP/bin/appsweb.cfg

$FND_TOP/resource/wfmail.cfg

$ORACLE_HOME/reports60/server/CGIcmd.dat

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

Recreate any database links that are owned by the apps user

Update any 3rd party tools, interfaces or scripts that have the password hardcoded

APPS password change procedure WITH adconfig

Login to any of the admin tiers of the 11i instance

FNDCPASS apps/old_pwd 0 Y system/sys_pwd SYSTEM APPLSYS new_pwd

Backup any customizations in the configuration files

cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME and run adautocfg.sh

Restore the customizations to the configuration files

Login to all of the middle tiers of the 11i instance (or just one of them if its a shared appl tier configuration)

Backup any customizations in the configuration files

cd $COMMON_TOP/admin/scripts/$CONTEXT_NAME and run adautocfg.sh

Restore the customizations to the configuration files

Recreate any database links that are owned by the apps user

Update any 3rd party tools, interfaces or scripts that have the password hardcoded

Verification

Login to the database as apps user

Complete the AOL/J diagnostic test. This webpage asks for the new apps password and tries to complete a jdbc connection. http://11i_web_URL:port/OA_HTML/jsp/fnd/aoljtest.jsp

Conclusion

There may be lot of customizations in the configuration files that are generated by the adautocfg.sh. Saving and restoring them each and every time adautocfg.sh is run is the key to a successful apps password change procedure when adconfig is run (adautocfg.sh). If one is not sure about all the customizations in the configuration files, one can choose the first procedure above WITHOUT running adconfig.

Introduction Have you seen your VNC Viewer showing a black screen intermittently ? We have a fix for it. This issue has been occurrin...

Copyright and Disclaimer Notice

Copyright 2007 - 2017 DBA University, Inc. All Rights Reserved. No content of this website may be reprinted or otherwise reproduced without DBA University's permission. The posts and comments in this blog are on an "AS IS" basis without warranties. Always test your changes before pushing them to a real-time system !

Oracle is a registered trademark of Oracle Corporation and/or its affiliates .Other names may be trademarks of their respective owners.