Clone Oracle Database Homes to the Replacement Compute Server

To clone the Oracle Database homes to the replacement server:

  1. Add Oracle Database ORACLE_HOME to the replacement compute server:
    $ cd /u01/app/oracle/product/12.1.0/db_home/addnode/
    $ ./addnode.sh -silent "CLUSTER_NEW_NODES={replacement_server}" -ignorePrereq
    

    The addnode script causes Oracle Universal Installer to copy the Oracle Database software to the replacement compute server.

    WARNING: The following configuration scripts need to be executed as the "root"
    user in each cluster node.
    /u01/app/oracle/product/12.1.0/dbhome_1/root.sh #On nodes ra01db01
    To execute the configuration scripts:
    Open a terminal window.
    Log in as root.
    Run the scripts on each cluster node.
     

    After the scripts are finished, the following messages appear:

    The Cluster Node Addition of /u01/app/oracle/product/12.1.0/dbhome_1 was
    successful.
    Please check '/tmp/silentInstall.log' for more details.
    
  2. Run the root.sh script on the replacement compute server:
    # /u01/app/oracle/product/12.1.0/dbhome_1/root.sh
     

    Check the /u01/app/oracle/product/12.1.0/dbhome_1/install/root_replacement_server.company.com_date.log file for the output of the script.

  3. Ensure that the instance parameters are set for the replaced database instance. The following is an example for the CLUSTER_INTERCONNECTS parameter.
    SQL> SHOW PARAMETER cluster_interconnects
    
    NAME                                 TYPE        VALUE
    ------------------------------       --------    -------------------------
    cluster_interconnects                string
     
    SQL> ALTER SYSTEM SET cluster_interconnects='192.168.73.90' SCOPE=spfile SID='dbm1';
    
  4. Validate the configuration files and correct them as necessary:
    • The ORACLE_HOME/dbs/initSID.ora file points to server parameter file (SPFILE) in the Oracle ASM shared storage.

    • The password file that is copied in the ORACLE_HOME/dbs directory has been changed to orapwSID.

  5. Restart the database instance.