Clone Oracle 11g Database Software

Source: localhost
Target: buzzdba
Here we are going to perform oracle software clone from localhost(source) to buzzdba(target)
Source:
Go to one level above the oracle home location and tar the oracle home and all sub-directories.
[oracle@localhost product]$ ls -ltr

total 4
drwxr-xr-x. 76 oracle oinstall 4096 Oct  7 23:35 11.2.0
[oracle@localhost product]$ tar -zcvf 11.2.0.tar.gz 11.2.0
11.2.0/
11.2.0/csmig/
11.2.0/csmig/mesg/
11.2.0/csmig/mesg/cssus.msb
11.2.0/csmig/mesg/cscus.msb
11.2.0/mgw/
11.2.0/mgw/admin/
11.2.0/mgw/admin/mgwe111.sql
11.2.0/mgw/admin/mgwireg.plb
11.2.0/mgw/admin/mgwd920.sql

.......

[oracle@localhost product]$ ls -ltr

total 2168944

drwxr-xr-x. 76 oracle oinstall       4096 Oct  7 23:35 11.2.0

-rw-r--r--.  1 oracle oinstall 2220987218 Oct  9 15:23 11.2.0.tar.gz

[oracle@localhost product]$

scp or ftp the tar file to target machine

[oracle@localhost product]$ scp 11.2.0.tar.gz oracle@buzzdba:/ora

oracle@buzzdba's password:

11.2.0.tar.gz                                                    100% 2118MB  33.6MB/s   01:03

[oracle@localhost product]$

Target:

Uncompress tar file

[oracle@buzzdba ora]$ ls -ltr

total 2168900

-rw-r--r--. 1 oracle oinstall 2220945767 Oct  9 10:26 11.2.0.tar.gz

[oracle@buzzdba ora]$ clear

[oracle@buzzdba ora]$ pwd

/ora

[oracle@buzzdba ora]$ ls -ltr

total 2168900

-rw-r--r--. 1 oracle oinstall 2220945767 Oct  9 10:26 11.2.0.tar.z

[oracle@buzzdba ora]$ tar -zxvf 11.2.0.tar.gz

11.2.0/

11.2.0/assistants/

11.2.0/assistants/bin/

11.2.0/assistants/bin/platform_common.sbs.ouibak

11.2.0/assistants/bin/platform_common.sbs

11.2.0/assistants/rconfig/

11.2.0/assistants/rconfig/sampleXMLs/

11.2.0/assistants/rconfig/sampleXMLs/ConvertToRAC_AdminManaged.xml

11.2.0/assistants/rconfig/sampleXMLs/ConvertToRAC_PolicyManaged.xml

11.2.0/assistants/rconfig/doc/

11.2.0/assistants/rconfig/doc/rconfig.html

.....

11.2.0/dv/admin/rule_set_it.dlf

11.2.0/dv/jlib/

11.2.0/dv/jlib/dva_webapp.ear

11.2.0/dv/jlib/dvca.jar

11.2.0/dv/jlib/dva_webapp_jsp.jar

[oracle@buzzdba ora]$ ls -ltr

total 2168904

drwxr-xr-x. 76 oracle oinstall       4096 Oct  8 21:00 11.2.0

-rw-r--r--.  1 oracle oinstall 2220945767 Oct  9 10:26 11.2.0.tar.gz

[oracle@buzzdba ora]$

[oracle@buzzdba ~]$ cat db.env

export ORACLE_BASE=/ora

export ORACLE_HOME=$ORACLE_BASE/11.2.0

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib

[oracle@buzzdba ~]$ . db.env

[oracle@buzzdba ~]$ cd $ORACLE_HOME/clone/bin

[oracle@buzzdba bin]$ pwd

/ora/11.2.0/clone/bin

[oracle@buzzdba bin]$ ls -lr

total 16

-rwxr-xr-x. 1 oracle oinstall   838 Jul 13  2009 prepare_clone.pl

