Oracle RAC – Delete OLD or FAILED Node

-bash-4.1$ olsnodes -s -t
mynode1       Inactive        Unpinned
mynode2       Active  Unpinned
[root@oral8001 bin]# ./crsctl delete node -n oral8002
 CRS-4661: Node oral8002 successfully deleted.

-bash-4.1$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CLSTR.dg
               ONLINE  ONLINE       mynode2
ora.LISTENER.lsnr
               ONLINE  ONLINE       mynode2
ora.ORADATA1.dg
               ONLINE  ONLINE       mynode2
ora.ORAFRA.dg
               ONLINE  ONLINE       mynode2
ora.ORASYS.dg
               ONLINE  ONLINE       mynode2
ora.asm
               ONLINE  ONLINE       mynode2                Started
ora.gsd
               OFFLINE OFFLINE      mynode2
ora.net1.network
               ONLINE  ONLINE       mynode2
ora.ons
               ONLINE  ONLINE       mynode2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       mynode2
ora.cvu
      1        ONLINE  ONLINE       mynode2
ora.mynode1.vip
      1        ONLINE  INTERMEDIATE mynode2                FAILED OVER
ora.mynode2.vip
      1        ONLINE  ONLINE       mynode2
ora.nvtxkk.db
      1        ONLINE  OFFLINE
      2        ONLINE  ONLINE       mynode2                Open
ora.oc4j
      1        ONLINE  ONLINE       mynode2
ora.scan1.vip
      1        ONLINE  ONLINE       mynode2
[root@mynode2 bin]# ./srvctl stop vip -i mynode1-vip

[root@mynode2 bin]# ./crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CLSTR.dg
               ONLINE  ONLINE       mynode2
ora.LISTENER.lsnr
               ONLINE  ONLINE       mynode2
ora.ORADATA1.dg
               ONLINE  ONLINE       mynode2
ora.ORAFRA.dg
               ONLINE  ONLINE       mynode2
ora.ORASYS.dg
               ONLINE  ONLINE       mynode2
ora.asm
               ONLINE  ONLINE       mynode2                Started
ora.gsd
               OFFLINE OFFLINE      mynode2
ora.net1.network
               ONLINE  ONLINE       mynode2
ora.ons
               ONLINE  ONLINE       mynode2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       mynode2
ora.cvu
      1        ONLINE  ONLINE       mynode2
ora.mynode1.vip
      1        OFFLINE OFFLINE
ora.mynode2.vip
      1        ONLINE  ONLINE       mynode2
ora.nvtxkk.db
      1        ONLINE  OFFLINE
      2        ONLINE  ONLINE       mynode2                Open
ora.oc4j
      1        ONLINE  ONLINE       mynode2
ora.scan1.vip
      1        ONLINE  ONLINE       mynode2
[root@mynode2 bin]# ./srvctl remove vip -i mynode1-vip
Please confirm that you intend to remove the VIPs mynode1-vip (y/[n]) y
$ pwd
 /u01/app/root/product/11.2.0/grid/oui/bin

-bash-4.1$ ./runInstaller -updateNodelist ORACLE_HOME=/u01/app/11.2.0/grid "CLUSTER_NODES={mynode2}" CRS=true
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 16369 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successful.
-bash-4.1$ olsnodes -s -t
mynode2       Active  Unpinned

http://oracleinstall.wordpress.com/2011/08/05/removing-a-node-from-oracle-rac-11gr2/
http://gruffdba.wordpress.com/2012/10/29/oracle-11gr2-rac-install-cleaning-up-a-failed-install-on-linux/
http://pakdba.wordpress.com/2012/06/25/removing-a-node-from-rac-11gr2/
http://www.colestock.com/how-to-delete-a-node-from-oracle-rac-11gr2/
http://iamthelinuxsysadmin.blogspot.in/2011/12/removing-node-from-oracle-rac-cluster.html

http://www.oracle-base.com/articles/rac/delete-an-instance-from-an-oracle-rac-database.php

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.