Delete and add nodes in 11g rac under windows
The first is to delete:
1 dbca delete node rac1, and delete it as prompted, in which you need to enter the sys password
Crsctl unpin css-n rac1
"after the execution of the grid user to view the resource pool, the rac2 is no longer in the serverpool, then continue to delete the cluster information.
Srvctl config serverpool
Cd / here grid installation directory / bin
# stop the cluster of failed nodes
.\ crsctl stop cluster-n rac1
# View resource status
Crsctl status res-tcrsctl check cluster-all
# deleting the application layer
Crsctl delete node-n rac1crsctl stop resource ora.rac1.vip-fcrsctl delete resource ora.rac1.vip-f
If the vip is still there, you can delete the vip with the following command
Netsh interface ip delete address name= "" addr=xx.xx.xx.xx
Update the post-deletion information:
Cd-d% ORACLE_HOME%\ oui\ bin.\ setup-updateNodeList ORACLE_HOME=d:\ app\ 11.2.0\ grid "CLUSTER_NODES= {rac2}" CRS=TRUEolsnodes-I-t-s
-- perform post-deletion check
Cluvfy stage-post nodedel-n rac1-verbose
Add nodes
Notepad C:\ Windows\ System32\ drivers\ etc\ hosts127.0.0.1 localhost10.10.8.10 RAC-SCAN10.10.8.11 RAC110.10.8.13 RAC210.10.8.12 RAC1-VIP10.10.8.14 RAC2-VIP192.168.1.11 RAC1-PRIV192.168.1.12 RAC2-PRIV
# configure network parameters
Netsh int ipv4 set global dhcpmediasense=disablednetsh int ipv6 set global dhcpmediasense=disablednetsh advfirewall set currentprofile state offnetsh int ipv4 set global dhcpmediasense=disablednetsh int tcp set global chimney=disablednetsh int tcp set global rss=disabled
# check the service
Net stop msdtcnet start RemoteRegistry
# add Node
Cd-d% ORACLE_HOME%\ oui\ binset ignore_preaddnode_checks=Y.\ addnode.bat "CLUSTER_NEW_NODES= {rac1}"CLUSTER_NEW_PRIVATE_NODE_NAMES= {rac1-priv}"CLUSTER_NEW_VIRTUAL_HOSTNAMES= {RAC1-VIP}" D:\ app\ 11.2.0\ grid\ crs\ config\ gridconfig.batset ROOTHASPL=%OH%\ perl\ bin\ perl-I% OH%\ perl\ lib-I% OH%\ crs\ install% OH%\ crs\ Install\ roothas.pl-notermset ROOTCRSPL=%OH%\ perl\ bin\ perl-I% OH%\ perl\ lib-I% OH%\ crs\ install% OH%\ crs\ install\ rootcrs.pl-noterm
# check after adding
Cluvfy stage-post nodeadd-n rac1-verbose
# add db instance
Set ORACLE_HOME=D:\ app\ Administrator\ product\ 11.2.0\ dbhome_1cd% ORACLE_HOME%/oui/bin/.\ addnode.bat "CLUSTER_NEW_NODES= {rac1}"
Reference:
Add crs: https://docs.oracle.com/cd/E11882_01/rac.112/e41959/adddelclusterware.htm#CWADD90997
Add db instance: https://docs.oracle.com/cd/E11882_01/rac.112/e41960/adddelwin.htm#RACAD8200
