Steps to change password for APPS in EBS R 12.2

 Environment Details

Hostname	ebstest.wizer.com
Database Version	12.1.0.2
E Business Suite Version	R 12.2
OS	OEL 7.7
R12 install base	/u01/oracle/VIS

 

Important:- Before changing the password for APPS, APPLSYS and APPS_NE the following tables should be backed up .

1. FND_USER

2. FND_ORACLE_USERID

 Step 1.

Take backup SQL> create table FND_USER_291220 as select * from FND_USER ;  Table created.  SQL> create table FND_ORACLE_USERID_291220 as select * from FND_ORACLE_USERID ;  Table created.

 

 

Step 2. Shutdown apps tier

Invoke application environment file of fs1 [oracle@ebstest VIS]$ cd /u01/oracle/VIS/fs1/EBSapps/appl [oracle@ebstest VIS]$ . APPSVIS_ebstest.env [oracle@ebstest sql]$ cd $ADMIN_SCRIPTS_HOME [oracle@ebstest scripts]$ adstpall.sh

Step 3. Change APPLSYS password. We can use two methods for changing password.

1.       FNDCPASS

2.       AFPASSWD

Here I will be using AFPASSWD utility to change the password.

syntax:- AFPASSWD [-c <APPSUSER>[@<TWO_TASK>]] -s <APPLSYS> [oracle@ebstest appl]$ AFPASSWD -c apps@VIS -s APPLSYS Enter the ORACLE password of Application Object Library 'APPSUSER': Connected successfully to APPS. Enter the password for your 'SYSTEM' ORACLE schema: Connected successfully to SYSTEM. Log file: AFPWD_VIS_239350.log Enter new password for user: Verify new password for user: AFPASSWD completed successfully.

Step 4. Run autoconfig on AppsTier with  newly changed apps password

[oracle@ebstest VIS]$ cd /u01/oracle/VIS/fs1/EBSapps/appl [oracle@ebstest VIS]$ . APPSVIS_ebstest.env [oracle@ebstest scripts]$ cd $ADMIN_SCRIPTS_HOME [oracle@ebstest scripts]$ adautocfg.sh …… …… AutoConfig completed successfully.

 

Step 5. Now start weblogic admin server using following script

[oracle@ebstest scripts]$ pwd /u01/oracle/VIS/fs1/inst/apps/VIS_ebstest/admin/scripts  [oracle@ebstest scripts]$ sh adadminsrvctl.sh start You are running adadminsrvctl.sh version 120.10.12020000.2  Enter the WebLogic Admin password: Enter the APPS Schema password:

 

Step 6. Confirm the admin server running status

[oracle@ebstest scripts]$ sh adadminsrvctl.sh status  You are running adadminsrvctl.sh version 120.10.12020000.2  Enter the WebLogic Admin password: Enter the APPS Schema password:   The AdminServer is running  adadminsrvctl.sh: exiting with status 0  adadminsrvctl.sh: check the logfile /u01/oracle/VIS/fs1/inst/apps/VIS_ebstest/logs/appl/admin/log/adadminsrvctl.txt for more information ...

Step 7 .  Now login to weblogic console from browser

Click on Lock and Edit button

Now under Domain structure, click on services - > Data Sources

Now click on “EBSDataSource”

Now on the page of “Settings of EBSDataSoure” click on connection pool and  provide the changed apps password and save it.

Click on Activate changes.

Step 8 . Start the application services.

[oracle@ebstest appl]$ pwd /u01/oracle/VIS/fs1/EBSapps/appl  [oracle@ebstest appl]$ adstrtal.sh  You are running adstrtal.sh version 120.24.12020000.6  Enter the APPS username: apps  Enter the APPS password: Enter the WebLogic Server password: …. …. All enabled services for this node are started.  adstrtal.sh: Exiting with status 0

 

 

Step 9. Verify the WLS Datastore changes by doing followings

Ø  Log in to WLS Administration Console.

Ø  In the Domain Structure tree, expand Services, then select Data Sources.

Ø  On the "Summary of JDBC Data Sources" page, select EBSDataSource.

  OIn the "Settings for EBSDataSource" page, select Monitoring > Testing.

Ø  Select "oacore_server1".

Ø  Click Test DataSource

Ø  Look for the message "Test of EBSDataSource on server oacore_server1 was successful".

 

So this concludes the process of changing password for APPS in EBS R12.2

Ø