百度搜索,会很多文章关于如何添加删除节点的,而且这个操作也没有什么很多的技术含量,但是自己测试过,记录一下,以备后续查询,同时也希望能给需要的朋友一些帮助.
环境介绍
环境为两个节点RAC:racnode1和racnode2
测试过程是删除racnode1
Oracle版本为11.2.0.1
---- racnode1上操作 -----
首先,要禁用和停止监听,然后查询确认操作已经成功
- [grid@racnode1 ~]$ srvctl disable listener -n racnode1
- [grid@racnode1 ~]$ srvctl stop listener -n racnode1
- [grid@racnode1 ~]$ crsctl status res -t
- ora.LISTENER.lsnr
- OFFLINE OFFLINE racnode1
- ONLINE ONLINE racnode2
- ora.LISTENER_2.lsnr
- OFFLINE OFFLINE racnode1
- ONLINE ONLINE racnode2
- --------------------------------------------------------------------------------
进入到GI目录,去删除OCR中的该数据库的信息(这个操作可以在任何一个运行的节点上执行)
- [grid@racnode1 ~]$ cd $ORACLE_HOME/oui/bin
- [grid@racnode1 bin]$ pwd
- /u01/app/11.2.0/grid/oui/bin
- [grid@racnode1 bin]$ ./runInstaller -updateNodelist ORACLE_HOME=/u01/app/11.2.0/grid/oui/bin "CLUSTER_NODES=racnode2" <<<<<注:这里需要填写希望保留下来的节点,如果有多个节点,除了需要删除的节点,其他节点都要写上并用“,”隔开
- Starting Oracle Universal Installer...
- Checking swap space: must be greater than 500 MB. Actual 2353 MB Passed
- The inventory pointer is located at /etc/oraInst.loc
- The inventory is located at /u01/app/oraInventory
- /u01/app/oraInventory/ContentsXML
- [grid@racnode1 bin]$ olsnodes -s -t
- racnode1 Active Unpinned
- racnode2 Active Unpinned
停止并删除VIP
-
[root@racnode1 bin]# srvctl stop vip -i racnode1-vip
-
[root@racnode1 bin]# crsctl status res -t
-
--------------------------------------------------------------------------------
-
ora.LISTENER.lsnr
-
OFFLINE OFFLINE racnode1
-
ONLINE ONLINE racnode2
-
ora.LISTENER_2.lsnr
-
OFFLINE OFFLINE racnode1
-
ONLINE ONLINE racnode2
-
ora.racnode1.vip
-
1 OFFLINE OFFLINE
-
ora.racnode2.vip
-
1 ONLINE ONLINE racnode2
-
ora.scan1.vip
-
1 ONLINE ONLINE racnode1
-
[root@racnode1 bin]# srvctl remove vip -i racnode1-vip
-
Please confirm that you intend to remove the VIPs racnode1-vip (y/[n]) y
-
[root@racnode1 bin]# crsctl status res -t
-
--------------------------------------------------------------------------------
-
ora.LISTENER.lsnr
-
OFFLINE OFFLINE racnode1
-
ONLINE ONLINE racnode2
-
ora.LISTENER_2.lsnr
-
OFFLINE OFFLINE racnode1
-
ONLINE ONLINE racnode2
-
ora.LISTENER_SCAN1.lsnr
-
1 ONLINE ONLINE racnode1
-
ora.hd.db
-
1 ONLINE ONLINE racnode1 Open
-
2 ONLINE ONLINE racnode2 Open
-
ora.oc4j
-
1 OFFLINE OFFLINE
-
ora.racnode2.vip
-
1 ONLINE ONLINE racnode2
-
ora.scan1.vip
-
1 ONLINE ONLINE racnode1