1.Execute the adpreclone.pl both application and database.
2.Move the RMAN Backup, database ORACLE HOME, and application backup to the target server.
Source Database: PROD
Target Database: TEST
Backup Details (PROD): /prod/rman_backup/15Jul2021_bkp
Database backup move to target Server (testdb) :
*****************************************************
Copy Command from Source (PROD) server to Target server(TEST)
scp -P 15Jul2021_bkp oracle@172.165.12.15:/test/rman_backup/
scp -P Oracle_Home_bkp15Jul2021.tar.gz oracle@172.165.12.15:/oracledb/TEST/db/tech_st/
The Backup location is /test/rman_backup/15Jul2021_bkp
Application Backup move to target Server:
**********************************************
Copy Command from Source(PROD) server to Target server(TEST)
scp -P EBSapps.tar.gz applmgr@172.165.12.16:/test/applmgr/
The backup Location is /test/applmgr/EBSapps.tar.gz
Untar the backup
tar -xvzf EBSapps.tar.gz
I ) Database Cloning :
Untar the Oracle_home backup file
cd /oracledb/TEST/db/tech_st/
Oracle_Home_bkp15Jul2021.tar.gz
tar -xvzf Oracle_Home_bkp15Jul2021.tar.gz
[oracle testdb tech_st] 12.1.0
[oracle testdb tech_st] cd 12.1.0
Export PERL5LIB and PATH
export PERL5LIB=/oracledb/TEST/db/tech_st/12.1.0/perl/lib/5.14.1:/oracledb/TEST/db/tech_st/12.1.0/perl/lib/site_perl/5.14.1
export PATH=/oracledb/TEST/db/tech_st/12.1.0/perl/bin:/oracledb/TEST/db/tech_st/12.1.0/bin:$PATH
cd /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin
[oracle@testdb bin]$ perl adcfgclone.pl dbTechStack
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 : <Source<PROD> Apps Password>
Running: Context clone…
Log file located at /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/CloneContext_1004214819.log
Provide the values required for creation of the new Database Context file.
Target System Hostname (virtual or normal) [testdb] :
Target Instance is RAC (y/n) [n] : n
Target System Database SID : TEST
Target System Base Directory : /oracledb/TEST
Target System utl_file_dir Directory List : /usr/tmp
Number of DATA_TOP’s on the Target System [2] : 1
Target System DATA_TOP Directory 1 : /oracledb/TEST/apps_st/data
Target System RDBMS ORACLE_HOME Directory [/oracledb/TEST/12.1.0] : /oracledb/TEST/db/tech_st/12.1.0
Do you want to preserve the Display [oracledb:0.0] (y/n) : n
Target System Display [testdb:0.0] : testdb:1.0
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 /oracledb/TEST/db/tech_st/12.1.0/appsutil/temp/portpool.lst
The new database context file has been created :
/oracledb/TEST/db/tech_st/12.1.0/appsutil/TESR_testdb.xml
Check Clone Context logfile /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/CloneContext_1004214819.log for details.
………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………..
cd /oracledb/TEST/db/tech_st/12.1.0/dbs=>TEST_testdb_ifile.ora
set value in TEST_testdb_ifile.ora
[oracle@testdb dbs]$ cat TEST_testdb_ifile.ora
db_file_name_convert=(‘/erpprod/prod/oracle/PROD/data/datafile’,’/oracledb/TEST/db/apps_st/data’
log_file_name_convert=(‘/erpprod/prod/oracle/PROD/data’,’/oracledb/TEST/db/apps_st/data’)
Restore RMAN BACKUP :
[oracle@devebsdb 12.1.0]$ . TEST_TESTDB.env
sqlplus ‘/as sysdba’
SQL> startup nomount pfile=’initTEST.ora’;
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
——— ——————–
TEST NOMOUNT
Create RMAN Script(duplicate.sql):
run
{
allocate auxiliary channel t1 type disk;
allocate auxiliary channel t2 type disk;
duplicate database to “TEST” BACKUP LOCATION ‘/test/rman_backup/27Jul2021bkp’;
release channel t1;
release channel t2;
}
[oracle@testdb 12.1.0]$ . TEST_testdb.env
rman auxiliary / cmdfile=duplicate.sql log=rmanlog.log
Note : Rman restored took some times
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
——— ——————–
TEST READ WRITE
Now check the Archive log mode:
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Enabled
Archive destination oracledb/TEST/db/apps_st/data
Oldest online log sequence 173
Current log sequence 174
TEST instance no need Archive log mode, So now we need to disable the Archive log mode
SQL> shut immediate;
SQL>startup mount;
SQL>alter database noarchivelog
SQL>alter database open;
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Enabled
Archive destination oracledb/TEST/db/apps_st/data
Oldest online log sequence 176
Current log sequence 177
- Database in open mode
- Run the library update script against the database
- cd [RDBMS ORACLE_HOME]/appsutil/install/[CONTEXT NAME] $ sqlplus “/ as sysdba” @adupdlib.sql so
- Where [libext] should be set to ‘sl’ for HP-UX, ‘so’ for any other UNIX platform, or ‘dll’ for Windows.
- Configure the target database The database must be running and open before performing this step.
- cd [RDBMS ORACLE_HOME]/appsutil/clone/bin $ perl adcfgclone.pl dbconfig [Database target context file] Where Database target context file is: [RDBMS ORACLE_HOME]/appsutil/[Target CONTEXT_NAME].xml.
[oracle@testdb bin]$ perl adcfgclone.pl dbconfig oracledb/TEST/db/tech_st/12.1.0/appsutil/TEST_testdb.xml
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 :
Running Rapid Clone with command:
Running:
perl /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/adclone.pl java=/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/../jre mode=apply stage=/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone component=dbconfig method=CUSTOM dbctxtg=/oracledb/TEST/db/tech_st/12.1.0/appsutil/TEST_testdb.xml showProgress contextValidated=false
Beginning dbconfig Apply – Tue 27 10:58:57 2021
/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oracledb/TEST/db/tech_st/12.1.0/oui -classpath /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/xmlparserv2.jar://oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/ojdbc6.jar:/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/java:/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/OraInstaller.jar:/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/ewt3.jar://oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/share.jar:/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/srvm.jar:/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDatabase -e /oracledb/TEST/db/tech_st/12.1.0/appsutil/TEST_testdb.xml -stage /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone -showProgress -noRmanRecovery yes -checkDBConnection
APPS Password : Log file located at /oracledb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_testdbt/ApplyDatabase_10051058.log
| 0% completed
Log file located at /oracledb/TEST/db/tech_st/12.1.0/appsutil/logTEST_testdb/ApplyDatabase_10051058.log
– 30% completed
Completed Apply…
Tue Jul 5 11:00:09 2021
Starting database listener for TEST:
Running:
/oracledb/TEST/db/tech_st/12.1.0/appsutil/scripts/TEST_testdb/addlnctl.sh start TEST
Logfile: /oracledb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_testdb/addlnctl.txt
You are running addlnctl.sh version 120.4
Starting listener process TEST …
Listener TEST has already been started.
addlnctl.sh: exiting with status 0
addlnctl.sh: check the logfile /oracledb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_testdb/addlnctl.txt for more information …
Running ETCC to check status of DB technology patches…
+===============================================================+
| Copyright (c) 2005, 2016 Oracle and/or its affiliates. |
| All rights reserved. |
| Oracle E-Business Suite Release 12.2 |
| Database EBS Technology Codelevel Checker |
+===============================================================+
Executing the following Script:
sqlplus apps/Passw0rd
EXEC FND_CONC_CLONE.SETUP_CLEAN;
Run Autoconfiq in 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.
II ) APPS Cloning:
/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;