Thứ Bảy, 3 tháng 8, 2013

Delete a node from Oracle DB 11g2 RAC

I tested this Case successfully. Following these steps:

.
---------------
Oracle Software:
_______________

node2 run dbca -> cluster database -> instance management -> delete instance node3
node3 cd $ORACLE_HOME/oui/bin
./runInstaller -updateNodeList    ORACLE_HOME=/export/home/oracle/app/oracle/product/11.2.0/dbhome_1 "CLUSTER_NODES={node3}" -local
node3 cd $ORACLE_HOME/deinstall
./deinstall -local
node2 cd $ORACLE_HOME/oui/bin
./runInstaller -updateNodeList ORACLE_HOME=/export/home/oracle/app/oracle/product/11.2.0/dbhome_1 "CLUSTER_NODES={node2}"

---------------------
Oracle Grid Software:
____________________

node3 su - root
cd $GRID_HOME/bin
./crsctl unpin css -n node3
cd $GRID_HOME/crs/install
./rootcrs.pl -deconfig -force

node2 su - root
cd $GRID_HOME/bin
./crsctl delete node -n node3

node3 su - oracle (grid user if exist)
cd $GRID_HOME/oui/bin
./runInstaller -updateNodeList ORACLE_HOME=/export/home/oracle/grid "CLUSTER_NODES={node3}" CRS=TRUE -local
cd $GRID_HOME/deinstall
./deinstall -local

answer question
run commands from /tmp
enter to complete
node2 su - grid
cd $GRID_HOME/oui/bin
./runInstaller -updateNodeList ORACLE_HOME=/export/home/oracle/grid "CLUSTER_NODES={node2}" CRS=TRUE

Check Node3 was removal
#olsnodes -n -t
#cluvfy stage -post nodedel -n node3






Không có nhận xét nào: