How to change apps password in R12.2.x Oracle E-Business Suite

Changing apps password in R12.2.x is as similar as R12.1.x, but by having Weblogic Server in R12.2.x, we have one additional step as Weblogic Data Sources will also be pointing to apps schema.

  1. Source Run Edition
  2. Shutdown Middle Tier Services ($ADMIN_SCRIPTS_HOME/adstpall.sh (ON ALL NODES IF IT IS MULTI-NODE))
  3. Change APPLSYS password using FNDCPASS (FNDCPASS apps/apps 0 Y system/manager SYSTEM applsys newpwd)
  4. Start Weblogic AdminServer ($ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start) Do not start other services.
  5. Login as “Weblogic user” to Weblogic Server Admin Console (http://test.appsdbatraining.com:7001/console)
  6. Click on Lock & Edit in Change Center to lock the configurations.
  7. Click on “Data Sources” and on “Summary of JDBC Data Sources” page, select “settings” of EBSDataSource.
  8. Click on Connection Pool tab and then enter new password in “Password” field.
  9. Once done Click Save and then click on “Activate Changes” in Change Center.
  10. Shutdown Weblogic AdminServer ($ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop)
  11. Run Autoconfig ($ADMIN_SCRIPTS_HOME/adautocfg.sh)
  12. Start Middle Tier Servcies ($ADMIN_SCRIPTS_HOME/adstrtal.sh)

Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."

Latest posts by Nagulu Polagani (see all)