Apps countersign change routine in Release 12.2 E-Business Suite changed a little fleck. We take at present actress options to modify password, likewise 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 Puddle ( JDBC Data source ).  Currently this procedure is not nevertheless automated. It would be skilful, if this can exist automated using some WLS scripting.

Important:These steps must be carried out on therun file organisation.

  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 whatsoever other application tier services.
  1. Alter the "apps" password in WLS Information source equally follows:
    •  Log in to WLS Administration Console.
    • ClickLock & Edit in Change Centre.
    • In the Domain Structure tree, expand Services, then select Information Sources.
    • On the "Summary of JDBC Data Sources" folio, 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 "Ostend Password" field.
    • Click Save.
    • Click Activate Changes in Modify Centre.
  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 Assistants Console.
  3. In the Domain Structure tree, expand Services, so select Data Sources.
  4. On the "Summary of JDBC Data Sources" folio, 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".

Of import: Steps iv, 5 and half dozen are only applicative when irresolute the APPLSYS password. They are not applicative when changing passwords for product schemas or the Organization schema.

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

How To Change The Countersign For The SYSADMIN User
12.2 New Feature AFPASSWD utility to change countersign

Cheers for giving your valuable time to read the above information.

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

Ramkumar's LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://world wide web.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://world wide web.facebook.com/Oracleagent-344577549964301
Ramkumar'south Twitter : https://twitter.com/ramkuma02877110
Ramkumar'due south Telegram: https://t.me/oracleageant
Ramkumar'southward Facebook: https://www.facebook.com/ramkumarram8