DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, January 11, 2018

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



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.

No comments: