Adding and Deleting Oracle RAC from Nodes on Windows Systems

Use these procedures to extend an existing Oracle Real Application Clusters (Oracle RAC) home on Microsoft Windows to other nodes and instances in the cluster, or delete Oracle RAC from nodes and instances in the cluster.

In these topics, the entries for Grid_home refer to the full path name for the Oracle Grid Infrastructure home, and the entries for Oracle_home refer to substitutes for environment variables for the Oracle home with Oracle RAC.

If your goal is to clone an existing Oracle RAC home to create multiple new Oracle RAC installations across the cluster, then use the cloning procedures that are described in "Cloning Oracle RAC to Nodes in a New Cluster".

Note:

Ensure that you have a current backup of Oracle Cluster Registry (OCR) before adding or deleting Oracle RAC by running the ocrconfig -showbackup command.

For all of the add node and delete node procedures, temporary directories such as %TEMP% or C:\Temp should not be shared directories. If your temporary directories are shared, then set your temporary environment variable, such as %TEMP%, to a location on a local node. In addition, use a directory path that exists on all of the nodes.

Adding Oracle RAC to Nodes with Oracle Grid Infrastructure Installed

To add Oracle RAC to existing Windows cluster nodes, verify the Grid Infrastructure and Oracle home environment settings, then extend the Oracle RAC home with addnode.bat, supplying the Oracle home user password or -promptPasswd when required. For shared non-ACFS file systems, obtain mount details with srvctl, mount the database home, attach it with setup.exe -attachHome, and update the inventory with -updateNodeList; back up the voting disk and OCR after completing the process.

Adding Administrator-Managed Oracle RAC Database Instances to Target Nodes

Oracle DBCA can add administrator-managed RAC instances to target nodes interactively or silently after the Oracle Clusterware and database homes are extended. DBCA creates and configures the instance, high-availability components, Oracle Net configuration, and optionally services; interactive mode uses Instance Management and Add Instance workflows, while silent mode uses dbca -silent -addInstance with the node and global database names. On Windows, create the OraMTS service with oramtsctl.exe -new -host after adding nodes or completing a software-only installation, then perform any required service configuration.

Deleting Oracle RAC from a Cluster Node

Removing RAC from a Windows cluster node requires deleting its database instances before removing the RAC software and node. Relocate and reconfigure services so the instance is not preferred or available, then use DBCA in silent or interactive mode to delete the instance, remove its Oracle Net configuration and OFA directories, verify and disable any remaining redo thread, and confirm OCR registration with srvctl. Disable and stop listeners on the target node, deinstall the Oracle home with deinstall -local or -cfs for shared homes, and finally run the Grid Infrastructure removal and node-list update procedures to delete the node from the cluster.