Adding a Node to a Cluster on Windows Systems

Ensure that you complete the prerequisites listed in "Prerequisite Steps for Adding Cluster Nodes" before adding nodes.

This procedure describes how to add a node to your cluster. This procedure assumes that:

• There is an existing cluster with two nodes named node1 and node2

• You are adding a node named node3

• You have successfully installed Oracle Clusterware on node1 and node2 in a local home, where Grid_home represents the successfully installed home

To add a node:

1. Verify the integrity of the cluster and node3:

   C:\>cluvfy stage -pre nodeadd -n node3 [-fixup] [-verbose]
   

   You can specify the -fixup option and a directory into which CVU prints instructions to fix the cluster or node if the verification fails.

2. On node1, go to the Grid_home\addnode directory and run the addnode.bat script, as follows:

   C:\>addnode.bat "CLUSTER_NEW_NODES={node3}"
   "CLUSTER_NEW_VIRTUAL_HOSTNAMES={node3-vip}"
   

3. Run the following command on the new node:

   C:\>Grid_home\crs\config\gridconfig.bat
   

4. The following steps are required only if you have database homes configured to use Oracle ACFS:

   1. For each database configured to use Oracle ACFS, run the following command from the Oracle RAC database home:

      C:\> ORACLE_HOME/bin/srvctl stop database -db database_unique_name

      Note:

      Run the srvctl config database command to list all of the databases configured with Oracle Clusterware. Use the srvctl config database -db database_unique_name to find the database details. If the ORACLE_HOME path leads to the Oracle ACFS mount path, then the database uses Oracle ACFS. Use the command output to find the database instance name configured to run on the newly added node.

   2. Use Windows Server Manager Control to stop and delete services.

   3. For each of the databases and database homes collected in step 4.a, run the following command:

      C:\> ORACLE_HOME/bin/srvctl start database -db database_unique_name
      

5. Run the following command to verify the integrity of the Oracle Clusterware components on all of the configured nodes, both the preexisting nodes and the nodes that you have added:

   C:\>cluvfy stage -post crsinst -n all [-verbose]
   

After you complete the procedure in this section for adding nodes, you can optionally extend Oracle Database with Oracle RAC components to the new nodes, making them members of an existing Oracle RAC database.

Creating the OraMTS Service for Microsoft Transaction Server

Oracle Services for Microsoft Transaction Server (OraMTS) permit Oracle databases to be used as resource managers in Microsoft application-coordinated transactions. OraMTS acts as a proxy for the Oracle database to the Microsoft Distributed Transaction Coordinator (MSDTC). As a result, OraMTS provides client-side connection pooling and allows client components that leverage Oracle to participate in promotable and distributed transactions. In addition, OraMTS can operate with Oracle databases running on any operating system, given that the services themselves are run on Windows.

On releases earlier than Oracle Database 12c, the OraMTS service was created as part of a software-only installation. Starting with Oracle Database 12c, you must use a configuration tool to create this service.

Create the OraMTS service after adding a node or performing a software-only installation for Oracle RAC, as follows:

1. Open a command window.

2. Change directories to %ORACLE_HOME%\bin.

3. Run the OraMTSCtl utility to create the OraMTS Service, where host_name is a list of nodes on which the service should be created:

   C:\..bin> oramtsctl.exe -new -host host_name