What are the steps to change the APPS, APPLSYS, and APPS_NE password using FNDCPASS for E-Business Suite (EBS) 12.2?
1. Shutdown application tier
$INST_TOP/admin/scripts/adstpall.sh apps/<APPS password>
2. Change the APPLSYS password using
A. FNDCPASS
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 patch 19127427.
FNDCPASS apps/<APPS old password> 0 Y system/<SYSTEM password> SYSTEM APPLSYS <APPS new password>
Example:
FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS welcome123
B. AFPASSWD
3. Run Autoconfig
adautocfg.sh appspass=<APPS new password>
4. Start AdminServer
$INST_TOP/admin/scripts/adadminsrvctl.sh start
5. Change the APPS password in WLS Datasource
perl $FND_TOP/patch/115/bin/txkManageDBConnectionPool.pl -options=updateDS -contextfile=${CONTEXT_FILE}-appspass=<APPS new password> -adminpass=<WebLogic admin password>
6. Start the application tier
$INST_TOP/admin/scripts/adstrtal.sh apps/<APPS new password>
7. Verify WLS Datastore changes
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”.
8. Integrated SOA Gateway (ISG)
If Integrated SOA Gateway (ISG) is implemented, repeat the steps for “OAEADataSource”. Verify “oafm_cluster*” managed servers are started successfully.