Environment
Source DB Version: 11.2.0.4
Source Operating System: RHEL 6.9
Source Oracle Home: /u01/TESTDB/11.2.0.4
Source OS User and Group: oratest, dba
Target DB Version: 11.2.0.4
Target Operating System: RHEL 6.9
Target Oracle Home: /u02/TESTDB/11.2.0.4
Target OS User and Group: oratest, dba
Step - 1:
Make sure that server meets all of the prerequisite requirements required to install 11gR2 Oracle Home
Refer to 11gR2 Quick Install Guide https://docs.oracle.com/cd/E11882_01/install.112/e24326/toc.htm for the list of required pre-requisites
Step - 2:
Copy Oracle Home from Source to Target. Source database and listener can be up and running during Oracle Home Copy.
cd /u01/TESTDB
scp -pr 11.2.0.4 oratest@dba03.oracle.com:/u02/TESTDB/
Step - 3:
Create an inventory directory in target server and, edit the inventory location file to point to the newly created inventory directory. Ensure that oratest user has read and write permissions on inventory directory
mkdir -p /home/oratest/oraInventory
cat /etc/oraInst.loc
inventory_loc=/home/oratest/oraInventory
inst_group=dba
Step - 4:
Run the clone command on target server to clone the Oracle Home. Ensure that the perl version is 5.6 or above (Ex: perl -v)
perl clone.pl ORACLE_HOME="/u02/TESTDB/11.2.0.4" ORACLE_HOME_NAME="OraHome3" ORACLE_BASE="/u02/TESTDB" OSDBA_GROUP=dba OSOPER_GROUP=dba
LOG:
./runInstaller -clone -waitForCompletion "ORACLE_HOME=/u02/TESTDB/11.2.0.4/" "ORACLE_HOME_NAME=OraHome3" "ORACLE_BASE=/u02/TESTDB/" "oracle_install_OSDBA=dba" "oracle_install_OSOPER=dba" -silent -noConfig -nowait
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 8142 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2019-01-25_03-17-42PM. Please wait ...Oracle Universal Installer, Version 11.2.0.4.0 Production
Copyright (C) 1999, 2013, Oracle. All rights reserved.
You can find the log of this install session at:
/home/oratest/oraInventory/logs/cloneActions2019-01-25_03-17-42PM.log
.................................................................................................... 100% Done.
Installation in progress (Friday, January 25, 2019 3:17:48 PM IST)
.............................................................................. 78% Done.
Install successful
Linking in progress (Friday, January 25, 2019 3:17:51 PM IST)
Link successful
Setup in progress (Friday, January 25, 2019 3:18:16 PM IST)
Setup successful
End of install phases.(Friday, January 25, 2019 3:18:39 PM IST)
WARNING:
The following configuration scripts need to be executed as the "root" user.
/u02/TESTDB/11.2.0.4//root.sh
To execute the configuration scripts:
1. Open a terminal window
2. Log in as "root"
3. Run the scripts
The cloning of OraHome3 was successful.
Please check '/home/oratest/oraInventory/logs/cloneActions2019-01-25_03-17-42PM.log' for more details.
oratest@dba03.oracle.com: bin]$
Step - 5:
Run root.sh in target home
NOTE: When running the root.sh in the clone it overwrites the files in /usr/local/bin (oraenv, coraenv, dbhome). It does not prompt if those files are to be overwritten or give a choice (as in a clean install). These files should be backed up if used.
As root user, run /u02/TESTDB/11.2.0.4/root.sh
Step - 6:
Run the below script to create Automatic Diagnostic Repository (ADR) directory structure
/u02/TESTDB/11.2.0.4/bin/diagsetup basedir=/u02/TESTDB oraclehome=/u02/TESTDB/11.2.0.4
oratest@dba03.oracle.com: TESTDB]$ ls
11.2.0.4 checkpoints diag
Set environment and invoke sqlplus to ensure that the Oracle Home is cloned properly
export ORACLE_BASE=/u02/TESTDB
export ORACLE_HOME=/u02/TESTDB/11.2.0.4
export ORACLE_SID=DB003
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
oratest@dba03.oracle.com: ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Jan 25 15:56:57 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
That's it......................
Cheers!!!!!! - Charan