ORACLE EBS R12.2 cloning
Cold Backup Details here……
Application Cold Backup of ORACLE EBS 12.2 step by step
DB Cold Backup of ORACLE EBS 12.2 step by step
1.Source Database: DEV instance
/dev/backup/01AUG21/ORACLE_HOME_01AUG21.tar.gz
/dev/backup/01AUG21/DB_BACKUP_01AUG21.tar.gz
2.Backup move to Target database:
Backup move to Target database(TEST instance)
I.ORACLE_HOME Move to Test server
scp -P ORACLE_HOME.tar.gz 172.165.12.17:/testebsdb/TEST/db/tect_st/
II. Data Backup move to Target Instance (TEST)
scp -P DB_BACKUP_01AUG21.tar.gz 172.165.12.17:/testebsdb/TEST/db/apps_st/
3.Target Database: TEST Instance
1. untar the ORACLE_HOME Backup
cd /testebsdb/TEST/db/tect_st/
[oracle@ebs-db tech_st] tar -xvzf ORACLE_HOME.tar.gz
2. untar the DB backup
cd /testebsdb/TEST/db/apps_st/
[oracle@ebs-db apps_st] tar -xvzf DB_BACKUP_01AUG21.tar.gz
4.Export the PERL5LIB and PATH:
cd /testebsdb/TEST/db/tech_st/12.1.0/
export PERL5LIB=/testebsdb/TEST/db/tech_st/12.1.0/perl/lib/5.14.1:/testebsdb/TEST/db/tech_st/12.1.0/perl/lib/site_perl/5.14.1
export PATH=/testebsdb/TEST/db/tech_st/12.1.0/perl/bin:/testebsdb/TEST/db/tech_st/12.1.0/perl/bin:$PATH
============================================================
racle@ebs-db appsutil]$ ls
admin clone DEV_devebsdb.xml etcc install jre media outbound scripts temp txkSetCfgCDB.cmd
bin conf_DEV.txt driver html java log out perl sql template txkSetCfgCDB.env
[oracle@ebs-db appsutil]$ cd clone/
[oracle@ebs-db clone]$ ls
bin context data dbts html jlib jre oui
[oracle@ebs-db clone]$ cd bin/
[oracle@ebs-db bin]$ pwd
/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin
[oracle@ebs-db bin]$ ls
adcfgclone.pl adchkutl.sh adclonectx.pl adclone.pl
[oracle@ebs-db bin]$ export PERL5LIB=/testebsdb/TEST/db/tech_st/12.1.0/perl/lib/5.14.1:/testebsdb/TEST/db/tech_st/12.1.0/perl/lib/site_perl/5.14.1
[oracle@ebs-db bin]$ export PATH=/testebsdb/TEST/db/tech_st/12.1.0/perl/bin:/testebsdb/TEST/db/tech_st/12.1.0/perl/bin:$PATH
[oracle@ebs-db bin]$ ls
adcfgclone.pl adchkutl.sh adclonectx.pl adclone.pl
5.Database Cloning :
[oracle@ebs-db bin]$ perl adcfgclone.pl dbTier
Copyright (c) 2002, 2015 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adcfgclone Version 120.63.12020000.65
Enter the APPS password :
Running: Context clone…
Log file located at /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/CloneContext_0409114402.log
Provide the values required for creation of the new Database Context file.
Target System Hostname (virtual or normal) [ebs-db] :
Target System Base Directory : /testebsdb/TEST
Target Instance is RAC (y/n) [n] : n
Target System Database SID : TEST
Role separation is supported y/n [n] ? : n
Target System utl_file_dir Directory List : /testebsdb/tmp
Number of DATA_TOP’s on the Target System [1] :
Target System DATA_TOP Directory 1 [/testebsdb/TEST/data] : /testebsdb/TEST/db/apps_st/data
Target System RDBMS ORACLE_HOME Directory [/testebsdb/TEST/12.1.0] : /testebsdb/TEST/db/tech_st/12.1.0
Do you want to preserve the Display [null] (y/n) : n
Target System Display [ebs-db:0.0] : ebs-db: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] : 10
Checking the port pool 10
done: Port Pool 10 is free
Report file located at /testebsdb/TEST/db/tech_st/12.1.0/appsutil/temp/portpool.lst
The new database context file has been created :
/testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml
Check Clone Context logfile /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/CloneContext_0409114402.log for details.
Running Rapid Clone with command:
Running:
perl /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/adclone.pl java=/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/../jre mode=apply stage=/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml showProgress contextValidated=true
Beginning database tier Apply – Sun Aug 1 11:47:51 2021
/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/testebsdb/TEST/db/tech_st/12.1.0/oui -classpath /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/xmlparserv2.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/ojdbc6.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/java:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/OraInstaller.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/ewt3.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/share.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/srvm.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDBTier -e /testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml -stage /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone -showProgress
APPS Password : Log file located at /testebsdb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_ebs-db/ApplyDBTier_04091147.log
– 15% completed
Completed Apply…
Sun Aug 1 11:51:38 2021
Starting database listener for TEST:
Running:
/testebsdb/TEST/db/tech_st/12.1.0/appsutil/scripts/TEST_ebs-db/addlnctl.sh start TEST
Logfile: /testebsdb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_ebs-db/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 /testebsdb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_ebs-db/addlnctl.txt for more information …
Do you want to change the password for all EBS Schemas? (y/n) [n]) : n
Do you want to change the password for sysadmin user? (y/n) [n]) : n
Do you want to change the apps password? (y/n) [n]) : n
Do you want to change the sys and system passwords? (y/n) [n]) : n
Running ETCC to check status of DB technology patches…
+===============================================================+
| Copyright (c) 2005, 2020 Oracle and/or its affiliates. |
| All rights reserved. |
| Oracle E-Business Suite Release 12.2 |
| Database EBS Technology Codelevel Checker |
+===============================================================+
Validating context file: /testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml
Using context file from command line argument:
/testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml
Starting Database EBS Technology Codelevel Checker, Version 120.83
Sun Aug 1 11:52:47 IST 2021
Log file for this session : /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/log/checkDBpatch_26599.log
Identifying database release.
Database release set to 12.1.0.2.
Connecting to database.
Database connection successful.
Database TEST is in READ WRITE mode.
Identifying APPS and APPLSYS schema names.
– APPS schema : APPS
– APPLSYS schema : APPLSYS
Checking for DB-ETCC results table.
Table to store DB-ETCC results already exists in the database.
Checking if InMemory option is enabled.
InMemory option is not enabled in the database.
Bugfix file /testebsdb/TEST/db/tech_st/12.1.0/appsutil/etcc/db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.58
This file will be used for identifying missing bugfixes.
Mapping file /testebsdb/TEST/db/tech_st/12.1.0/appsutil/etcc/db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.33
This file will be used for mapping bugfixes to patches.
Identified RDBMS DST version 18.
Checking Bugfix XML file for 12.1.0.2_PSU
Obtained list of bugfixes to be applied and the list to be rolled back.
Now checking Database ORACLE_HOME.
The opatch utility is version 12.2.0.1.24.
DB-ETCC is compatible with this opatch version.
Found patch records in the inventory.
Checking Mapping XML file for 12.1.0.2.210119
All the required one-off bugfixes are present in Database ORACLE_HOME.
Stored Technology Codelevel Checker results in the database TEST successfully.
Finished checking fixes for Oracle Database: Sun Aug 1 11:52:55 IST 2021
Log file for this session: /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/log/checkDBpatch_26599.log
===============================================================================
Source the Database Environment file
[oracle@ebs-db 12.1.0]$ . TEST_ebs-db.env
[oracle@ebs-db 12.1.0]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Sun Aug 1 11:53:21 2021
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
——— ——————–
TEST READ WRITE
SQL> show SGA;
Total System Global Area 2147483648 bytes
Fixed Size 2926472 bytes
Variable Size 469764216 bytes
Database Buffers 1660944384 bytes
Redo Buffers 13848576 bytes
SQL>
SQL> Exit
oracle@ebs-db 12.1.0]$ . TEST_ebs-db.env
[oracle@ebs-db 12.1.0]$ cd appsutil
[oracle@ebs-db appsutil]$ ls
admin clone etcc install jre media outbound scripts sql template txkSetCfgCDB.env
bin driver html java log out perl TEST_ebs-db.xml temp txkSetCfgCDB.cmd
[oracle@ebs-db appsutil]$ cd install/
[oracle@ebs-db install]$ ls
adlnkoh.sh TEST_ebs-db
[oracle@ebs-db install]$ cd TEST_ebs-db/
[oracle@ebs-db TEST_ebs-db]$ ls
adcctclean.sql adcrdbrdlg.sh addbperms.sh adsvdb.sh afdbprf.sql txkEBSWrapper.pl
adclobconv.sql adcrdb.sh addbprf.sh adsvdcnv.sh afmkinit.sh
adclobtmp.sql adcrobj.sh addbprf.sql adsvdlsn.sh txkConfigDbOcm.pl
adcmclean.sql adcrobj.sql addbupdgsm.sql adupdlib.sql txkcreateACL.sh
adcrdbclone.sql addbccnv.sql adlicnse.sql afdbprf.sh txkcreateACL.sql
6.[oracle@ebs-db TEST_ebs-db]$ sqlplus “/ as sysdba” @adupdlib.sql so
SQL*Plus: Release 12.1.0.2.0 Production on Sun Aug 1 13:10:33 2021
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics, and Real Application Testing options
PL/SQL procedure successfully completed.
SQL> exit
- 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.
7.Context file Location :
/testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml
perl adcfgclone.pl dbconfig /testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml
redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adcfgclone Version 120.63.12020000.65
Enter the APPS password : <Dev Application Apps Password >
Running Rapid Clone with command:
Running:
perl /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/adclone.pl java=/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/../jre mode=apply stage=/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone component=dbconfig method=CUSTOM dbctxtg=/testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml showProgress contextValidated=false
Beginning dbconfig Apply – Sun Aug 1 13:16:51 2021
/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/testebsdb/TEST/db/tech_st/12.1.0/oui -classpath /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/xmlparserv2.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/ojdbc6.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/java:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/OraInstaller.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/ewt3.jar:/testebsdb/TEST/
adcfgclone Version 120.63.12020000.65
/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/testebsdb/TEST/db/tech_st/12.1.0/oui -classpath /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/xmlparserv2.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/ojdbc6.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/java:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/OraInstaller.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/ewt3.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/share.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/srvm.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDatabase -e /testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml -stage /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone -showProgress -noRmanRecovery yes -checkDBConnection
APPS Password : Log file located at /testebsdb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_ebs-db/ApplyDatabase_04091316.log
| 0% completed
Log file located at /testebsdb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_ebs-db/ApplyDatabase_04091316.log
/ 30% completed
Completed Apply…
Sun Aug 1 13:17:51 2021
Starting database listener for TEST:
Running:
/testebsdb/TEST/db/tech_st/12.1.0/appsutil/scripts/TEST_ebs-db/addlnctl.sh start TEST
Logfile: /testebsdb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_ebs-db/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 /testebsdb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_ebs-db/addlnctl.txt for more information …
Running ETCC to check status of DB technology patches…
+===============================================================+
| Copyright (c) 2005, 2020 Oracle and/or its affiliates. |
| All rights reserved. |
| Oracle E-Business Suite Release 12.2 |
| Database EBS Technology Codelevel Checker |
+===============================================================+
Validating context file: /testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml
Using context file from command line argument:
/testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml
Starting Database EBS Technology Codelevel Checker, Version 120.83
Fri Apr 9 13:17:51 IST 2021
Log file for this session : /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/log/checkDBpatch_4652.log
Identifying database release.
Database release set to 12.1.0.2.
Connecting to database.
Database connection successful.
Database TEST is in READ WRITE mode.
Identifying APPS and APPLSYS schema names.
– APPS schema : APPS
– APPLSYS schema : APPLSYS
Checking for DB-ETCC results table.
Table to store DB-ETCC results already exists in the database.
Checking if InMemory option is enabled.
InMemory option is not enabled in the database.
Bugfix file /testebsdb/TEST/db/tech_st/12.1.0/appsutil/etcc/db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.58
This file will be used for identifying missing bugfixes.
Mapping file /testebsdb/TEST/db/tech_st/12.1.0/appsutil/etcc/db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.33
This file will be used for mapping bugfixes to patches.
Identified RDBMS DST version 18.
Checking Bugfix XML file for 12.1.0.2_PSU
Obtained list of bugfixes to be applied and the list to be rolled back.
Now checking Database ORACLE_HOME.
The opatch utility is version 12.2.0.1.24.
DB-ETCC is compatible with this opatch version.
Found patch records in the inventory.
Checking Mapping XML file for 12.1.0.2.210119
All the required one-off bugfixes are present in Database ORACLE_HOME.
Stored Technology Codelevel Checker results in the database TEST successfully.
Finished checking fixes for Oracle Database: Sun Aug 1 13:18:00 IST 2021
Log file for this session: /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/log/checkDBpatch_4652.log
===============================================================================
[oracle@ebs-db bin]$
9.Application Cloning:
10.Source application: DEV Application
Backup of Location is /u01/applmgr/Backup/EBSAPPS_fs1_bkp01AUG21.tar.gz
Application Backup move to Target Server (TEST instance )
scp -P EBSAPPS_fs1_bkp01AUG21.tar.gz /testebsapp/TEST/fs1
untar the Application Backup file
tar -xvzf EBSAPPS_fs1_bkp01AUG21.tar.gz
cd /testebsapp/TEST/fs1/EBSapps/comn/clone/bin
applmgr@ebs-app 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.65
Enter the APPS password : <Dev 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 /testebsapp/TEST/fs1/EBSapps/comn/clone/bin/CloneContext_0409120727.log
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [ebs-app] :
Target System Database SID : TEST
Target System Database Server Node [ebs-app] : ebs-db
Target System Database Domain Name [xyz.com] :
Target System Base Directory : /testebsapp/TEST/
Target System Base Directory set to /testebsapp/TEST/
Target System Current File System Base set to /testebsapp/TEST/fs1
Target System Other File System Base set to /testebsapp/TEST//fs1
Target System Fusion Middleware Home set to /testebsapp/TEST/fs1/FMW_Home
Target System Other File System Fusion Middleware Home set to /testebsapp/TEST//fs1/FMW_Home
Target System Current File System Instance Top set to /testebsapp/TEST/fs1/inst/apps/TEST_ebs-app
Do you want to preserve the Display [devebsapp:0.0] (y/n) : n
Target System Display [ebs-app:0.0] : ebs-app: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] : 10
Checking the port pool 10
done: Port Pool 10 is free
Report file located at /testebsapp/TEST/fs1/inst/apps/TEST_ebs-app/admin/out/portpool.lst
Target System proxy port [80] :
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /testebsdb/tmp
3. /testebsdb/TEST/db/tech_st/12.1.0/appsutil/outbound/TEST_ebs-db
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] : 2
The new APPL_TOP context file has been created :
/testebsapp/TEST/fs1/inst/apps/TEST_ebs-app/appl/admin/TEST_ebs-app.xml
Check Clone Context logfile /testebsapp/TEST/fs1/EBSapps/comn/clone/bin/CloneContext_0409120727.log for details.
Creating Patch file system context file…..
Log file located at /testebsapp/TEST/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0409122105.log
Target System Other File System Instance Top set to /testebsapp/TEST//fs1/inst/apps/TEST_ebs-app
Target System Port Pool [0-99] : 11
Checking the port pool 11
done: Port Pool 11 is free
Report file located at /testebsapp/TEST/fs1/inst/apps/TEST_ebs-app/admin/out/portpool.lst
The new APPL_TOP context file has been created :
/testebsapp/TEST//fs1/inst/apps/TEST_ebs-app/appl/admin/TEST_ebs-app.xml
Check Clone Context logfile /testebsapp/TEST/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0409122105.log for details.
FMW Pre-requisite check log file location : /testebsapp/TEST/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: FMW pre-req check…
Configuring: Run file system….
LogFile located at /testebsapp/TEST/fs1/inst/apps/TEST_ebs-app/admin/log/clone/run/RCloneApplyAppstier_08051221.log
Configuring: Patch file system….
LogFile located at /testebsapp/TEST/fs2/inst/apps/TEST_ebs-app/admin/log/clone/run/RCloneApplyAppstier_08051221.log
Other Topics: