[@more@]
Source Server:
****************
steps 1:
ORACLE_HOME: /JASUATDB01//oracle/product/10.2.0.1
Tar the oracle home 10.2.0.1
$cd /JASUATDB01//oracle/product
$tar -cvf 10.2.0.1.tar 10.2.0.1
Destination server:
******************
Steps 2:
Copy the oracle binary tar file from source server to Destination server.
$mkdir -p /JASUATDB01//oracle/product
$cd /JASUATDB01//oracle/product
$sftp oracle@source
$cd /JASUATDB01//oracle/product
$get 10.2.0.1.tar
$bye
$tar -cvf 10.2.0.1.tar
Steps 3:
Create the oratab file in appropriate path.
Enter the detail first in oratab: Eg..
Cat Oratab
cd /var/opt/oracle/oratab
testdb:/JASUATDB01//oracle/product/10.2.0.1:N
Steps 4:
Invoke the oraenv ( Optional method)
I need to create the testdb instance in dest server.
cd $ORACLE_HOME/bin
export ORACLE_HOME=/JASUATDB01//oracle/product/10.2.0.1
Source the SID ----- Here it is testdb
. oraenv
testdb
Steps 5:
Create the oraInst.loc in appropriate path.
Edit the oraInst.loc
/var/opt/oracle/oraInst.loc
inventory_loc=/JASUATDB01//oracle/product/10.2.0.1/oraInventory
Steps 6:
cd $ORACLE_HOME/oui/bin
edit *.sh(modify ORACLE_HOME if needed, i.e.: replace ECDSUAT to ECDSPRD)
# ORACLE_HOME_NAME should be diff in source/target in the same machine
./runInstaller -clone -silent -invPtrLoc /home/oracle/oraInst.loc -ignoreSysPrereqs ORACLE_HOME="/ECDSPRDDB01/oracle/product/10.2.0" ORACLE_HOME_NAME="OHOME10"
Steps 7:
Execute the relink all
$cd $ORACLE_HOME/bin
$ls -lart relink*
$relink all
Note:
changePerm.sh is a script that allows users that do not belong to the "dba" group to access and execute files in the ORACLE_HOME directory; run the changeperm.sh file in $ORACLE_HOME/install