How to Remove Node From Oracle RAC Cluster

Information about How to Remove Node from Oracle RAC Cluster

This document describes the process to remove a node from an active Oracle RAC Cluster.

Document Creator Todd Walters  

Remove Node from Oracle RAC Cluster

1. > srvctl remove instance -d dwakdb -i dwakdb3
   Remove instance dwakdb3 from the database dwakdb? (y/[n]) y
   PRKP-1075 : Instance dwakdb3 is the last preferred instance for service
   APPDWAK.
2. > srvctl remove instance -d dwakdb -i dwakdb3
   Remove instance dwakdb3 from the database dwakdb? (y/[n]) y
3. 
   > srvctl start service  -d dwakdb -s appdwak -i dwakdb2
   srv0dbxd01 | ORA1020 | /export/home/oracle
   > showcrs
4. > srvctl stop asm -n srv0dbxd03
   srv0dbxd01 | ORA1020 | /export/home/oracle
   > srvctl remove asm -n srv0dbxd03
   srv0dbxd01 | ORA1020 | /export/home/oracle 
   Verisrfy it was removed:
   > srvctl config asm -n srv0dbxd03
5. Before removing node, determine node name and CRS-assigned node number in OCR
   srv0dbxd01 | CRS | /u00/app/oracle/product/10.2.0/CRS/bin
   > ./olsnodes -n
   srv0dbxd01     1
   srv0dbxd02     2
   srv0dbxd03     3
6. run netca and remove listener on node
7. or use crs_unregister
8. [root@srv0dbxd01 bin]# ./srvctl remove nodeapps -n srv0dbxd03
   Please confirm that you intend to remove the node-level applications on node srv0dbxd03 (y/[n]) y
   PRKO-2112 : Some or all node applications are not removed successfully on node: srv0dbxd03
9. > crs_unregister -q ora.srv0dbxd03.LISTENER_SRV0dbxd03.lsnr
   srv0dbxd01 | ORA1020 | /export/home/oracle
   > crs_unregister -q ora.srv0dbxd03.vip
10. 
    
11. Update the node list using OUI on DB
    /runInstaller -ignoreSysPrereqs -updateNodeList ORACLE_HOME=/u00/app/oracle//product/10.2.0/DB CLUSTER_NODES=srv0dbxd01,srv0dbxd02
12. Update the node list using OUI on CRS
    /runInstaller -ignoreSysPrereqs -updateNodeList ORACLE_HOME=/u00/app/oracle//product/10.2.0/CRS CLUSTER_NODES=srv0dbxd01,srv0dbxd02
13. Delete the node from the cluster
    [root@srv0dbxd01 install]# ./rootdeletenode.sh srv0dbxd03,3
    CRS-0216: Could not stop resource 'ora.srv0dbxd03.LISTENER_SRV0dbxd03.lsnr'.
    CRS-0210: Could not find resource 'ora.srv0dbxd03.ons'.
    CRS-0216: Could not stop resource 'ora.srv0dbxd03.vip'.
    CRS-0210: Could not find resource 'ora.srv0dbxd03.gsd'.
    PRKO-2112 : Some or all node applications are not removed successfully on node: srv0dbxd03
    CRS nodeapps are deleted successfully
    clscfg: EXISTING configuration version 3 detected.
    clscfg: version 3 is 10G Release 2.
    CSS indicates failure 17 acknowledging the deletion.
    Attempting to roll back the deletion.
    Rollback of node deletion successful.
    Node deletion failed but configuration is intact.
    'srv0dbxd03,3' deleted successfully
14. 
    To add Node - run $ORACLE_HOME/CRS/oui/bin/addNode.sh
    run for each home (ASM & DB)
    will see exclude file errors
    run each script on node it says to excute on
15. configure asm as root with /etc/init.d/oracleasm
    set TNS_ADMIN for new node  (had to run this as root)
    ./srvctl setenv nodeapps -n srv0dbxd03 -T TNS_ADMIN=/u00/app/oracle/product/10.2.0/ASM/network/admin
16. should be able to start listener