11g R2 RAC has extremely simplified the process of deleing a node to the cluster as compared to 10g RAC or 11g R1 RAC. To know the procedure to delete a node in 10g RAC or 11g R1 RAC pls click here.
Now, after the introduction of SCAN and GPNP, we need to follow very simple steps.
Current scenario:
I have three nodes in the cluster presently.
Host names :
- host01.example.com
- host02.example.com
- host03.example.com
Node to be deleted :
- host03.example.com
Procedure:
– Login as root on the node(s) to be deleted(host03) navigate to <gridhome>/crs/install
[root@host03]#cd /u01/app/11.2.0/grid/crs/install
– Disable oracle clusterware applications and applications on the node (host03)
[root@host03]#./rootcrs.pl -deconfig -force
– From a node that will remain(host01) , delete the node
root@host01]#crsctl delete node -n host03
– on a node that will remain , login as grid user, navigate to gridhome/oui/bin and update node list
[grid@host01]$cd /u01/app/11.2.0/grid/oui/bin
[grid@host0$]./runInstaller -updateNodeList ORACLE_HOME=/u01/app/11.2.0/grid “CLUSTER_NODES={host01,host02}”
– check that only nodes 1 and 2 remain
$crsctl stat res -t
References:
By doing above steps does oracle instance on node 3 will it be deleted automatically ?
Hi Balasahe,
In the cluster mentioned in this post, only grid infra has been installed. Oracle RAC database software has not been installed.
However, to remove a node from Oracle RAC, you must first remove the Oracle instance, de-install the Oracle Database software and then remove Oracle Grid Infrastructure from the node you are deleting. In other words, you remove the software components from the node you are deleting in the reverse order that you originally installed them.
Pls refer to following link: http://www.idevelopment.info/data/Oracle/DBA_tips/Oracle11gRAC/CLUSTER_24.shtml
Hope it helps
Anju
Do we need to take the downtime when we delete the node from the cluster ?????
Hi Pradeep,
No downtime is required to delete the node from the cluster.
regards
Anju