Sunday 4 December 2016

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

Below steps to change the apps password in Oracle E-Business Suite R12.2

Step 1:

Shut down all the application services by using below script.
$INST_TOP/admin/scripts/adstpall.sh

Step 2:
Change the APPLSYS password by using FNDCPASS
$FNDCPASS apps/<appspwd> 0 Y system/manager SYSTEM APPLSYS WELCOME

Step 3:
Run autoconfig with the newly changed password.

Step 4:
Start AdminServer using the $INST_TOP/admin/scripts/adadminsrvctl.sh script. (Do not start any other application tier services).

Step 5:
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.

Step 6:
Start all the application tier services using the below script
$INST_TOP/admin/scripts/adstrtal.sh

Step 7:
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".