Cloning is the process of creating an identical copy of an existing Oracle Application System. The new and existing systems must have component versions and platform type identical for cloning. I am going to discuss the steps involved to Clone a Single Node system in R12 EBS. Source Instance Name : r12a.quickoracle.com Target Instance Name : r12b.quickoracle.com Preparation to clone the Oracle Application System (Source). 1) sudo su - appl < sid
> user.
2) execute the Consolidated Applications enviornment file.
$cd $APPL_TOP
$.APPS
< context_name
> .env
3) zip utility should be in your PATH.
$ PATH=$PATH:
< Location of zip utlity installed on your system
> $ export PATH
4) Stop all Apps Tier Server processes.
$ cd $INST_TOP/admin/scripts
$ adstpall.sh APPS/
< passwd of APPS user
> 5) Verify latest Rapid Clone patches on metalink and apply if required.(Not applicable)
6) On Apps Tier run AutoConfig and after that on Database Tier.
Apps Tier:
$ cd $INST_TOP/admin/scripts
$ adautocfg.sh
DB Tier:
RDBMS HOME = $ORACLE_HOME
$ cd $ORACLE_HOME/appsutil/scripts/
< context_name
> $ adautocfg.sh
Pre-Clone Steps Starts from Here 1. DB Tier preparation for Cloning :
On Source System:
a) login in as Oracle user : $ sudo su - oracle
b) Run the following commands:
RDBMS HOME = $ORACLE_HOME
$ cd $ORACLE_HOME/appsutil/scripts/
< context_name
> $ perl adpreclone.pl dbTier
2. Verify the errors and warnings in the log.
RDBMS_HOME = $ORACLE_HOME
Location of the log file StageDBTier_
.log $cd $ORACLE_HOME/appsutil/log/< context_name> directory 3. Apps Tier preparation for Cloning a) $ sudo su - appl< sid> b) Run Pre-Clone on all the nodes that contains an APPL_TOP. $cd $INST_TOP/admin/scripts $perl adpreclone.pl appsTier 4. Verify the errors and warnings in the log. Location of the log file StageAppsTier_< time> .log $cd $APPL_TOP/admin//log directoryPre-Clone Steps End Here and Clone Steps Start From Here 1. Copy or Tar ball or sftp source system application tier file system to the target system. Note: You need not to shutdown your source system application node for this step. File System which need to be Tar ball or sftp to target system from Source System includes: APPL_TOP COMMON_TOP ORACLEAS_10.1.2_ORACLE_HOME ORACLEAS_10.1.3_ORACLE_HOME 2. copy or TAR ball or sftp source system database tier file system to the target system. a) This step require you bring down your source sytem (i.e database node) as user oracle. b) Shutdown normal the source system database c) copy the database (.dbf) files from the source to the target system d) copy or TAR ball or sftp the source database ORACLE_HOME to the target system. 3. DBTier Configuration and then start the Target System database Server. a) sudo su - oracle on target system b) Run adcfgclone.pl on DB Tier. You will be prompted wfor the values specific to the target system like SID,port etc. RDBMS_HOME = $ORACLE_HOME $ cd $ORACLE_HOME/appsutil/clone/bin $ perl adcfgclone.pl dbTier 4. Verify errors and warnings in the log Location of the log file ApplyDBTier_< time> .log $ cd $ORACLE_HOME/appsutil/log/< context_name> 5. Apps Tier configuration on Target system application Server nodes. a) $sudo su - appl< sid> b) Run adcfgclone.pl on Apps Tier. You will be prompted wfor the values specific to the target system like SID,port etc. $cd $COMMON_TOP/clone/bin $perl adcfgclone.pl appsTier 6. Verify the errors and warnings in the log. Location of log ApplyAppsTier_< time> .log $cd $APPL_TOP/admin/< context_name> /log 7.Once clone is finished. If you have customized environment then change post clone profile options, utl_file_dir etc.Clone Steps End Here Test your cloned environment and enter the below URL in your browser http://r12b.quickoracle.com:8000 or http://< hostname> .< domain_name> :< HTTP port>