1 Node 2 use DBCA to delete a node 2 node 1alter database disable thread 2; 3 Node 1 Verify that a node database has been deleted [03:49:06 Oracle (DB) @rac1 ~]$ srvctl Config database-d proddatabase Unique name:proddatabase name:prodoracle home:/u01/app/oracle/product/11.2.0/dboracle user:o Raclespfile: +data/prod/spfileprod.oradomain:start options:openstop options:immediatedatabase role: Primarymanagement policy:automaticserver pools:proddatabase instances:prod1disk groups:datamount point paths: Services:Type:RACDatabase is administrator managed4 node 1 stop monitoring of Node 2 srvctl disable listener-l listener-n rac2;srvctl stop Li Stener-l listener-n rac2;5 Node 2 Update node information/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}"-local6 Node 2 removes the Oracle Software for node 2/u01/app/oracle/product/ 11.2.0/DB/DEINSTALL/DEINSTALL-LOCAL7 Node 1 updates the remaining node information/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}" removal of ORACLE software has been completedBelow to remove grid Software 8 Node 1 View ONS resource situation olsnodes-s-TRAC1 active UNPINNEDRAC2 active UNPINNED9 Node 2 execute rootcrs.pl script as root user clear grid configuration information/ U01/APP/11.2.0/GRID/CRS/INSTALL/ROOTCRS.PL-DECONFIG-DEINSTALL-FORCE10 Node 1 Reconfirm the resource situation of the ONS olsnodes-s-trac1 Active UNPINNEDRAC2 Inactive Unpinned11 node 1root user performs removal of information from another node crsctl delete node-n rac2olsnodes-s-trac1 Active Unpinned12 node 2o Racle user executes/u01/app/11.2.0/grid/oui/bin/runinstaller-updatenodelist Oracle_home=/u01/app/11.2.0/grid/"CLUSTER_ Nodes=rac2 "Crs=true-silent-local13 node 2 uninstall grid software Oracle user execution/u01/app/11.2.0/grid/deinstall/deinstall-localroot The user executes the RM-RF/ETC/ORAINST.LOCRM-RF/OPT/ORCLFMAPRM-RF/ETC/ORATAB14 Node 1 update information for the remaining nodes Oracle User execution:/u01/app/11.2.0/grid/oui/ Bin/runinstaller-updatenodelist Oracle_home=/u01/app/11.2.0/grid/"Cluster_nodes=rac1" crs=true-silent15 Node 1 checks whether [04:24:28 Oracle (DB) @rac1 ~]$ cluvfy stage-post nodedel-n rac2-verboseperforming post-checks for node Remova has been removed Lchecking CRS Integrity ... Clusterware version consistency passedthe Oracle ClusterwaRe is healthy on node ' Rac1 ' CRS integrity check passedresult:node removal check passedpost-check for node removal was SUCC Essful. You can see that the node was deleted successfully
How Oracle RAC correctly deletes the actionlist of a single node