Tuesday 12 April 2016

How to change the apps password in oracle apps R12.2.4

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

1. Shut down the application tier services
$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.

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

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

7. Now start all the services on application tier.
$INST_TOP/admin/scripts/
sh adstrtal.sh

Note: These steps must be carried out on the run file system.

No comments:

Post a Comment