Adding Node to 2 Node RAC

 

 

Environment

n  RHEL 5.8

n  11.2.0.3 database version

Follow Below Steps

n  export ORACLE_HOME=/u01/app/11.2.0/grid

n  cd $ORACLE_HOME/bin

n  ./cluvfy stage -pre crsinst -n rac1,rac2,rac3 –verbose

n  cd ../oui/bin

n  pwd

n  /u01/app/11.2.0/grid/oui/bin

n  ./addNode.sh -silent "CLUSTER_NEW_NODES={rac3}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={rac3-vip}"

n  In case of warning

-----------------------------------------------------------------------------
Instantiating scripts for add node (Wednesday, April 8, 2015 7:17:58 PM MDT)

.                                                                 1% Done.

Instantiation of add node scripts complete

 

Copying to remote nodes (Wednesday, April 8, 2015 7:18:03 PM MDT)

...............................................................................................                                 96% Done.

Home copied to new nodes

 

Saving inventory on nodes (Wednesday, April 8, 2015 7:22:06 PM MDT)

SEVERE:Remote 'UpdateNodeList' failed on nodes: 'rac2'. Refer to '/u01/app/oraInventory1/logs/addNodeActions2015-04-08_07-17-45PM.log' for details.

You can manually re-run the following command on the failed nodes after the installation:

 /u01/app/11.2.0/grid/oui/bin/runInstaller -updateNodeList -noClusterEnabled ORACLE_HOME=/u01/app/11.2.0/grid CLUSTER_NODES=rac1,rac2,rac3,rac4 CRS=true  "INVENTORY_LOCATION=/u01/app/oraInventory1" -invPtrLoc "/u01/app/11.2.0/grid/oraIns

t.loc" LOCAL_NODE=<node on which command is to be run>.

Please refer 'UpdateNodeList' logs under central inventory of remote nodes where failure occurred for more details.

.                                                               100% Done.

Save inventory complete

WARNING:A new inventory has been created on one or more nodes in this session. However, it has not yet been registered as the central inventory of this system.

To register the new inventory please run the script at '/u01/app/oraInventory1/orainstRoot.sh' with root privileges on nodes 'rac4'.

If you do not register the inventory, you may not be able to update or patch the products you installed.

The following configuration scripts need to be executed as the "root" user in each cluster node.

/u01/app/oraInventory1/orainstRoot.sh #On nodes rac4

/u01/app/11.2.0/grid/root.sh #On nodes rac4

To execute the configuration scripts:

    1. Open a terminal window

    2. Log in as "root"

    3. Run the scripts in each cluster node

 

The Cluster Node Addition of /u01/app/11.2.0/grid was successful.

Please check '/tmp/silentInstall.log' for more details.

[oracle@rac1 bin]$

n  /u01/app/oraInventory1/orainstRoot.sh

The above step completes 1^st part of Adding a Node . The above copies grid binaries to other node

                Part II

               Transfering Oracle binaries to Other Node

n  cd /u01/app/oracle/product/11.2.0/dbhome_1/oui/bin

n  ./addNode.sh -silent "CLUSTER_NEW_NODES={rac3}"

n  Run DBCA to add instance from RAC1

n  ./dbca

n  “Oracle Real Application Clusters Database” and then “select Instance Management” and then select “add instance”