1 節點2 使用dbca刪除1個節點 2 節點1 alter database disable thread 2; 3 節點1 驗證是不是已刪除1個節點數據庫 [03:49:06 oracle(db)@rac1 ~]$ srvctl config database -d prod Database unique name: prod Database name: prod Oracle home: /u01/app/oracle/product/11.2.0/db Oracle user: oracle Spfile: +DATA/prod/spfileprod.ora Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: prod Database instances: prod1 Disk Groups: DATA Mount point paths: Services: Type: RAC Database is administrator managed 4 節點1 停止節點2的監聽 srvctl disable listener -l LISTENER -n rac2; srvctl stop listener -l LISTENER -n rac2; 5 節點2 更新節點信息 /u01/app/oracle/product/11.2.0/db/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/u01/app/oracle/product/11.2.0/db "CLUSTER_NODES={rac2}" -local 6 節點2 刪除節點2的ORACLE軟件 /u01/app/oracle/product/11.2.0/db/deinstall/deinstall -local 7 節點1 更新剩余節點的信息 /u01/app/oracle/product/11.2.0/db/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/u01/app/oracle/product/11.2.0/db "CLUSTER_NODES={rac1}" 刪除oracle軟件已完成 下面來刪除grid軟件 8 節點1 查看ons的資源情況 olsnodes -s -t rac1 Active Unpinned rac2 Active Unpinned 9 節點2 以root用戶履行rootcrs.pl 腳本清楚grid的配置信息 /u01/app/11.2.0/grid/crs/install/rootcrs.pl -deconfig -deinstall -force 10 節點1 再次確認ons的資源情況 olsnodes -s -t rac1 Active Unpinned rac2 Inactive Unpinned 11 節點1 root用戶履行 刪除另外1個節點的信息 crsctl delete node -n rac2 olsnodes -s -t rac1 Active Unpinned 12 節點2 oracle用戶履行 /u01/app/11.2.0/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/u01/app/11.2.0/grid/ "CLUSTER_NODES=rac2" CRS=TRUE -silent -local 13 節點2 卸載grid軟件 oracle用戶履行 /u01/app/11.2.0/grid/deinstall/deinstall -local root 用戶下履行 rm -rf /etc/oraInst.loc rm -rf /opt/ORCLfmap rm -rf /etc/oratab 14 節點1 更新剩余節點的信息 oracle用戶履行： /u01/app/11.2.0/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/u01/app/11.2.0/grid/ "CLUSTER_NODES=rac1" CRS=TRUE -silent 15 節點1 檢查是不是已刪除 [04:24:28 oracle(db)@rac1 ~]$ cluvfy stage -post nodedel -n rac2 -verbose Performing post-checks for node removal Checking CRS integrity... Clusterware version consistency passed The Oracle Clusterware is healthy on node "rac1" CRS integrity check passed Result: Node removal check passed Post-check for node removal was successful. 可以看到節點刪除成功