Wednesday, February 09, 2011

Cloning Oracle Database Software

Cloning an 11gR2 Oracle Home from source machine PROD to target machine TEST.

On source (PROD):
ORACLE_HOME location is : /u01/app/oracle/product/11.2.0/dbhome_1

Go to directory on source machine one level higher and tar the db_home1 directory and all sub-directories
PROD:$ pwd
PROD:$ /u01/app/oracle/product/11.2.0  
PROD:$ tar -cvf 11gr2.tar dbhome_1

On Target (TEST)
Create the directory /u01/app/oracle/product/11.2.0 if it does not exist

Mkdir –p /u01/app/oracle/product/11.2.0

On Source
scp or ftp the tar file to this location on the target machine
PROD:$ scp -rp 11gr2.tar oracle@TEST:/u01/app/oracle/product/11.2.0  


On target
Uncompress the tar file
TEST:$ cd /u01/app/oracle/product/11.2.0
TEST:$ tar -xvf 11gr2.tar

Clone the Oracle Home using the perl script clone.pl which is located under the $ORACLE_HOME/clone/bin


TEST:$ cd /u01/app/oracle/product/11.2.0/dbhome_1/clone/bin
TEST:$ perl clone.pl ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 ORACLE_HOME_NAME=11GR2_HOME
./runInstaller -clone -waitForCompletion  "ORACLE_BASE=/u01/app/oracle" "ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1" "ORACLE_HOME_NAME=11GR2_HOME" -silent -noConfig -nowait
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB.   Actual 13044 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2010-06-28_12-19-47PM. Please wait ...Oracle Universal Installer, Version 11.2.0.1.0 Production
Copyright (C) 1999, 2009, Oracle. All rights reserved.
You can find the log of this install session at:
 /u01/app/oracle/oraInventory/logs/cloneActions2010-06-28_12-19-47PM.log
.................................................................................................... 100% Done.
Installation in progress (Monday, June 28, 2010 12:20:29 PM WST)
..............................................................................                                                  78% Done.
Install successful
Linking in progress (Monday, June 28, 2010 12:21:06 PM WST)
Link successful
Setup in progress (Monday, June 28, 2010 12:23:34 PM WST)
Setup successful
End of install phases.(Monday, June 28, 2010 12:34:05 PM WST)
Starting to execute configuration assistants
The following configuration assistants have not been run. This can happen because Oracle Universal Installer was invoked with the -noConfig option.
---------------------------------------------------
The "/u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/configToolFailedCommands" script contains all commands that failed, were skipped or were cancelled. This file may be used to run these configuration assistants outside of OUI. Note that you may have to update this script with passwords (if any) before executing the same.
The "/u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/configToolAllCommands" script contains all commands to be executed by the configuration assistants. This file may be used to run the configuration assistants outside of OUI. Note that you may have to update this script with passwords (if any) before executing the same.
--------------------------------------
WARNING:
The following configuration scripts need to be executed as the "root" user.
/u01/app/oracle/product/11.2.0/dbhome_1/root.sh
To execute the configuration scripts:
    1. Open a terminal window
    2. Log in as "root"
    3. Run the scripts
The cloning of 11GR2_HOME was successful.
Please check '/u01/app/oracle/oraInventory/logs/cloneActions2010-06-28_12-19-47PM.log' for more details.

Run the root.sh script as root
# pwd
/u01/app/oracle/product/11.2.0/dbhome_1
# ./root.sh
Check /u01/app/oracle/product/11.2.0/dbhome_1/install/root_PROD_2010-06-29_07-42-31.log for the output of root script
TEST:$cat /u01/app/oracle/product/11.2.0/dbhome_1/install/root_TEST_2010-06-29_07-42-31.log

Running Oracle 11g root.sh script...
The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/11.2.0/dbhome_1
Entries will be added to the /var/opt/oracle/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.

We can now check that the OraInventory has been updated with the 11g Release 2 Oracle Home details.

No comments: