Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 








  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:

Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.