Wednesday 21 October 2015

How to change the apps user password in oracle apps 12.2.4

Below steps are to change the apps password in R12.2.4

1. Shut down the application tier services using the

$INST_TOP/admin/scripts/adstpall.sh

2. Change the APPLSYS password.

FNDCPASS apps/<existing apps passwd>  0 Y system/<system password> SYSTEM APPLSYS <new apps passwd>

FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS newpasswd

3. Start AdminServer using the $INST_TOP/admin/scripts/adadminsrvctl.sh
Note:Don't start any other application tier services.

4. Change the "apps" password in WLS Datasource as follows:
Log in to WLS Administration Console. (http:/krishna.appsdba.com:7002/console)

Click Lock & Edit in Change Center.
In the Domain Structure tree, expand Services, then select Data Sources.
On the “Summary of JDBC Data Sources” page, select EBSDataSource
On the “Settings for EBSDataSource” page, select the Connection Pool tab.
Enter the new password in the “Password” field.
Enter the new password in the “Confirm Password” field.
Click Save.

Check whether you are able to connect to db using apps
sqlplus apps/<newpassword> from application tier.

Before Starting all the services. Run Autoconfig.
cd $ADMIN_SCRIPTS_HOME
sh adautocfg.sh

Now start the services.
Start all the application tier services using the
$INST_TOP/admin/scripts/adstrtal.sh script.

No comments:

Post a Comment