Announcements

Oracle training based on real-time expertise as per industry standards. Upcoming batch details are here.

View batch schedule

Free Oracle mock interview. Register using the link.

Register

#DBAchallenge: submit your questions.

Ask questions
Swipe for more →
Browse by Topic
Latest Posts

    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

    🌟 Proud to be an Oracle ACE Pro! 🚀

    🌟 Proud to be an Oracle ACE Pro! 🚀 I’m excited to share my official Oracle ACE Profile with the Oracle community. 👨‍💻 Mallikarjun ...