If we want to create/clone/move oracle home or move the oracle home then we can use the clone.pl utility provided by oracle. With the use of this utility we can create a Oracle Home with all the required patches already applied.
Utility Details
Perl Script: $ORACLE_HOME/clone/bin/clone.pl.
It accepts ORACLE HOME and ORACLE HOME NAME as parameters.
Steps
Current Oracle Home: /u01/app/oracle/db
New Oracle Home: /u02/app/oracle/db
1) Tar the current ORACLE_HOME as ‘oracle’ user or the dbuser(what ever defined)
$> cd /u01/app/oracle/db
$> tar -cvf orahome.tar *
2) Copy the tar to new ORACLE_HOME location/ new server Oracle Home location
$> cd /u02/app/oracle/db
$> tar -xvf orahome.tar
3) Execute perl clone.pl script to clone a new ORACLE HOME
Setting up the environment
export ORACLE_BASE=/u02/app/oracle
export ORACLE_HOME=/u02/app/oracle/db
export PATH=${ORACLE_HOME}/bin:$PATH
Executing the clone.pl
Utility Details
Perl Script: $ORACLE_HOME/clone/bin/clone.pl.
It accepts ORACLE HOME and ORACLE HOME NAME as parameters.
Steps
Current Oracle Home: /u01/app/oracle/db
New Oracle Home: /u02/app/oracle/db
1) Tar the current ORACLE_HOME as ‘oracle’ user or the dbuser(what ever defined)
$> cd /u01/app/oracle/db
$> tar -cvf orahome.tar *
2) Copy the tar to new ORACLE_HOME location/ new server Oracle Home location
$> cd /u02/app/oracle/db
$> tar -xvf orahome.tar
3) Execute perl clone.pl script to clone a new ORACLE HOME
Setting up the environment
export ORACLE_BASE=/u02/app/oracle
export ORACLE_HOME=/u02/app/oracle/db
export PATH=${ORACLE_HOME}/bin:$PATH
Executing the clone.pl
cd $ORACLE_HOME/clone/bin
perl clone.pl -silent ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/dbhome_1 ORACLE_HOME_NAME="Ora12c_home" INVENTORY_LOCATION=/u01/app/oracle/oraInventory OSDBA_GROUP=oinstall OSOPER_GROUP=oinstall
perl ${ORACLE_HOME}/clone/bin/clone.pl ORACLE_HOME=/u02/app/oracle/db ORACLE_HOME_NAME=OraDb10g_home2
/runInstaller -silent -clone -waitForCompletion "ORACLE_HOME=/u02/app/oracle/db" "ORACLE_HOME_NAME=DbOra10g_Home2" -noConfig -nowait
Starting Oracle Universal Installer...
No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-07-12_12-12-09AM.
Please wait ...Oracle Universal Installer, Version 10.2.0.5.0 Production Copyright (C) 1999, 2010, Oracle. All rights reserved.
You can find a log of this install session at: /oracle/oraInventory/logs/cloneActions2013-07-12_12-12-09AM.log .................................................................................................... 100% Done. Installation in progress (Friday, July 12, 2013 12:19:30 AM EDT) ...........................................................................75% Done.
Install successful
Linking in progress (Friday, July 12, 2013 12:20:22 AM EDT) Link successful
Setup in progress (Friday, July 12, 2013 12:27:50 AM EDT) Setup successful
End of install phases.(Friday, July 12, 2013 12:28:39 AM EDT)
WARNING: The following configuration scripts need to be executed as the "root" user. #!/bin/sh #Root script to run /u02/app/oracle/db/root.sh
To execute the configuration scripts:
1. Open a terminal window
2. Log in as "root"
3. Run the scripts
The cloning of DbOra10g_Home2 was successful.
Please check '/oracle/oraInventory/logs/cloneActions2013-07-12_12-12-09AM.log' for more details.
You need to have access to run root.sh or get in touch with you UNIX admin to get it executed.
4.Make sure you check/verify the new path location in all files like tnsnames.ora,listener.ora,sqlnet.ora,ifile location and pfile intDEV.ora
3 Comments
Thanks for splitting your comprehension with us. It’s really useful to me & I hope it helps the people who in need of this vital information.
ReplyDeleteOracle Training in Chennai
Oracle Training Institute in Chennai
Thanks for splitting your comprehension with us.
ReplyDeleteWeblogic Server 12cR2 Training
Thank you for sharing
ReplyDeleteartificial intelligence training in chennai
Post a Comment