Thursday, September 2, 2010

Install Oracle RAC 11gR2 on Vmware with Windows 7 64-bit as host OS and Linux as guest(Part 10, Delete node manually and re-add it)

Meditate Meditate and Meditate in the HIS name all the time.



Index of all the posts of Gurpartap Singh's Blog

I will delete node rac3.

Step 1 Remove Oracle RAC.

A. To remove oracle RAC software from the server first you need to disable and remove the listner from the server.

Execute the following from any node in the cluster.

$ srvctl disable listener -l LISTENER -n rac3
$ srvctl stop listener -l LISTENER -n rac3

B.

Run the following command on the node that you are deleting to update the inventory on that node:

./runInstaller –updateNodeList ORACLE_HOME=Oracle_home_location "CLUSTER_NODES={name_of_node_to_delete}" -local

i.e.
. oraenv
simar3

cd $ORACLE_HOME/oui/bin

./runInstaller –updateNodeList ORACLE_HOME=/u01/app/oracle/product/11.2.0.1/dbhome_1 "CLUSTER_NODES={rac3}" -local


Caution - Don't forget to supply local here.


C.
Following steps are for 11gR2, for older versions use OUI in $ORACLE_HOME/oui/bin with GUI.

Now deinstall the oracle home on the node that you are deleting as:

. oraenv
simar3
cd $ORACLE_HOME/deinstall

./deinstall -local

Caution - Don't forget to supply local here.

D.

Now run the following command from any server that you are not deleting from RDBMS home to update the orainvantory of the existing
nodes in the cluster.

./runInstaller –updateNodeList ORACLE_HOME=Oracle_home_location "CLUSTER_NODES={remaining_node_list}"

I will run it from node 1 i.e rac1:

. oraenv
simar1

cd $ORACLE_HOME/oui/bin

./runInstaller –updateNodeList ORACLE_HOME=/u01/app/oracle/product/11.2.0.1/dbhome_1 "CLUSTER_NODES={rac1,rac2}"



After this we are done with removing the RDBMS software from the node we are deleting i.e. rac3. and now we will
move to the next step to removing crs and node from the grind infrastructure cluster.


A.
Issue "olsnodes -s -t" to see if the node rac3 is pinned.
If the node rac3 is pinned, then you need to unpin the node before deleting the node.

To unpin the node, issue following command after setting oracle home and path to crs.

. oraenv
crs

crsctl unpin css -n rac3

B.
As root on the node that you are deleting from the grid, rac3

. oraenv
crs
cd $ORACLE_HOME/crs/install
./rootcrs.pl -deconfig -force

C.
2) As root from any node that you are not deleting, for example, rac1
Note: is rac1

# in rac1

. oraenv
crs
cd $ORACLE_HOME/bin
./crsctl delete node -n rac3


D.
On the node you want to delete i.e. rac3, run the following command where is the name of the node that you are deleting:
is rac3

# in rac3

. oraenv
crs
cd $ORACLE_HOME/oui/bin
./runInstaller -updateNodeList ORACLE_HOME=/u02/app/11.2.0.1/grid "CLUSTER_NODES={rac3}" CRS=TRUE -local

Note: Do not remove the "{" and "}" in above command.
This is very important step.
If you do not execute this step then deinstall utility will deinstall Grid homes from all the nodes.
So to avoid this we are removing all the other nodes from the inventory of rac3.


E.
As grid user on the node that you are deleting i.e. rac3 execute the following to remove the Grid home.

# in rac3
. oraenv
crs
cd $ORACLE_HOME/deinstall
./deinstall –local

***Caution***:
If you do not specify the -local flag, then the command removes the grid infrastructure homes from every node in the cluster.


F.
Execute following on the node_to_be_deleted i.e. rac3 as root.

rm -rf /etc/oraInst.loc'


G.
On any node other than the node you are not deleting i.e. rac1, as grid user to update the inventory of the remaining nodes in the grid infrastructure.

# in rac1
. oraenv
crs
cd $ORACLE_HOME/oui/bin
./runInstaller -updateNodeList ORACLE_HOME=/u02/app/11.2.0.1/grid "CLUSTER_NODES={rac1,rac2}" CRS=TRUE

Do not remove the "{" and "}" in above command.


H.
verify from any node that you are not deleting i.e. rac1

# in rac1
. oraenv
crs
cd $ORACLE_HOME/bin
./cluvfy stage -post nodedel -n rac3 -verbose



To re-add the node follow link:
http://gurpartapblog.blogspot.com/2010/07/install-oracle-rac-11gr2-on-vmware-with_1628.html


Remember - One day everybody has to leave this human body, but the soul will remain. To know and experience that while you are in this human body, Meditate Meditate Mediate in the name of true Lord, as only that will go with us.

No comments:

Post a Comment