Brief of Adding node to Oracle RAC Cluster 11.2

Assume , node as been prepared with pre-requisite like user,group,kernel,ntp,ssh,vip,ip,/etec/hosts etc.

We should now be in a position to add the node, so lets run the cluster verification utility from one of the existing nodes, to make sure everything is correct:

node1_oracle$> /tmp/oracle/grid/runcluvfy.sh stage -pre nodeadd -n racnode3

Make sure this returns a successful message.

We can now add our node into Oracle Clusterware, so from the existing node 1, run:

node1_oracle$> /home/grid/app/11.2.0/grid/oui/bin/addNode.sh “CLUSTER_NEW_NODES={racnode3}” “CLUSTER_NEW_VIRTUAL_HOSTNAMES={racnode3-vip}” -silent

We now need to run the root scripts on node3:

node3#> /home/oracle/app/oraInventory/orainstRoot.sh

node3#> /home/grid/app/11.2.0/grid/root.sh

Make sure the node is added, by using the cluster verification tool on node 1:

node1_oracle$> /tmp/oracle/grid/runcluvfy.sh stage -post nodeadd -n racnode3

This should return as successful.

We now need to extend the Oracle Home to the third node, so from the first node:

node1_oracle$> /home/oracle/app/oracle/product/11.2.0/dbhome_1/oui/bin/addNode.sh -silent “CLUSTER_NEW_NODES={racnode3}”

We now need to run the root scripts on node3:

node3#> /home/oracle/app/oracle/product/11.2.0/dbhome_1/root.sh

We now need to add the instance to the node. So we run dbca on node 1:

oracle_node1$> export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1

oracle_node1$> export PATH=$PATH:$ORACLE_HOME/bin

oracle_node1$> dbca &

Select Oracle RAC database

click on Next

Select Instance Management

click on Next

Select Add an Instance

click on Next

Make sure TESTDB is selected, enter sys for the username and enter the password

click on Next

click on Next

make sure the TESTDB3 is shown along with racnode3

click on Next

click on Finish

click on OK

Now use the cluster verification tool to confirm the addition:

oracle_node1$> export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1

oracle_node1$> /tmp/oracle/grid/runcluvfy.sh comp admprv -o db_config -d $ORACLE_HOME -n racnode1,racnode2,racnode3

You should now have completed the addition of a third node into your cluster.