Apps password change in R12.1/R12.0 just requires changing password using FNDCPASS and then running autoconfig. But R12.2 introduced weblogic in the Techstack, so we need to change the apps password in WebLogic also. We need to follow a few steps while changing the apps password in EBS R12.2. They are given as below
Steps to change apps password in EBS R12.2
(1) Shutdown the apps
./adstpall.sh apps/<apps pass> -mode=allnode
(2)Kill any remaining process
(3) Change the apps Password
FNDCPASS apps/<old pass> 0 y system/ SYSTEM APPLSYS <new pass>
We should not be changing the password from the database using the command
alter user apps identified by "new pass"
(4) Started weblogic server before running autoconfig to change the datasource.
(5) Login to Admin console to change apps pwd for the datasource
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.
If you have SSO implemented, then additional steps will be required to change the change. In the case of the Access gateway, we will need to change the password in additional data sources in Weblogic
Use the below script post AD-TXK 7
When prompted, select ‘updateDSPassword’ to change the APPS password in the
Or you can this the below script in a non-interactive way
perl $FND_TOP/patch/115/bin/txkManageDBConnectionPool.pl -options=updateDSPassword -contextfile=$CONTEXT_FILE <<EOF
(6) Shutdown the Admin server
(7) Run autoconfig on all the nodes
(8) If you have customization lost after autoconfig, you can fix it now
(9) If you have any DB links using the apps password, please recreate the DB link with the new password
(8) Start the services on all the nodes
cd $ADMIN_SCRIPTS_HOME ./adstrall.sh apps/<apps pass> -mode=allnode
I hope these steps are clear and help you change apps password in EBS R12.2 successfully.
FNDCPASS: FNDCPASS & AFPASSWD is the utility used to change the apps schema, Oracle EBS schema and user password in Oracle EBS all versions
ADOP command: Check out 31 Useful adop (AD online patching ) command lines for R12.2. how to abort, apply, prepare, NLS patches, hrglobal patches in R12.2
How to find ad and txk patch level : Check out How to find ad and txk patch level, how to check delta level in r12, how to check fwk in r12.2, how to check ATG patch level
Adop(Ad online patching utility) explained R12.2
what happens in the adop phase prepare