Oracle Database Tips by Donald Burleson

Oracle10g Grid Computing with RAC
Chapter 15 - RAC Migration Topics

Transferring ORACLE_HOME to Other Nodes

11. While on Windows-based systems, the Cluster Node Addition Progress will show the following three OUI phases:

1. Copying of the Oracle Home To New Nodes - Copies the entire Oracle home to the new nodes unless the Oracle home is already on a cluster file system

2. Perform the Oracle Home Setup - Update of the Registry entries for the new nodes, creation of the needed services, and creation of the needed folder entries

3. Saving Cluster Inventory - The update of the node list associated with the Oracle home and its inventory
    

12. For all of the platforms, the Cluster Node Addition Progress screen's Status column displays one of three status messages:

1. Succeeded when the phase completes

2. In Progress when the phase is active

3. Suspended when the phase is awaiting execution

13. When the OUI displays the End of Node Addition screen, click on the Exit button to end the OUI session.

14. For UNIX/Linux-based systems only, the root.sh script will be run next.
     
15. Next the vipca utility must be run from the bin subdirectory of the Oracle home using the -nodelist option identifying the complete set of nodes that are now part of your RAC database beginning with Node1 and ending with <NodeN> using the following syntax

    vipca -nodelist Node1,Node2,Node3,...<NodeN>

16. When the private interconnect interface names on the new nodes are not the same as the interconnect names on the existing nodes, then the private interconnect must be configured for the new nodes. This is done by executing the oifcfg utility with the setif option. The oifcfg executable is run from the bin directory of the host's Oracle home. The command is executed using the following syntax where <subnet> is using the subnet for the private interconnect for the RAC databases to which nodes are added:
    
    oifcfg setif <interface-name>/<subnet>:<cluster_interconnect|public>

17. For example:

oifcfg setif eth0/162.178.26.0:cluster_interconnect 

18. Once the procedures in the previous section are complete, the new nodes are defined at the cluster database layer. The new database instances can now be added to the new nodes as described next.

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