Wednesday, March 6, 2013

Delete node from rac cluster

I had created a four node rac cluster.
 Everything was running fine until i got a call that one of the node's
was down. After checking it was the u01 filesystem that was corrupt.
There was no other solution then delete this node from the cluster
and then recreate the node again and add the node to the cluster.

First we have to delete the node from the cluster.

$ ./olsnodes -s -n
test1001         1       Inactive
test1002         2       Active
test1003         3       Active
test1004         4       Active

As you see test1001 is inactive which is correct as it's down.

Now we delete the node from clusterware configuration
as user root from one of the remaining nodes

$ ./crsctl delete node -n test1001
CRS-4661: Node test1001 successfully deleted.

now we have to do 1 thing and that is update the inventory.
As user Oracle

./runInstaller -updateNodelist ORACLE_HOME=/u01/app/grid/11.2.0.2 "CLUSTER_NODES={test1002,test1003,test1004}" CRS=true
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB.   Actual 3071 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oracle/oraInventory
UpdateNodeList’ was successful.

the parameter cluster_nodes has the remaining nodes in it.

$ ./olsnodes -s -n
test1002        2       Active
test1003        3       Active
test1004        4       Active

That's it

Reminder.
This is a short version off deleting a node from cluster
as in my case the node didn't exsist anymore.
If the node exsist you have to do some more steps.
A good blog for this is http://blog.grid-it.nl/index.php/2011/04/05/deleting-a-node-from-the-cluster-in-11gr2/

No comments:

Post a Comment