Clone Oracle Home - 11.2.0.3 RDBMS

CLONE ORACLE BINARY

Oracle 11.2.0.3 RDBMS

Advantage

Cloning an Oracle Home involves creating a copy of the already existing ORACLE HOME BINARY on the source server and then configuring it for a target server. It doesn’t matter your existing binary is Standalone or Cluster. Oracle installation performing the runInstaller in silent mode completes in minute than your fresh GUI/CLI binary installation.

Solution

In my case I am using 11.2.0.3 RAC Node 2 for RDBMS HOME for Standalone Installation.

Source Server:

SERVER         RAC124

ORACLE_BASE    /u01/app/oracle
ORACLE_HOME    /u01/app/oracle/product/11.2.0/dbhome_1
Backup Location      /SOFT

Target Server:

SERVER         VM110

ORACLE_BASE    /u01/app/oracle
ORACLE_HOME    /u01/app/oracle/product/11.2.0/dbhome_1
Backup Location      /SOFT

ON Source Server

Create tar of existing ORACLE_HOME.

cd /u01/app/oracle/product/11.2.0/

tar -cvf /SOFT/11203_RDBMS_BINARY_BKP.tar ./

It will take few minutes to complete and size would be approx 4.5 GB to 7.5 GB (It may vary depending upon logs and audit directory).

Once a tar file is created copy the tar home to target server (vm110)

scp -p /SOFT/11203_RDBMS_BINARY_BKP.tar oracle@vm110:/SOFT

ON Target Server

go to the /SOFT directory

-rwxr-xr-x  1 oracle oinstall 4.7G Jul  5 16:53 11203_RDBMS_BINARY_BKP.tar

Create a directory for ORACLE_HOME and Untar the backup tar home

mkdir -p /u01/app/oracle/product/11.2.0

cd /u01/app/oracle/product/11.2.0

tar -xvf /SOFT/11203_RDBMS_BINARY_BKP.tar oracle@vm110

Now run the runInstaller command in silent mode

/u01/app/oracle/product/11.2.0/dbhome_1/oui/bin/runInstaller -silent - clone ORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1" ORACLE_HOME_NAME=”ORAHOME_11203" ORACLE_BASE="/u01/app/oracle"

Once done it will prompt to run root.sh as root user.

sudo /u01/app/oracle/product/11.2.0/dbhome_1/root.sh

Over all task on TARGET SERVER took 10 min in our environment depending upon available resources.

Post Task

·         Since I used RAC RDBMS Home for cloning, Now convert it in Non Cluster Binary

cd /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/

make -f ins_rdbms.mk rac_off

cd /u01/app/oracle/product/11.2.0/dbhome_1/bin

relink all

·         Change the listener.ora, Tnsnames.ora , sqlnet.ora , pfile/spfile as per your requirement.