How to change Apps Password in R12.2

 

Apps password change routine in Release 12.2 E-Business Suite changed a little bit. We have now extra options to change password, as well as some manual steps after changing the password using FNDCPASS.

Whether you use FNDCPASS or AFPASSWD to change the APPLSYS/APPS password, you must also perform some additional steps. This is because in R12.2, the old AOL/J connection pooling is replaced with Weblogic Connection Pool ( JDBC Data source ).  Currently this procedure is not yet automated. It would be good, if this can be automated using some WLS scripting.

Important: These steps must be carried out on the run file system.

  1. Shut down the application tier services using the $INST_TOP/admin/scripts/adstpall.sh script.
  1. Change the APPLSYS password, as described for the utility you are using.
  1. Start Admin Server using the $INST_TOP/admin/scripts/adadminsrvctl.sh script. Do not start any other application tier services.
  1. Change the “apps” password in WLS Data source as follows:
    •  Log in to WLS Administration Console.
    • Click Lock & Edit in Change Center.
    • In the Domain Structure tree, expand Services, then select Data Sources.
    • On the “Summary of JDBC Data Sources” page, select EBSDataSource.
    • On the “Settings for EBSDataSource” page, select the Connection Pool tab.
    • Enter the new password in the “Password” field.
    • Enter the new password in the “Confirm Password” field.
    • Click Save.
    • Click Activate Changes in Change Center.
  1. Start all the application tier services using the $INST_TOP/admin/scripts/adstrtal.sh script.
  1. Verify the WLS Datastore changes as follows:
  2. Log in to WLS Administration Console.
  3. In the Domain Structure tree, expand Services, then select Data Sources.
  4. On the “Summary of JDBC Data Sources” page, select EBSDataSource.
  5. On the “Settings for EBSDataSource” page, select Monitoring > Testing.
  6. Select “oacore_server1“.
  7. Click Test Data Source
  8. Look for the message “Test of EBSDataSource on server oacore_server1 was successful“.

Important: Steps 4, 5 and 6 are only applicable when changing the APPLSYS password. They are not applicable when changing passwords for product schemas or the SYSTEM schema.

In the next prepare phase after the password change, adop will invoke EBS Domain Configuration to ensure that the WLS data source on the patch file system will be synchronized with the new APPS password.

How To Change The Password For The SYSADMIN User
12.2 New Feature AFPASSWD utility to change password

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8