Cloning an Existing Oracle11g Release 2 RDBMS Installation   3 comments

In this post i will list out the steps to clone existing Oracle 11Gr2 Oracle Home.

OS.:-OEL 6.4

Oracle Version:11.2.0.3

Step1: I have a database running on host oh11gr2 with DB OH location as /d01/oracle/product/11.2.0 now what I am planning is to clone the Oracle Home Binaries to new server say oh11grr2-clone

1

Compress the Oracle Home using tar.

2

The intention of using root to compress the OH is to make sure that the ownership of the files is preserved correctly. Some files in $ORACLE_HOME/bin are owned by root and have the SUID / SGID set:

-rws–x—   1 root     oinstall   20872 Apr 24 12:00 nmb

-rws–x—   1 root     oinstall   28720 Apr 24 11:59 nmo

-rwsr-x—   1 root     oinstall 1340408 Sep 25  2011 oradism

so if you try to copy them as a non-root possibility of following errors occur:

cp: cannot open `$ORACLE_HOME/bin/nmb’ for reading: Permission denied

cp: cannot open `$ORACLE_HOME/bin/nmo’ for reading: Permission denied

cp: cannot open `$ORACLE_HOME/bin/oradism’ for reading: Permission denied

scp the compressed Oracle Home to target i.e oh11grr2-clone

3

Once tar is finished login to target server and create location to hold our Oracle Binaries

In my case i have created mkdir /u01/oracle/product.

Once this is done. I started scp of 11.2.0.tar.gz from source to target.

4

*NOTE: Make sure you fulfill all the pre-req’s on the Target Server. (Installing RPM’s etc.)

Once scp is finished login into the target node change the and untar the compressed 11.2.0.tar.gz file as follows

Once this is done change the ownership to owner as oracle and group as dba

chown -R oracle:dba 11.2.0

5

6

Make sure you create inventory location in /etc/

vi /etc/oraInst.loc

add inventory_loc=/u01/app/oracle/oraInventory

this has to be created by root and change the permissions as 755

chmod 755 /etc/oraInst.loc

Once this is done go to below location

cd /u01/oracle/product/11.2.0/clone/bin and excute as below

perl clone.pl ORACLE_HOME=”/u01/oracle/product/11.2.0″ ORACLE_HOME_NAME=”Oracle_target” ORACLE_BASE=”/u01/oracle/product/” OSDBA_GROUP=dba OSOPER_GROUP=dba

7

8 9

Run the roor.sh script as below

last

Advertisements

Posted December 16, 2013 by balaoracledba.com in Oracle DBA, Oracle10g/11g

3 responses to “Cloning an Existing Oracle11g Release 2 RDBMS Installation

Subscribe to comments with RSS.

  1. Hi,

    Where you copied the CRD files from source to target?

  2. Sorry, i got it

    you cloned the ORACLE HOME only, not the database.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: