Thursday, June 4, 2020

Manual Oracle Home Cloning || 11g Release 2 (11.2.0.4)

Below are the details manual oracle home cloning steps.

Please refer the attached log file with detailed steps and execution log files.

Please refer my YouTube channel and for more details

https://youtu.be/czC73ljVCKE


1. Take tar backup of existing Oracle home.

tar -cvzf OH_BINARIES_BKP.tar.gz /u01/app/oracle/product/11204/dbhome_1/*

2. untar the backup tar file in step1 with Target Oracle home and target owner

mkdir -p /u01/app/oracle/product/11204/dbhome_2
cd /u01/app/oracle/product/11204/dbhome_2
tar -xvzf/u01/app/oracle/product/11204/OH_BINARIES_BKP.tar.gz .

3. Post steps to be performed on both the nodes. 

cd /u01/app/oracle/product/11204/dbhome_2/clone/bin 
./clone.pl ORACLE_HOME=/u01/app/oracle/product/11204/dbhome_2 ORACLE_HOME_NAME=11204_dbhome_2 ORACLE_BASE=/u01/app/oracle

4. Update the cluster nodes 

Repeat step1 to step3 on all cluster nodes and run below commands

/u01/app/oracle/product/11204/dbhome_2/oui/bin/runInstaller -updateNodeListORACLE_HOME=/u01/app/oracle/product/11204/dbhome_2 "CLUSTER_NODES={npexdbadm01, npexdbadm02}"

5. Enable on rds protocol on oracle Home (Applicable only for Oracle homes in EXADATA machine) 

export ORACLE_HOME=/u01/app/oracle/product/11204/dbhome_2


cd $ORACLE_HOME/rdbms/lib

make -f ins_rdbms.mk ipc_rdsioracle

6. To check if the Binaries are RAC Enabled: (Applicable only for RAC)

cd $ORACLE_HOME/rdbms/lib
nm -r libknlopt.a | grep -c kcsm.o
1 >>> means RAC feature enabled 
0 >>> means RAC feature NOT enabled 

cd $ORACLE_HOME/rdbms/lib

make -f ins_rdbms.mk rac_onioracle

7. Verification:

/u01/app/oracle/product/11204/dbhome_2/OPatch/opatchlsinventory

 cat /u01/app/oracInventory/Context/inventory.xml  

>>> Verify Target OH is having all the cluster nodes


Regards,

Mallik


No comments:

Post a Comment

Automation Script | Archivelog Generation Hourly Monitoring

1. List out all the running databases and pic one database where we want to monitore the archive log generation from last 1 month. [oracle@o...