Oracle Database Tips by Donald Burleson

Oracle10g Grid Computing with RAC
Chapter 15 - RAC Migration Topics

Transferring ORACLE_HOME to Other Nodes

1. The nodes are active

2. The nodes are network enabled

3. The installing user has the proper permissions to create the Oracle home on the new nodes

4. The installing user has write permission to the OUI inventory in the oraInventory directory on UNIX or the Inventory directory on Windows on the existing nodes and on the new nodes

5. When the new nodes do not have an inventory set up, then, depending on the system, one of the following will occur:

1. For UNIX-based systems the OUI displays a dialog asking that the oraInstRoot.sh script be run on the new nodes.

2. For Windows-based systems the Registry is automatically updated with the inventory location by the OUI

6. If any of the other checks fail, then deselect the node that has the error or fix the error and proceed. You cannot deselect nodes that are already a part of the cluster; the problems on the existing nodes must be corrected before proceeding with node addition. Once all of the checks are successful then the OUI displays the Node Addition Summary screen.
    

7. The following information about the products that are installed in the Oracle home that you are going to extend to the new nodes is listed on the Node Addition Summary screen:

1. The Oracle home that is the source for the add node process

2. The existing node and new node information

3. The new nodes that have been selected

4. For new nodes, the required and available space

5. The listing of all the products that are already installed in the existing Oracle home

8. Click the Finish button and the OUI will display the Cluster Node Addition Progress screen.
    

9. Next, the status of the cluster node addition process is shown on the Cluster Node Addition Progress screen. The table on this page shows two columns profiling the addition phases:

1. The node addition phase progress

2. The phase's status according to the following platform-specific content

10. On UNIX-based systems, the Cluster Node Addition Progress page shows the following four OUI phases:

1. Instantiation of the Root Scripts - This phase instantiates the root.sh script in the new Oracle home by copying it from the local node

2. Copying of the Oracle Home to the New Nodes - This phase copies the rest of the entire Oracle home from the source node to the new nodes, unless the Oracle home is on a cluster file system

3. Running of the root.sh - Displays the dialog about running the root.sh script from the root user on the new nodes

4. Saving of the Cluster Inventory - Update of the node list associated with the Oracle home and its inventory

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