Step 1: Shut down the UAT applications on apps1 & apps2
Step 2: Change the 'apps' password using 'FNDCPASS'
FNDCPASS apps/welcome123 0 Y DBV_ACCTMGR/welcome1 SYSTEM APPLSYS welcome1
applmgr@pansoft01 scripts]$ pwd
/u01/oracle/uaterp/fs2/inst/apps/UATERP_pansoft01/admin/scripts
[applmgr@pansoft01 scripts]$ FNDCPASS apps/welcome123 0 Y DBV_ACCTMGR/welcome1 SYSTEM APPLSYS welcome1
Log filename : L3696582.log
Report filename : O3696582.out
[applmgr@pansoft01 scripts]$ more L3696582.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.2
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
FNDCPASS:
+---------------------------------------------------------------------------+
Current system time is 08-AUG-2019 09:44:05
+---------------------------------------------------------------------------+
Arguments
FNDCPASS system/***** SYSTEM APPLSYS *****
+----------------------------------------------------------------------------+
Working...
FNDCPASS completed successfully.
+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 08-AUG-2019 09:44:09
+---------------------------------------------------------------------------+
[applmgr@pansoft01 scripts]$
Step 3: Disable Database Vault using dbv_owner
/home/oraprod/DBA/scripts/vault
SQL> select name from v$database;
NAME
---------
UATERP
SQL> @fnddbvstatus.sql DISABLE
PL/SQL procedure successfully completed.
Commit complete.
Step 4:Execute Autoconfig on DB node1 & DB node2 and Apps node1 & Apps node2
DB1:
===
[oraprod@pansoftd01 uaterp1_pansoftd01]$ pwd
/u01/app/oracle/product/12.1.0/dbhome_1/appsutil/scripts/uaterp1_pansoftd01
[oraprod@pansoftd01 uaterp1_pansoftd01]$ ./adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/app/oracle/product/12.1.0/dbhome_1/appsutil/log/uaterp1_pansoftd01/08081005/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u01/app/oracle/product/12.1.0/dbhome_1
Classpath : :/u01/app/oracle/product/12.1.0/dbhome_1/jdbc/lib/ojdbc6.jar:/u01/app/oracle/product/12.1.0/dbhome_1/appsutil/java/xmlparserv2.jar:/u01/app/oracle/product/12.1.0/dbhome_1/appsutil/java:/u01/app/oracle/product/12.1.0/dbhome_1/jlib/netcfg.jar:/u01/app/oracle/product/12.1.0/dbhome_1/jlib/ldapjclnt12.jar
Using Context file : /u01/app/oracle/product/12.1.0/dbhome_1/appsutil/uaterp1_pansoftd01.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.
DB2:
=====
[oraprod@pansoftd02 uaterp2_pansoftd02]$ pwd
/u01/app/oracle/product/12.1.0/dbhome_1/appsutil/scripts/uaterp2_pansoftd02
[oraprod@pansoftd02 uaterp2_pansoftd02]$ ./adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/app/oracle/product/12.1.0/dbhome_1/appsutil/log/uaterp2_pansoftd02/08081015/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u01/app/oracle/product/12.1.0/dbhome_1
Classpath : :/u01/app/oracle/product/12.1.0/dbhome_1/jdbc/lib/ojdbc6.jar:/u01/app/oracle/product/12.1.0/dbhome_1/appsutil/java/xmlparserv2.jar:/u01/app/oracle/product/12.1.0/dbhome_1/appsutil/java:/u01/app/oracle/product/12.1.0/dbhome_1/jlib/netcfg.jar:/u01/app/oracle/product/12.1.0/dbhome_1/jlib/ldapjclnt12.jar
Using Context file : /u01/app/oracle/product/12.1.0/dbhome_1/appsutil/uaterp2_pansoftd02.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.
[oraprod@pansoftd02 uaterp2_pansoftd02]$
APP1:
======
[applmgr@pansoft01 scripts]$ ./adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/oracle/uaterp/fs2/inst/apps/UATERP_pansoft01/admin/log/08081016/adconfig.log
wlsDomainName: EBS_domain
WLS Domain Name is VALID.
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /u01/oracle/uaterp/fs2/inst/apps/UATERP_pansoft01
Classpath : /u01/oracle/uaterp/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/oracle/uaterp/fs2/EBSapps/comn/java/classes
Using Context file : /u01/oracle/uaterp/fs2/inst/apps/UATERP_pansoft01/appl/admin/UATERP_pansoft01.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.
APP2:
=======
[applmgr@pansoft02 scripts]$ ./adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/oracle/uaterp/fs2/inst/apps/UATERP_pansoft02/admin/log/08081041/adconfig.log
wlsDomainName: EBS_domain
WLS Domain Name is VALID.
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /u01/oracle/uaterp/fs2/inst/apps/UATERP_pansoft02
Classpath : /u01/oracle/uaterp/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/oracle/uaterp/fs2/EBSapps/comn/java/classes
Using Context file : /u01/oracle/uaterp/fs2/inst/apps/UATERP_pansoft02/appl/admin/UATERP_pansoft02.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.
[applmgr@pansoft02 scripts]$
Step 5:Start the admin server from apps1
[applmgr@pansoft01 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 /u01/oracle/uaterp/fs2/inst/apps/UATERP_pansoft01/logs/appl/admin/log/adadminsrvctl.txt for details
AdminServer logs are located at /u01/oracle/uaterp/fs2/FMW_Home/user_projects/domains/EBS_domain/servers/AdminServer/logs
adadminsrvctl.sh: exiting with status 0
adadminsrvctl.sh: check the logfile /u01/oracle/uaterp/fs2/inst/apps/UATERP_pansoft01/logs/appl/admin/log/adadminsrvctl.txt for more information ...
[applmgr@pansoft01 scripts]$
Step 6: Change the apps password in Data Sources by login to Weblogic console
Step 7: Test connectivity with sqlplus
APP1:
=====
applmgr@pansoft01 scripts]$ sqlplus apps
SQL*Plus: Release 10.1.0.5.0 - Production on Thu Aug 8 10:58:54 2019
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options
SQL> select name from v$database;
NAME
---------
UATERP
SQL> show user
USER is "APPS"
[applmgr@pansoft02 scripts]$ sqlplus apps
SQL*Plus: Release 10.1.0.5.0 - Production on Thu Aug 8 10:59:03 2019
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics, Oracle Database Vault and Real Application Testing options
SQL> select name from v$database;
NAME
---------
UATERP
SQL> sho user
USER is "APPS"
Step 9 : Start the applications from APP1 & APP2.
Step 10: Validate the Applications.
Step 11: Validate the SSO
No comments:
Post a Comment