How to Reset APPS Password in Oracle E-Business Suite R12.2 (OMCLONE Instance)
If you're working with an Oracle E-Business Suite (EBS) R12.2 clone or non-production environment and need to reset the APPS schema password, this guide walks you through the process—from backup to successful login.
Step 1: Take Backup of Critical Tables
Before changing anything, always back up the relevant security-related tables.
SQL> create table FND_USER_146202 as select * from FND_USER;
Table created.
SQL> create table FND_ORACLE_USERID_146202 as select * from FND_ORACLE_USERID;
Table created.
===
Step 2: Use AFPASSWD Utility to Change the APPS Password
Navigate to your application server and run the following command:
You will be prompted to:
-
Enter current APPS schema password
-
Enter SYSTEM password
-
Provide new password twice for the APPS user
appclone @ >AFPASSWD -c APPS@OMCLONE -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.
Logfile: AFPWD_OMCLONE_056039.log
Enter new password for user:
Verify new password for user:
AFPASSWD completed successfully.
Check the log fil
appclone @ omdevapp/u02/app/oracle/fs1/inst/apps/OMCLONE_omdevapp/admin/scripts >
==
Enter the Current APPS Password when prompted
Enter the System password when prompted
Enter the new password twice for the APPS user
check the Log file
+----------------------------------------------------------------------------+
Application Object Library - AFPASSWD
+----------------------------------------------------------------------------+
Copyright (c) 1998, 2019, Oracle and/or its affiliates. All rights reserved.
+----------------------------------------------------------------------------+
The current system time is 13-JUN-20 13:46:38
+----------------------------------------------------------------------------+
Arguments
AFPASSWD -c APPS@OMCLONE -s APPLSYS
+----------------------------------------------------------------------------+
Working...
AFPASSWD completed successfully.
+----------------------------------------------------------------------------+
Current system time is 13-JUN-20 13:47:11
+----------------------------------------------------------------------------+
~
===
Step 3: Start the Admin Server
You'll be prompted to enter:
WebLogic Admin password
New APPS password
This will start the AdminServer, and you can monitor logs
Start the Admin Server
appclone @ omdevapp/home/appclone > $INST_TOP/admin/scripts/adadminsrvctl.sh start
You are running adadminsrvctl.sh version 120.10.12020000.11
Enter the WebLogic Admin password:
Enter the APPS Schema password:
Starting WLS Admin Server...
Refer /u02/app/oracle/fs1/inst/apps/OMCLONE_omdevapp/logs/appl/admin/log/adadminsrvctl.txt for details
AdminServer logs are located at /u02/app/oracle/fs1/FMW_Home/user_projects/domains/EBS_domain_OMCLONE/servers/AdminServer/logs
adadminsrvctl.sh: exiting with status 0
adadminsrvctl.sh: check the logfile /u02/app/oracle/fs1/inst/apps/OMCLONE_omdevapp/logs/appl/admin/log/adadminsrvctl.txt for more information ...
Pass the WebLogic Admin Password
Pass the APPS Password -- changed one
appclone @ omdevapp/home/appclone >
-==
Step 4: Update WebLogic Datasource with New Password
Update the password using the txkManageDBConnectionPool.pl command
When prompted, enter:
-
Applications Context File path (or accept default)
-
WebLogic Admin password
-
New APPS password
appclone @ omdevapp/u02/app/oracle/fs1/EBSapps/appl/fnd/12.0.0/patch/115/bin >ll txkManageDBConnectionPool.pl
-rwxr-xr-x 1 appclone oinstall 28158 May 25 21:22 txkManageDBConnectionPool.pl
appclone @ omdevapp/u02/app/oracle/fs1/EBSapps/appl/fnd/ 212.0.0/patch/115/bin >perl txkManageDBConnectionPool.pl
Please select from list of valid options
updateDSPassword - Update WebLogic Datasource Password
updateDSJdbcUrl - Update WebLogic Datasource Connection String
Enter Your Choice : updateDSPassword
Enter the full path of Applications Context File [DEFAULT - /u02/app/oracle/fs1/inst/apps/OMCLONE_omdevapp/appl/admin/OMCLONE_omdevapp.xml]:
Enter weblogic admin server password:
Enter the APPS user password:
---------------------------------------------
Performing Steps for option=updateDSPassword
---------------------------------------------
Updating WLS DataSource Password
--------------------------------
Initializing WebLogic Scripting Tool (WLST) ...
Welcome to WebLogic Server Administration Scripting Shell
Type help() for help on available commands
Connecting to t3://omdevapp.oasiserp.com:7001 with userid weblogic ...
Successfully connected to Admin Server 'AdminServer' that belongs to domain 'EBS_domain_OMCLONE'.
Warning: An insecure protocol was used to connect to the
server. To ensure on-the-wire security, the SSL port or
Admin port should be used instead.
Domain Update successful
------------------------
appclone @ omdevapp/u02/app/oracle/fs1/EBSapps/appl/fnd/12.0.0/patch/115/bin >
====
Step 5: Run AutoConfig on the Database Tier
This will:
-
Update context files
-
Configure DB templates
-
Upload changes to DB
oraclone @ omdevdb/u03/app/oracle/product/12.1.0/dbhome_1/appsutil/scripts/OMCLONE_omdevdb >sh adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u03/app/oracle/product/12.1.0/dbhome_1/appsutil/log/OMCLONE_omdevdb/06131400/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u03/app/oracle/product/12.1.0/dbhome_1
Classpath : :/u03/app/oracle/product/12.1.0/dbhome_1/jdbc/lib/ojdbc6.jar:/u03/app/oracle/product/12.1.0/dbhome_1/appsutil/java/xmlparserv2.jar:/u03/app/oracle/product/12.1.0/dbhome_1/appsutil/java:/u03/app/oracle/product/12.1.0/dbhome_1/jlib/netcfg.jar:/u03/app/oracle/product/12.1.0/dbhome_1/jlib/ldapjclnt12.jar
Using Context file : /u03/app/oracle/product/12.1.0/dbhome_1/appsutil/OMCLONE_omdevdb.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Updating rdbms version in Context file to db121
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.
oraclone @ omdevdb/u03/app/oracle/product/12.1.0/dbhome_1/appsutil/scripts/OMCLONE_omdevdb >
Step 6: Run AutoConfig on the Application Tier
This ensures the application context is updated with the new APPS password.
appclone @ omdevapp/u02/app/oracle/fs1/inst/apps/OMCLONE_omdevapp/admin/scripts >sh adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u02/app/oracle/fs1/inst/apps/OMCLONE_omdevapp/admin/log/06131404/adconfig.log
wlsDomainName: EBS_domain_OMCLONE
WLS Domain Name is VALID.
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /u02/app/oracle/fs1/inst/apps/OMCLONE_omdevapp
Classpath : /u02/app/oracle/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u02/app/oracle/fs1/EBSapps/comn/java/classes
Using Context file : /u02/app/oracle/fs1/inst/apps/OMCLONE_omdevapp/appl/admin/OMCLONE_omdevapp.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring MSC_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring CZ_TOP........COMPLETED
Configuring SHT_TOP.......COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring GMF_TOP.......COMPLETED
Configuring PON_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED
AutoConfig completed successfully.
====
Run adstrtal.sh -- login to the applications and check
Final Step: Login and Validate
Once all services are up, log in to the EBS application using the new APPS credentials and confirm everything works as expected.
| Step | Description |
|---|---|
| 1 | Backup FND_USER and FND_ORACLE_USERID |
| 2 | Use AFPASSWD to reset password |
| 3 | Restart Admin Server |
| 4 | Update WebLogic DataSource password |
| 5 | Run AutoConfig on DB Tier |
| 6 | Run AutoConfig on App Tier |
| 7 | Start EBS services |
| 8 | Login and verify |
