Migrating Standalone Oracle Grid Infrastructure Servers to a Cluster

If you have an Oracle Database installation using Oracle Restart (that is, an Oracle Grid Infrastructure installation for a standalone server), and you want to configure that server as a cluster member node, then complete the following tasks:

  1. Inspect the Oracle Restart configuration with srvctl using the following syntax, where db_unique_name is the unique name for the database, and lsnrname is the name of the listener:

    srvctl config database -db db_unique_name

    srvctl config service -db db_unique_name

    srvctl config listener -listener lsnrname

    Write down the configuration information for the server.

  2. Stop all of the databases, services, and listeners that you discovered in step 1.

  3. If present, unmount all Oracle Automatic Storage Management Cluster File System (Oracle ACFS) file systems.

  4. Log in as root, and change directory to Grid home/crs/install. For example:

    # cd /u01/app/12.2.0/grid/crs/install
    
  5. Unconfigure the Oracle Grid Infrastructure installation for a standalone server (Oracle Restart), using the following command:

    # roothas.sh -deconfig -force
    
  6. Open the /etc/oratab file and remove the entry corresponding to oracle_restart_home.

  7. Prepare the server for Oracle Clusterware configuration, as described in this document. In addition, you can install Oracle Grid Infrastructure for a cluster in the same location as Oracle Restart, or in a different location.

    Installing in the Same Location as Oracle Restart

    1. Proceed to step 7.

    Installing in a Different Location than Oracle Restart

    1. Set up Oracle Grid Infrastructure software in the new Grid home software location as described in Installing Only the Oracle Grid Infrastructure Software.

    2. Proceed to step 7.

  8. Set the environment variables as follows:

    export oracle_install_asm_UseExistingDG=true or false 
    export oracle_install_asm_DiskGroupName=disk_group_name 
    export oracle_install_asm_DiskDiscoveryString=asm_discovery_string
    export oracle_install_asm_ConfigureGIMRDataDG=true or false
    export oracle_install_asm_GIMRDataDGName=disk_group_name
  9. As the Oracle Grid Infrastructure installation owner, run the installer.

    You can complete the installation either interactively or in the silent mode. If you perform a silent installation, save and stage the response file as described in Recording Response Files.

  10. After saving the response file, run the command:

    $ Grid_home/gridSetup.sh -silent -responseFile $ORACLE_HOME/GI.rsp
    
  11. Run root.sh.

  12. Mount the Oracle ASM disk group used by Oracle Restart.

  13. If you used Oracle ACFS with Oracle Restart, then:

    1. Start Oracle ASM Configuration Assistant (ASMCA). Run the volenable command to enable all Oracle Restart disk group volumes.

    2. Mount all Oracle ACFS file systems manually.

  14. Add back Oracle Clusterware services to the Oracle Clusterware home, using the information you wrote down in step 1, including adding back Oracle ACFS resources. For example:

    /u01/app/grid/product/12.2.0/grid/bin/srvctl add filesystem -device
    /dev/asm/db1  -diskgroup ORestartData -volume db1 -mountpointpath
    /u01/app/grid/product/12.2.0/db1 -user grid
    
  15. Add the Oracle Database for support by Oracle Grid Infrastructure for a cluster, using the configuration information you recorded in step 1. Use the following command syntax, where db_unique_name is the unique name of the database on the node, and nodename is the name of the node:

    srvctl add database -db db_unique_name -spfile -pwfile -oraclehome $ORACLE_HOME -node nodename

    1. For example, first verify that the ORACLE_HOME environment variable is set to the location of the database home directory.

    2. Next, to add the database name mydb, enter the following command:

      srvctl add database -db mydb -spfile -pwfile -oraclehome $ORACLE_HOME -node node1
      
    3. Add each service to the database, using the command srvctl add service. For example, add myservice as follows:

      srvctl add service -db mydb -service myservice
  16. Add nodes to your cluster, as required, using the Oracle Grid Infrastructure installer.

See Also:

Oracle Clusterware Administration and Deployment Guide for information about adding nodes to your cluster.