Welcome 微信登录

首页 / 数据库 / MySQL / Oracle RAC 添加删除节点

百度搜索,会很多文章关于如何添加删除节点的,而且这个操作也没有什么很多的技术含量,但是自己测试过,记录一下,以备后续查询,同时也希望能给需要的朋友一些帮助.环境介绍环境为两个节点RAC:racnode1和racnode2测试过程是删除racnode1Oracle版本为11.2.0.1---- racnode1上操作 -----首先,要禁用和停止监听,然后查询确认操作已经成功
  1. [grid@racnode1 ~]$ srvctl disable listener -n racnode1
  2. [grid@racnode1 ~]$ srvctl stop listener -n racnode1
  3. [grid@racnode1 ~]$ crsctl status res -t
  4. ora.LISTENER.lsnr
  5. OFFLINE OFFLINE racnode1
  6. ONLINE ONLINE racnode2
  7. ora.LISTENER_2.lsnr
  8. OFFLINE OFFLINE racnode1
  9. ONLINE ONLINE racnode2
  10. --------------------------------------------------------------------------------
进入到GI目录,去删除OCR中的该数据库的信息(这个操作可以在任何一个运行的节点上执行)
  1. [grid@racnode1 ~]$ cd $ORACLE_HOME/oui/bin
  2. [grid@racnode1 bin]$ pwd
  3. /u01/app/11.2.0/grid/oui/bin
  4. [grid@racnode1 bin]$ ./runInstaller -updateNodelist ORACLE_HOME=/u01/app/11.2.0/grid/oui/bin "CLUSTER_NODES=racnode2" <<<<<注:这里需要填写希望保留下来的节点,如果有多个节点,除了需要删除的节点,其他节点都要写上并用“,”隔开
  5. Starting Oracle Universal Installer...
  6. Checking swap space: must be greater than 500 MB. Actual 2353 MB Passed
  7. The inventory pointer is located at /etc/oraInst.loc
  8. The inventory is located at /u01/app/oraInventory
  9. /u01/app/oraInventory/ContentsXML
 
  1. [grid@racnode1 bin]$ olsnodes -s -t
  2. racnode1 Active Unpinned
  3. racnode2 Active Unpinned
停止并删除VIP
  1. [root@racnode1 bin]# srvctl stop vip -i racnode1-vip
  2. [root@racnode1 bin]# crsctl status res -t
  3. --------------------------------------------------------------------------------
  4. ora.LISTENER.lsnr
  5. OFFLINE OFFLINE racnode1
  6. ONLINE ONLINE racnode2
  7. ora.LISTENER_2.lsnr
  8. OFFLINE OFFLINE racnode1
  9. ONLINE ONLINE racnode2
  10. ora.racnode1.vip
  11. 1 OFFLINE OFFLINE
  12. ora.racnode2.vip
  13. 1 ONLINE ONLINE racnode2
  14. ora.scan1.vip
  15. 1 ONLINE ONLINE racnode1
  16. [root@racnode1 bin]# srvctl remove vip -i racnode1-vip
  17. Please confirm that you intend to remove the VIPs racnode1-vip (y/[n]) y
  18. [root@racnode1 bin]# crsctl status res -t
  19. --------------------------------------------------------------------------------
  20. ora.LISTENER.lsnr
  21. OFFLINE OFFLINE racnode1
  22. ONLINE ONLINE racnode2
  23. ora.LISTENER_2.lsnr
  24. OFFLINE OFFLINE racnode1
  25. ONLINE ONLINE racnode2
  26. ora.LISTENER_SCAN1.lsnr
  27. 1 ONLINE ONLINE racnode1
  28. ora.hd.db
  29. 1 ONLINE ONLINE racnode1 Open
  30. 2 ONLINE ONLINE racnode2 Open
  31. ora.oc4j
  32. 1 OFFLINE OFFLINE
  33. ora.racnode2.vip
  34. 1 ONLINE ONLINE racnode2
  35. ora.scan1.vip
  36. 1 ONLINE ONLINE racnode1
  • 1
  • 2
  • 3
  • 下一页
Oracle 11g中lock的增强Rman备份脚本集合相关资讯      节点  Oracle RAC添加节点  Oracle RAC删除节点 
  • 关于心跳网络引起的Oracle RAC的节  (06/04/2015 17:53:20)
  • Oracle 11gR2 RAC节点crash故障分  (06/14/2014 20:48:40)
  • RH436之两个节点集群  (12/08/2013 19:26:17)
  • OpenStack节点地址改变  (09/24/2014 21:27:54)
  • RAC节点1reboot之后,节点1的资源  (12/12/2013 08:49:11)
  • RHCS多节点部署应用企业环境  (05/18/2013 08:12:51)
本文评论 查看全部评论 (0)
表情: 姓名: 字数