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
- > 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. - > srvctl remove instance -d dsrvdb -i dsrvdb3
Remove instance dsrvdb3 from the database dsrvdb? (y/[n]) y
> srvctl start service -d dsrvdb -s appdsrv -i dsrvdb2
csrv0dbxd01 | ORA1020 | /export/home/oracle
> showcrs- > 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 - 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 - run netca and remove listener on node
- or use crs_unregister
- [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 - > crs_unregister -q ora.csrv0dbxd03.LISTENER_CSRV0DBXD03.lsnr
csrv0dbxd01 | ORA1020 | /export/home/oracle
> crs_unregister -q ora.csrv0dbxd03.vip - 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 - 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 - 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
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- 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 - should be able to start listener
No comments:
Post a Comment