As an oracle apps dba , we often need to reset password for
apps user in E-Business suite . FNDCPASS is an Oracle E-Business Suite utility
used to change application user passwords, Oracle schema passwords, and
APPS/APPLSYS passwords while keeping Oracle EBS metadata synchronized.
Steps to change:-
1. First ensure application is not running or shutdown
application by
Invoke application environment from run file
system
|
[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
sql]$ ./adstpall.sh |
1.
Change the APPLSYS password using
|
Syntax:- FNDCPASS apps/<appspwd> 0 Y
system/<system_manager> SYSTEM APPLSYS <new_apps_passwd> [oracle@ebstest sql]$ FNDCPASS apps/apps 0 Y system/manager SYSTEM
APPLSYS apps123# |
1.
Run autoconfig on appstier
|
[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 |
1.
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: |
Confirm the admin server running status. Don’t start any other application services.
[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 ...
1.
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.
|
[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 |
1.
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. In 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".
No comments:
Post a Comment