Tuesday, April 14, 2015

Deleting a Node from 3 Node RAC

Note :-- command are marked as orange

Enviornment

1)      RHEL 5.8

2)      Database/Cluster Version 11.2.0.3

3)      GRID_HOME and ORACLE_HOME not shared across node

Steps

1)      login to node 1  rac1 and run the below command

2)      olsnodes –s –t

[oracle@rac1 ~]$ /u02/app/11.2.0.3/grid/bin/olsnodes -s -t

rac1    Active  Unpinned

rac2    Active  Unpinned

rac3    Active  Unpinned

 

If the node is pinned, then run the crsctl unpin css command. Otherwise, proceed to the next step.

3)      Login to the node which needs to be deleted stop emagent

4)      /u01/app/oracle/product/11.2.0.3/db_1/bin/emctl stop dbconsole

5)      login to node 3 which needs to be deleted . Run below command for stopping the cluster running on node3

login as root user
# /u02/app/11.2.0.3/grid/crs/install/rootcrs.pl –deconfig –force

6)      login to node 1 and run the following command as root user

# /u02/app/11.2.0.3/grid/bin/crsctl delete node –n rac3

7)      login to node 3 as grid user say oracle run the below command

$/u02/app/11.2.0.3/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=Grid_home "CLUSTER_NODES={rac3}" CRS=TRUE -silent –local

8)      login to node 3run the command  as grid user say “oracle”
$/u02/app/11.2.0.3/grid/deinstall/deinstall –local

9)      login to node 1 and run the below command as grid user say “oracle”

$/u02/app/11.2.0.3/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=Grid_home "CLUSTER_NODES={rac1,rac2}" CRS=TRUE –silent

10)   Run the command from node 1 as grid user say “oracle”

$ /u02/app/11.2.0.3/grid//bin/cluvfy stage -post nodedel -n rac3

Reference Link :-- http://docs.oracle.com/cd/E11882_01/rac.112/e41959/adddelclusterware.htm#CWADD90995

No comments:

Post a Comment

  Diagnosing a long parsing issue in Oracle Database Slide 1: Topic: Diagnosing a Long Parsing Issue in Oracle Database Slide 2: Parsing is ...