Oracle Database Tips by Donald Burleson

Oracle10g Grid Computing with RAC
Chapter 15 - RAC Migration Topics

Adding Nodes at the Oracle Clusterware Layer in UNIX/Linux and Windows

<CRS home>\bin\crssetup.exe
-nn <noden>,<noden-number>,<noden+1>,<noden+1-number>,...<noden+i>,<noden+i-number>
-pn <pnn>,<noden-number>,<pnn+1>,<noden+1-number>,...<pnoden+i>,<noden+i-number>

3. The values entered are the private network names or IP addresses that you entered in Step 3 of the above procedure in the Specify Cluster Nodes for Node Addition screen. For example:

crssetup.exe -nn node4,4,node5,5 -pn node4_pvt,4,node5_pvt,5

4. On Windows, UNIX and Linux platforms, execute the racgons utility from the bin subdirectory of the CRS home to configure the Oracle Notification Services (ONS) port number as follows:

racgons <noden>:4948 <noden+1>:4948 ... <noden+i>:4948

Once the nodes have been added at the Oracle clusterware layer, the CRS home has been successfully extended from your existing CRS home to the new nodes.

Transferring ORACLE_HOME to Other Nodes

To add nodes to the Oracle RAC database later, you will need to transfer the existing ORACLE_HOME. To do this, run the OUI in add node mode to configure your new nodes. If you have multiple Oracle homes, and want to add them to the other nodes, then perform the following steps for each Oracle home that you want to transfer to the new nodes:

1. On the existing main node, from the $ORACLE_HOME/OUI/bin directory on UNIX-based systems, %ORACLE_HOME%\OUI\bin on Windows run either the addNode.sh or addnode.bat script. This starts OUI in the add node mode which displays the OUI Welcome screen.
    

2. Using the mouse click the Next button on the Welcome screen and the OUI displays the Specify Cluster Nodes for Node Addition screen.
    

3. From the Specify Cluster Nodes for Node Addition screen use the top table showing the existing nodes associated with the Oracle home from which you launched the OUI to determine existing nodes. At the bottom of the page there is a node selection table showing the nodes that are available for addition. Using the mouse, select the nodes that you want to add and then click on the Next button.
    

4. The OUI now verifies proper connectivity and then performs availability checks on both the existing nodes and on the nodes that you want to add. The following list are examples of what items are verified:

Get the complete Oracle10g story:

The above text is an excerpt from "Oracle 10g Grid & Real Application Clusters", by Rampant TechPress.  Written by top Oracle experts, Mike Ault and Madhu Tumma, this book has a complete online code depot with ready to use scripts. 

To get the code instantly, click here:

http://www.rampant-books.com/book_2004_1_10g_grid.htm