Command Line Option To Change the "APPS" Password In WLS Datasource (Doc ID 2042003.1)

APPLIES TO:

Oracle E-Business Suite Technology Stack - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

GOAL

How to change  change the "apps" password in WLS Datasource in 12.2
 

SOLUTION

1. Source the environment file

2. Run the following

perl $FND_TOP/patch/115/bin/txkManageDBConnectionPool.pl -options= updateDS -contextfile=<context_file_path> -appspass=<APPS password> -adminpass=<WebLogic admin password>

Note:

Depending on the version of script txkManageDBConnectionPool.pl (pre/post AD-TXK 7) the options for the script can change from:

# | -options : Below is the list of valid options
# | changeCPtoWLS : To enable WLS DataSource Pool mode
# | changeCPtoAOLJ : To enable AOLJ Connection Pool mode
# | updateDSJdbcUrl : To update WebLogic Datasource Connection String
# | updateDS : To update WebLogic Datasource Connection String and APPS schema password

To:

# | -options : Below is the list of valid options
# | updateDSPassword : To update WebLogic Datasource Connection String
# | updateDSJdbcUrl : To update WebLogic Datasource Connection String

Check the available options and  determine which version be used.

For more information reference the following document:

Note 2033780.1 - Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.7 and R12.TXK.C.Delta.7 (Doc ID 2033780.1)
4.8 Simplified Procedure for Changing WLS Data Source

Another option for post AD-TXK 7 only per the Oracle® E-Business Suite Maintenance Guide Release 12.2 Part No. E22954-23:

1. Shut down the application tier services using the
$INST_TOP/admin/scripts/adstpall.sh script.
2. Change the APPLSYS password, as described for the utility you are using.
3. Start AdminServer using the $INST_TOP/admin/scripts/adadminsrvctl.sh
script. Do not start any other application tier services.
4. Change the APPS password in WLS Data Source by running the the following
script as shown:
$ perl $FND_TOP/patch/115/bin/txkManageDBConnectionPool.pl
When prompted, select 'updateDSPassword' to change the APPS password in the
WLS Datasource.
5. Start all the application tier services using the
$INST_TOP/admin/scripts/adstrtal.sh script.