Deleting a Cluster Node on Windows Systems

This section describes how to delete a cluster node on Windows systems. This procedure assumes that Oracle Clusterware is installed on node1, node2, and node3, and that you are deleting node3 from the cluster.

Note:

  • Oracle does not support using Oracle Enterprise Manager to delete nodes on Windows systems.

  • If you delete the last node of a cluster that is serviced by GNS, then you must delete the entries for that cluster from GNS.

  • You can remove the Oracle RAC database instance from the node before removing the node from the cluster but this step is not required. If you do not remove the instance, then the instance is still configured but never runs. Deleting a node from a cluster does not remove a node's configuration information from the cluster. The residual configuration information does not interfere with the operation of the cluster.

    See Also: Oracle Real Application Clusters Administration and Deployment Guide for more information about deleting an Oracle RAC database instance

To delete a cluster node on Windows systems:

  1. Only if you have a local home, on the node you want to delete, run the following command with -local option to update the node list:
    C:\>Grid_home\oui\bin\setup.exe -updateNodeList ORACLE_HOME=Grid_home "CLUSTER_NODES=
    {node_to_be_deleted}" CRS=TRUE -local

    Note:

    If you are deleting a Leaf Node from an Oracle Flex Cluster, then you do not have run this command.

  2. Run the deinstall tool on the node you want to delete to deinstall and deconfigure the Oracle Clusterware home, as follows:
    C:\Grid_home\deinstall\>deinstall.bat -local

    Caution:

    • If you do not specify the -local flag, then the command removes the Oracle Grid Infrastructure home from every node in the cluster.

    • If you cut and paste the preceding command, then paste it into a text editor before pasting it to the command line to remove any formatting this document might contain.

  3. On any node that you are not deleting, run the following command from the Grid_home\oui\bin directory where remaining_nodes_list is a comma-delimited list of the nodes that are going to remain part of your cluster:
    C:\>setup.exe –updateNodeList ORACLE_HOME=Grid_home
    "CLUSTER_NODES={remaining_nodes_list}" CRS=TRUE -silent

    Note:

    • You must run this command a second time where ORACLE_HOME=ORACLE_HOME, and CRS=TRUE -silent is omitted from the syntax, as follows:

      C:\>setup.exe -updateNodeList ORACLE_HOME=ORACLE_HOME
       "CLUSTER_NODES={remaining_nodes_list}"
      
    • If you have a shared Oracle Grid Infrastructure home, then append the -cfs option to the command example in this step and provide a complete path ___location for the cluster file system.

  4. On a node that you are not deleting, run the following command:
    C:\>Grid_home\bin\crsctl delete node -n node_to_be_deleted
    
  5. Run the following CVU command to verify that the specified nodes have been successfully deleted from the cluster:
    C:\>cluvfy stage -post nodedel -n node_list [-verbose]
  6. If you remove a cluster node on which Oracle Clusterware is down, then determine whether the VIP for the deleted node still exists, as follows:
    C:\> ORACLE_HOME/bin/srvctl config vip -node deleted_node_name

    If the VIP still exists, then delete it, as follows:

    C:\> ORACLE_HOME/bin/srvctl srvctl stop vip -node deleted_node_name
    C:\> ORACLE_HOME/bin/srvctl srvctl remove vip -node deleted_node_name