./adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /oracledb/TEST/db/tech_st/12.1.0/appsutil/log/WLAUAT_wonderlauat/10051106/adconfig.log
AutoConfig is configuring the Database environment…
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /oracledb/TEST/db/tech_st/12.1.0
Classpath : :/oracledb/TEST/db/tech_st/12.1.0/jdbc/lib/ojdbc6.jar:/oracledb/TEST/db/tech_st/12.1.0/appsutil/java/xmlparserv2.jar:/oracledb/TEST/db/tech_st/12.1.0/appsutil/java:/oracledb/TEST/db/tech_st/12.1.0/jlib/netcfg.jar:/oracledb/TEST/db/tech_st/12.1.0/jlib/ldapjclnt12.jar
Using Context file: /oracledb/TEST/db/tech_st/12.1.0/appsutil/TEST_testdb.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.
/test/applmgr/fs1/EBSapps/comn/clone/bin
[applmgrt@testapps bin]$ perl adcfgclone.pl appsTier dualfs
Copyright (c) 2002, 2015 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adcfgclone Version 120.63.12020000.56
Enter the APPS password :
Enter the Weblogic AdminServer password :
Do you want to add a node (yes/no) [no] : no
Running: Context clone…
Log file located at /test/applmgr/fs1/EBSapps/comn/clone/bin/CloneContext_1005111910.log
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [testapps] :
Target System Database SID : TEST
Target System Database Server Node [testdb] : testdb
Target System Database Domain Name [xyz.com] : xyz.org
Target System Base Directory : /test/applmgr
Target System Base Directory set to /test/applmgr
Target System Current File System Base set to /test/applmgr/fs1
Target System Other File System Base set to /test/applmgr/fs2
Target System Fusion Middleware Home set to /test/applmgr/fs1/FMW_Home
Target System Other File System Fusion Middleware Home set to /test/applmgr/fs2/FMW_Home
Target System Web Oracle Home set to /test/applmgr/fs1/FMW_Home/webtier
Target System Other File System Web Oracle Home set to /test/applmgr/fs2/FMW_Home/webtier
Target System Appl TOP set to /test/applmgr/fs1/EBSapps/appl
Target System Other File System Appl TOP set to /test/applmgr/fs2/EBSapps/appl
Target System COMMON TOP set to /test/applmgr/fs1/EBSapps/comn
Target System Other File System COMMON TOP set to /test/applmgr/fs2/EBSapps/comn
Target System Instance Home Directory [/test/applmgr] :
Target System Current File System Instance Top set to /test/applmgr/fs1/inst/apps/TEST_testapps
Do you want to preserve the Display [oraebsapps:0.0] (y/n) : n
Target System Display [testapps:0.0] : testapps:1.0
Target System Root Service [enabled] :
Target System Web Entry Point Services [enabled] :
Target System Web Application Services [enabled] :
Target System Batch Processing Services [enabled] :
Target System Other Services [disabled] :
Do you want the target system to have the same port values as the source system (y/n) [y] ? : n
Target System Port Pool [0-99] : 15
Checking the port pool 15
done: Port Pool 15 is free
Report file located at /test/applmgr/fs1/inst/apps/TEST_testapps/admin/out/portpool.lst
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /usr/tmp
3. /oracledb/TEST/db/tech_st/12.1.0/appsutil/outbound/TEST_testdb
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] : 1
The new APPL_TOP context file has been created :
/test/applmgr/fs1/inst/apps/TEST_testapps/appl/admin/TEST_testapps.xml
Check Clone Context logfile /test/applmgr/fs1/EBSapps/comn/clone/bin/CloneContext_1005111910.log for details.
Creating Patch file system context file…..
Log file located at /test/applmgr/fs1/EBSapps/comn/clone/bin/CloneContextPatch_1005112418.log
Target System Other File System Instance Top set to /test/applmgr/fs2/inst/apps/TEST_testapps
Target System Port Pool [0-99] : 16
Checking the port pool 16
done: Port Pool 16 is free
Report file located at /test/applmgr/fs2/inst/apps/TEST_testapps/admin/out/portpool.lst
The new APPL_TOP context file has been created :
/test/applmgr/fs2/inst/apps/TEST_testapps/appl/admin/TEST_testapps.xml
Check Clone Context logfile /test/applmgr/fs1/EBSapps/comn/clone/bin/CloneContextPatch_1005112418.log for details.
FMW Pre-requisite check log file location : /test/applmgr/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: FMW pre-req check…
Configuring: Run file system….
LogFile located at /test/applmgr/fs1/inst/apps/TEST_testapps/admin/log/clone/run/RCloneApplyAppstier_10051124.log
Configuring: Patch file system….
LogFile located at /test/applmgr/fs2/inst/apps/TEST_testapps/admin/log/clone/run/RCloneApplyAppstier_10061125.log
Post-Clone Steps:
1. System password changed in Database
SQL>alter user system identified by welcome123;
2. Apps Password changed
Syntax:
FNDCPASS apps/<old password> 0 y system/Password SYSTEM APPLSYS <apss new password>
FNDCPASS apps/PassW0rd 0 y system/welcome123 SYSTEM APPLSYS apps123
3.Sysadmin Password Changed
FNDCPASS apps/<apps new password> 0 y system/Password USER SYSADMIN <sysadmin Password>
FNDCPASS apps/apps123 0 y system/welcome123 USER SYSADMIN Welcome#123
4.Weblogic console to connect :
Note: Weblogic to connect need to start the Admin server
[applmgr@testapps scripts]$ adadminsrvctl.sh start
You are running adadminsrvctl.sh version 120.10.12020000.10
Enter the WebLogic Admin password:
Enter the APPS Schema password:
Starting WLS Admin Server…
Refer /test/applmgr/fs1/inst/apps/TEST_testapps/logs/appl/admin/log/adadminsrvctl.txt for details
AdminServer logs are located at /test/applmgr/fs1/FMW_Home/user_projects/domains/EBS_domain_TEST/servers/AdminServer/logs
adadminsrvctl.sh: exiting with status 0
adadminsrvctl.sh: check the logfile /test/applmgr/fs1/inst/apps/TEST_testapps/logs/appl/admin/log/adadminsrvctl.txt for more information …
[applmgr@testapps scripts]$
To find out WebLogic console:
grep -i “wls_admin” $CONTEXT_FILE
[applmgr@testapps TEST]$ grep -i “wls_admin” $CONTEXT_FILE
<wls_admin_host oa_var=”s_wls_admin_host”>testdb</wls_admin_host>
<wls_admin_domain oa_var=”s_wls_admin_domain”>.xyz.org</wls_admin_domain>
<wls_admin_user oa_var=”s_wls_admin_user”>weblogic</wls_admin_user>
<wls_adminport oa_var=”s_wls_adminport” oa_type=”PORT” base=”7001″ step=”1″ range=”-1″ label=”WLS Admin Server Port”>7016</wls_adminport>
[appluat@wonderlauat WLAUAT]$
[appluat@wonderlauat WLAUAT]$ grep login $CONTEXT_FILE
<login_page oa_var=”s_login_page”>http://testdb.xyz.org:8015/OA_HTML/AppsLogin</login_page>
The WebLogic Console is: http://testdb.xyz.org:7016/console
login in Web console
+ services
+ Data sourecs
+ EBS Data sources
+ Connection Pool
Apps Username <apps>
Apps Password <apps123>
and Save it
Auto Config Run in Database and Application:
1.Database :
./adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /oracledb/TEST/db/tech_st/12.1.0/appsutil/log/WLAUAT_wonderlauat/10051106/adconfig.log
AutoConfig is configuring the Database environment…
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /oracledb/TEST/db/tech_st/12.1.0
Classpath : :/oracledb/TEST/db/tech_st/12.1.0/jdbc/lib/ojdbc6.jar:/oracledb/TEST/db/tech_st/12.1.0/appsutil/java/xmlparserv2.jar:/oracledb/TEST/db/tech_st/12.1.0/appsutil/java:/oracledb/TEST/db/tech_st/12.1.0/jlib/netcfg.jar:/oracledb/TEST/db/tech_st/12.1.0/jlib/ldapjclnt12.jar
Using Context file: /oracledb/TEST/db/tech_st/12.1.0/appsutil/TEST_testdb.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.
2. Application Autoconfiq:
Enter the APPS user password:
The log file for this session is located at: /test/applmgr/fs1/inst/apps/TEST_testapps/admin/log/10051828/adconfig.log
AutoConfig is configuring the Applications environment…
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /test/applmgr/fs1/inst/apps/TEST_testapps
Classpath : /test/applmgr/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/test/applmgr/fs1/EBSapps/comn/java/classes
Using Context file: /test/applmgr/fs1/inst/apps/TEST_testapps/appl/admin/Test_testapps.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
…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………..AutoConfig completed successfully.
Site Name Changed:
DECLARE
a BOOLEAN;
BEGIN
a :=
FND_PROFILE.SAVE (‘SITENAME’,
‘Test instance Refreshed on:28-JUL-2021 Backup Date:15-JUL 2021’,
‘SITE’);
END;
Color Changed:
DECLARE
a BOOLEAN;
BEGIN
a := FND_PROFILE.SAVE (‘FND_COLOR_SCHEME’, ‘red’, ‘SITE’);
END;