12.2 Migrating Standalone Grid Infrastructure Servers to a Cluster

If you have an Oracle Database installation using Oracle Restart (an Oracle Grid Infrastructure installation for a standalone server), then you can reconfigure that server as a cluster member node. Complete the following tasks.

1. Inspect the Oracle Restart configuration with the Server Control (SRVCTL) utility using the following syntax, where db_unique_name is the unique name for the database, and lsnrname is the name of the listener for the database:

   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; you will need this information in a later step.
2. Stop all of the databases, services, and listeners that you discovered in step 1.
3. Log in as an Administrator user and navigate to the directory Grid_home\crs\install, where Grid_home is the location of your Oracle Grid Infrastructure home (Grid home) directory, for example:

   C:\> cd app\21.0.0\grid\crs\install

4. Unconfigure the Oracle Grid Infrastructure installation for a standalone server (Oracle Restart) using the following command:

   C:\..\install> roothas.bat -deconfig -force

5. Prepare the server for Oracle Clusterware configuration, as described in Chapter 2 through Chapter 7 of this guide. In addition, choose to install Oracle Grid Infrastructure for a cluster in the same location as Oracle Restart, or in a different location:

   Option	Description
   Installing in the Same Location as Oracle Restart	Proceed to step 7.
   Installing in a Different Location than Oracle Restart	Set up Oracle Grid Infrastructure software in the new Grid home software location, then proceed to step 7.

6. 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

7. As the Oracle Installation user for Oracle Grid Infrastructure, run the installer.

   You can complete the installation interactively, or if you want to perform a silent installation, then save and stage the response file. After saving the response file, run the following command. For the -responseFile parameter, specify the full path name where the response file was saved, for example:

   C:\> Grid_home\setup.exe -silent -responseFile C:\Users\dba1\scripts\GI.rsp

8. Mount the Oracle ASM disk group used by Oracle Restart.
9. 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. Verify that the %ORACLE_HOME% environment variable is set to the location of the database home directory.
   2. 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:

      srvctl add service -db mydb -service myservice

10. Add nodes to your cluster, as required, using the Oracle Grid Infrastructure installer.

    See Also:

    • Recording Response Files for more information about saving the response file

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