This guide shows how to remove a node from an existing 11gR2 Oracle RAC cluster. It is assumed that the node in question is available and is not part of a GNS/Grid Plug and Play cluster. In other words, the database is considered to be "Administrator-Managed". Also, the database software is non-shared. This guide uses a 3-node cluster running Oracle Linux 6.3 (x64). The three nodes are "node1", "node2", and "node3",we will be removing "node3" from the cluster.
?
Delete Node from Cluster
"Unpin" node
"Unpin" the node – in our case "node3" – from all nodes that are to remain in the cluster; in this case,?"node1" and "node2". Specify the node you plan on deleting in the command and do so on each remaining node in the cluster.
?
- [root@node1?~]#?/u01/app/11.2.0/grid/bin/crsctl?unpin?css?-n?node3??
- CRS-4667:?Node?node3?successfully?unpinned.??
- [root@node2?~]#?/u01/app/11.2.0/grid/bin/crsctl?unpin?css?-n?node3??
- CRS-4667:?Node?node3?successfully?unpinned.??
Remove RAC Database Instance(s)
The node we are removing houses an instance – "zhongwc3" – which is part of a RAC database – "zhongwc".
Remove the "zhongwc3" instance from the "zhongwc" database using "dbca" in "Silent Mode"
?
- [oracle@node1?~]$?dbca?-silent?-deleteInstance?-nodeList?node3?-gdbName?zhongwc?-instanceName?zhongwc3?-sysDBAUserName?sys?-sysDBAPassword?oracle??