-rwxr-xr-x. 1 oracle oinstall 11066 Jul 13  2009 clone.pl

[oracle@buzzdba bin]$ perl clone.pl ORACLE_BASE=/ora ORACLE_HOME=/ora/11.2.0 ORACLE_HOME_NAME=11GR2_HOME

./runInstaller -clone -waitForCompletion  "ORACLE_BASE=/ora" "ORACLE_HOME=/ora/11.2.0" "ORACLE_HOME_NAME=11GR2_HOME" -silent -noConfig -nowait

Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 7996 MB    Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-10-09_10-39-21AM. 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:

 /home/oracle/oraInventory/logs/cloneActions2011-10-09_10-39-21AM.log

.................................................................................................... 100% Done.

Installation in progress (Sunday, October 9, 2011 10:40:43 AM IST)

..............................................................................                                                  78% Done.

Install successful

Linking in progress (Sunday, October 9, 2011 10:41:11 AM IST)

Link successful

Setup in progress (Sunday, October 9, 2011 10:42:55 AM IST)

Setup successful

End of install phases.(Sunday, October 9, 2011 10:48:09 AM IST)

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 "/ora/11.2.0/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 "/ora/11.2.0/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.

/ora/11.2.0/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 '/home/oracle/oraInventory/logs/cloneActions2011-10-09_10-39-21AM.log' for more details.

[oracle@buzzdba bin]$

Run the root.sh script as root

[root@buzzdba ora]# cd /ora/11.2.0/

[root@buzzdba 11.2.0]# pwd

/ora/11.2.0

[root@buzzdba 11.2.0]# ./root.sh

Check /ora/11.2.0/install/root_buzzdba.localdomain_2011-10-09_10-52-42.log for the output of root script

[root@buzzdba 11.2.0]# cat /ora/11.2.0/install/root_buzzdba.localdomain_2011-10-09_10-52-42.log

Running Oracle 11g root.sh script...

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /ora/11.2.0

Entries will be added to the /etc/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.

[root@buzzdba 11.2.0]#

Clone Logfile:

[oracle@buzzdba bin]$ ls -ltr /home/oracle/oraInventory/logs/cloneActions2011-10-09_10-39-21AM.log

-rw-rw----. 1 oracle oinstall 8840228 Oct  9 10:48 /home/oracle/oraInventory/logs/cloneActions2011-10-09_10-39-21AM.log

[oracle@buzzdba bin]$

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

[oracle@buzzdba bin]$ cd $ORACLE_HOME

[oracle@buzzdba 11.2.0]$ ls -ltr *loc

-rw-r-----. 1 oracle oinstall 60 Oct  8 21:08 oraInst.loc

[oracle@buzzdba 11.2.0]$ cat oraInst.loc

inventory_loc=/home/oracle/oraInventory

inst_group=oinstall

[oracle@buzzdba 11.2.0]$ cd /home/oracle/oraInventory

[oracle@buzzdba oraInventory]$ ls -ltr

total 28

drwxrwx---. 2 oracle oinstall 4096 Oct  8 21:06 ContentsXML

-rwxrwx---. 1 oracle oinstall 1659 Oct  8 21:06 orainstRoot.sh

-rw-rw----. 1 oracle oinstall   60 Oct  8 21:06 oraInst.loc

-rw-rw----. 1 oracle oinstall  301 Oct  9 10:40 oraInstaller.properties

drwxrwx---. 2 oracle oinstall 4096 Oct  9 10:42 logs

drwxrwx---. 3 oracle oinstall 4096 Oct  9 10:47 backup

-rw-rw----. 1 oracle oinstall   37 Oct  9 10:48 install.platform

[oracle@buzzdba oraInventory]$ cd ContentsXML

[oracle@buzzdba ContentsXML]$ ls

comps.xml  inventory.xml  libs.xml

[oracle@buzzdba ContentsXML]$ cat inventory.xml 

~~~ Cheers