How to Change Applications Passwords Using Applications Schema Password Change Utility

Applications Passwords Using Applications Schema Password Change Utility fndcpass apps password r12

What are the steps to change the APPS, APPLSYS, and APPS_NE password using FNDCPASS for E-Business Suite (EBS) 12.2?

Whenever using FNDCPASS or AFPASSWD to change the APPS, APPLSYS, and APPS_NE password, one must also perform the following actions:

Important:
1.These steps must be carried out on the run file system.
2.The FND_USER and FND_ORACLE_USERID tables should be backed up before any passwords are changed.
3.Remove the backups after you have confirmed that the changes are successfully completed.
4.Passwords for all the 3 schemas, APPS, APPLSYS and APPS_NE will be changed together while changing APPLSYS password.

The following steps are also required:

  1. Shut down the application tier services using the below script:

$INST_TOP/admin/scripts/adstpall.sh22.

2. Change the APPLSYS password using

Use the below syntax:

FNDCPASS apps 0 Y / SYSTEM APPLSYS

Example:

FNDCPASS apps/ebsWelcome@1 0 Y system/manager SYSTEM APPLSYS apps1

Note: Please note that you have $FND_TOP/patch/115/sql/ AFSCJAVS.pls file version 120.12.12020000.8 or above before running FNDCPASS on 12.2.X.

Else you need to apply the patch 19127427 : UNABLE TO CHANGE PASSWORD USING FNDCPASS – NO ERRORS IN THE LOG, If not FNDCPASS with fail to change the password.

  1. Run autoconfig with the newly changed password
  2. Start AdminServer using the $INST_TOP/admin/scripts/adadminsrvctl.sh script. Do not start any other application tier services.
  3. Change the “apps” password in WLS Datasource as follows:

a. Log in to WLS Administration Console.
b. Click Lock & Edit in Change Center.
c. In the Domain Structure tree, expand Services, then select Data Sources.
d. On the “Summary of JDBC Data Sources” page, select EBSDataSource.
e. On the “Settings for EBSDataSource” page, select the Connection Pool tab.
f. Enter the new password in the “Password” field.
g. Enter the new password in the “Confirm Password” field.
h. Click Save.
i. Click Activate Changes in Change Center.

  1. Start all the application tier services using the below script
    $INST_TOP/admin/scripts/adstrtal.sh
  2. Verify the WLS Datastore changes as follows:

a. Log in to WLS Administration Console.
b. In the Domain Structure tree, expand Services, then select Data Sources.
c. On the “Summary of JDBC Data Sources” page, select EBSDataSource.
d. On the “Settings for EBSDataSource” page, select Monitoring > Testing.
e. Select “oacore_server1”.
f. Click Test DataSource
g. Look for the message “Test of EBSDataSource on server oacore_server1 was successful”.

  1. If Integrated SOA Gateway (ISG) is implemented, repeat the steps for “OAEADataSource”. Verify “oafm_cluster*” managed servers are started successfully.

Leave a Comment

Your email address will not be published.