Home » Oracle » Oracle Ebuisness Suite » How to change apps password in EBS R12.2

How to change apps password in EBS R12.2

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

cd $ADMIN_SCRIPTS_HOME
./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.

adadminsrvctl.sh start

(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

or

Use the below script post AD-TXK 7

perl $FND_TOP/patch/115/bin/txkManageDBConnectionPool.pl


When prompted, select ‘updateDSPassword’ to change the APPS password in the
WLS Datasource.

See also  How to use RMAN Crosscheck command

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
$WLS_PWD
$APPS_NEW_PWD
EOF

(6) Shutdown the Admin server

adadminsrvctl.sh stop

(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.

Related Articles

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

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top