How to Add Node to Oracle RAC Cluster

Information about How to Add Node to Oracle RAC Cluster

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

Document Creator

Todd Walters  

How to Add Node to Oracle RAC Cluster 

1. > srvctl remove instance -d dsrvdb -i dsrvdb3
   Remove instance dsrvdb3 from the database dsrvdb? (y/[n]) y
   PRKP-1075 : Instance dsrvdb3 is the last preferred instance for service
   APPDSRV.
2. > srvctl remove instance -d dsrvdb -i dsrvdb3
   Remove instance dsrvdb3 from the database dsrvdb? (y/[n]) y
3. 
   > srvctl start service  -d dsrvdb -s appdsrv -i dsrvdb2
   csrv0dbxd01 | ORA1020 | /export/home/oracle
   > showcrs
4. > srvctl stop asm -n csrv0dbxd03
   csrv0dbxd01 | ORA1020 | /export/home/oracle
   > srvctl remove asm -n csrv0dbxd03
   csrv0dbxd01 | ORA1020 | /export/home/oracle 
   Verisrfy it was removed:
   > srvctl config asm -n csrv0dbxd03
5. Before removing node, determine node name and CRS-assigned node number in OCR
   csrv0dbxd01 | CRS | /u00/app/oracle/product/10.2.0/CRS/bin
   > ./olsnodes -n
   csrv0dbxd01     1
   csrv0dbxd02     2
   csrv0dbxd03     3
6. run netca and remove listener on node
7. or use crs_unregister
8. [root@csrv0dbxd01 bin]# ./srvctl remove nodeapps -n csrv0dbxd03
   Please confirm that you intend to remove the node-level applications on node csrv0dbxd03 (y/[n]) y
   PRKO-2112 : Some or all node applications are not removed successfully on node: csrv0dbxd03
9. > crs_unregister -q ora.csrv0dbxd03.LISTENER_CSRV0DBXD03.lsnr
   csrv0dbxd01 | ORA1020 | /export/home/oracle
   > crs_unregister -q ora.csrv0dbxd03.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=csrv0dbxd01,csrv0dbxd02
12. Update the node list using OUI on CRS
    /runInstaller -ignoreSysPrereqs -updateNodeList ORACLE_HOME=/u00/app/oracle//product/10.2.0/CRS CLUSTER_NODES=csrv0dbxd01,csrv0dbxd02
13. Delete the node from the cluster
    [root@csrv0dbxd01 install]# ./rootdeletenode.sh csrv0dbxd03,3
    CRS-0216: Could not stop resource 'ora.csrv0dbxd03.LISTENER_CSRV0DBXD03.lsnr'.
    CRS-0210: Could not find resource 'ora.csrv0dbxd03.ons'.
    CRS-0216: Could not stop resource 'ora.csrv0dbxd03.vip'.
    CRS-0210: Could not find resource 'ora.csrv0dbxd03.gsd'.
    PRKO-2112 : Some or all node applications are not removed successfully on node: csrv0dbxd03
    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.
    'csrv0dbxd03,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 csrv0dbxd03 -T TNS_ADMIN=/u00/app/oracle/product/10.2.0/ASM/network/admin
16. should be able to start listener

home | oracle | templates | about