Oracle Faq

Hi,

Consider the following Environment

Environment :

Nodenames : node1.us.oracle.com node1
node2.us.oracle.com node2
node3.us.oracle.com node3

Node to be removed : node3.us.oracle.com node3.

Database name : racdb

Instance names : racdb1, racdb2, racdb3

Step 1 : Delete instance from node3

1. Do this on node1

Login as the oracle user
Set the ORACLE_HOME and PATH env variables to point to the database home
Run “dbca

Choose RAC database
Choose Instance Management
Choose Delete Instance

It shows a screen with the database name. At the bottom of the screen, enter the sys user and password.
Choose the instance to delete ( racdb3 on node3 )
Confirm deletion.

2. If your database is running on ASM, then follow the next steps to clean-up ASM on node3.
Do this on node1
Srvctl stop asm –n node3
Srvctl remove asm –n node3

Do this on node3
Cd $ORACLE_HOME/admin
Rm –rf +ASM
Cd $ORACLE_HOME/dbs
Rm –f * ASM *
Remove oratab entries beginning with +ASM.
3. Remove the listener running on node3

Do this on node3
Login as the oracle user and set the ORACLE_HOME to database home
Netca
Choose Cluster management
Choose Listener
Choose Remove
Confirm deletion of LISTENER

4. Removing node3 from the database and deleting ORACLE_HOME

Do this on node3
Export ORACLE_HOME=
Cd $ORACLE_HOME/oui/bin
./runInstaller –updateNodeList ORACLE_HOME=$ORACLE_HOME “CLUSTER_NODES={node3}” –local
./runInstaller

Choose De-install products and select the dbhome
This will remove the database home software and leaves behind only some files and directories

Do this on node1
Cd $ORACLE_HOME/oui/bin
./runInstaller –updateNodeList ORACLE_HOME=$ORACLE_HOME “CLUSTER_NODES={node1,node2}”

5. Removing node3 from the cluster and deleting Oracle Clusterware software from node3

Do this on node1
$CRS_HOME/bin/racgons remove_config node3:6200
( Replace port 6200 in the above command with the number that you see in the remote port section of the ons.config file in the CRS_HOME/opmn/conf diretory )

Do this on node3
Login as the root user
Cd $CRS_HOME/install
Rootdelete.sh

Do this on node1
Login as the root user
$CRS_HOME/bin/olsnodes –n

In the above command’s output check the node number for node3 e.g 3
Cd $CRS_HOME/install
Rootdeletenode.sh node3,3

Do this on node3
Login as the oracle user
Cd $CRS_HOME/oui/bin
./runInstaller –updateNodeList ORACLE_HOME=$CRS_HOME “CLUSTER_NODES={node3}” CRS=TRUE –local
./runInstaller
Choose Deinstall software and remove the CRSHOME.

Do this on node1
Login as the oracle user
Cd $CRS_HOME/oui/bin
./runInstaller –updateNodeList ORACLE_HOME=$CRS_HOME “CLUSTER_NODES={node1,node2}” CRS=TRUE

To verify the removal of the node from the cluster, run these commands

Do this on node1
Srvctl status nodeapps –n node3
Should return a message saying ‘Invalid node”
Crs_stat | grep –I node3
Should not get any output
Olsnodes –n
Should list node1 and node2 only.

Share This