Steps to create ORACLE_HOME after copying oracle binaries from source to destination.

Step 1 :

Tar the ORACLE_HOME in the source instance.

tar -cvf /DUMP_TABLE/backup/11203_PROD.tar /prddb01/oracle/PROD/db/tech_st/11.2.0.3/

Step 2 :

Scp the tar file to the destination.

Scp .tar oracle@44.13.1.7:/prod/oracle/PROD/db/tech_st/11.2.0.3/

Step 3:

Untar the tar file in the destination

Tar -xvf 11203_PROD.tar

Step 4 :

Go to ORACLE_HOME/clone/bin and run clone.pl with ORACLE_BASE,ORACLE_HOME,ORACLE_HOME_NAME

cd $ORACLE_HOME/clone/bin

perl clone.pl ORACLE_BASE=/prod/oracle/PROD ORACLE_HOME=/prod/oracle/PROD/db/tech_st/11.2.0.3 ORACLE_HOME_NAME=11G_PRODDR

Note : If you face the error like ORACLE_HOME already exists then perform the below steps

*Open the /etc/oraInst.loc and comment the home you specified in the clone.pl command

*Go to $ORACLE_HOME/oui/bin and use the runInstaller

./runInstaller -silent -ignoreSysPrereqs -detachHome ORACLE_HOME=/prod/oracle/PROD/db/tech_st/11.2.0.3 ORACLE_HOME_NAME=11G_PRODDR

After the runInstaller run root.sh

Now set the ORACLE_HOME environment

export ORACLE_HOME=/prod/oracle/PROD/db/tech_st/11.2.0.3

export PATH=$ORACLE_HOME/bin:$PATH

export ORACLE_SID=PRODDR

Try to connect sqlplus,you will get below error

Now Try to connect sqlplus still if you get permission denied use below steps

cat $ORACLE_HOME/rdbms/lib/config.s

.csect H.13.NO_SYMBOL{RO}, 3
.string “”
# End csect H.13.NO_SYMBOL{RO}

.csect H.14.NO_SYMBOL{RO}, 3
.string “”

Now change the file as below.

.csect H.13.NO_SYMBOL{RO}, 3
.string “dba”
# End csect H.13.NO_SYMBOL{RO}

.csect H.14.NO_SYMBOL{RO}, 3
.string “dba”

After changing we should run relink,use below command.

/prod/oracle/PROD/db/tech_st/11.2.0.3/bin/relink

Now sqlplus will connect.