Oracle Database Tips by Donald Burleson

Oracle10g Grid Computing with RAC
Chapter 15 - RAC Migration Topics

Adding Instances to Nodes

1. From any of the newly added and configured nodes, the additional nodes listener processes are configured using the netca utility. Choose the same port number and protocol that you used on the existing nodes. If the netca displays the existing node in the node list page, then do not select this node because the listener is already configured on it.
    

2. Once the listeners are up, convert the database to RAC starting up the instances on the other nodes using one of the following procedures:

• Automated Conversion Procedure

• Manual Conversion Procedure

Automated Conversion Procedure

If a duplicate of the single instance database was created as described in the section "Duplication of the Original Single-Instance Database", then the DBCA is used to complete the conversion to a multi-instance RAC database.

1. Start by executing the DBCA utility from the primary or initial node. On the node selection screen, select the names of the nodes that you want to include as part of your cluster database. On the Template Selection screen, select the preconfigured template (single-instance duplicate) that was created earlier. Enter the database name for the RAC database and respond to the remaining DBCA prompts.
    

2. Enter the name of the raw device for the SPFILE on the Initialization Parameters screen, to use raw devices for the cluster database files. On the Storage page, if you haven't specified a RAW file mapping file, replace the default database file names with the raw devices for the control files, redo logs, and datafiles to create the cluster database. Click the Finish button and create the database.
    

3. Once DBCA completes the conversion to the RAC database the Password Management screen is displayed, it is a requirement that the passwords for database users who have SYSDBA and SYSOPER roles be changed. Once the conversion process is complete DBCA will exit.

Manual Conversion Procedure

If DBCA wasn't used to create a duplicate image of the single-instance database, the following steps are performed complete the manual conversion to RAC:

1. For each new node, create an Optimal Flexible Architecture (OFA) directory structure to support the Oracle system. This structure should be the same on all of the nodes.
    

2. If there is a need to convert the single-instance database files from a regular "cooked" file system to raw devices, then on UNIX/Linux, copy the database datafiles, control files, redo logs, and server parameter file into corresponding raw devices using the dd command or use the OCOPY command on Windows-based systems. If no conversion is required, continue on to the next step.

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