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

Manual Conversion Procedure

  1. Use the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command to create a control file recreation script in the location specified by the USER_DUMP_DEST initialization parameter.

  2. Edit the control file recreation script with the REUSE keyword, a specification for MAXINSTANCES (the Oracle suggested setting is 32), MAXLOGFILES and such for a RAC database.

  3. Next, re-create the control files by executing the script as explained in the script header.

  4. If the single-instance database is using an SPFILE parameter file, then a temporary PFILE must be created from the SPFILE using the following SQL statement:

CREATE PFILE='pfile_name' from spfile='spfile_name'

(the file names should be full path names)

  1. Now shut down the database instance.

  2. Edit the temporary parameter file and set the CLUSTER_DATABASE parameter to TRUE, and set the INSTANCE_NUMBER parameter to a unique value for each instance, using the sid.parameter=value syntax.

  3. At this point, the size of the SGA must be adjusted to avoid swapping and paging when you convert to RAC. RAC requires around 350 bytes for each buffer to accommodate the Global Cache Service (GCS). Therefore, if you have 15,250 buffers, RAC requires about 350*15,250 bytes (about 5 meg) more memory. Change the size of the SGA by changing the DB_CACHE_SIZE and DB_nK_CACHE_SIZE parameters accordingly.

  4. Once the pfile has been edited use it to start up the database instance.

  5. Once the instance is started, create an undo tablespace for each additional instance using the CREATE UNDO TABLESPACE SQL statement. If you are using raw devices, then ensure that the datafile for the undo tablespace is on a raw device.

  6. Next, create a new redo thread that has at least two redo logs for each additional instance. If raw devices are being used, then ensure that the new redo log files are also on raw devices. Enable the new redo threads by using the ALTER DATABASE SQL statement.

  7. Shutdown the database instance using either a shutdown normal or shutdown immediate command.

  8. Copy the Oracle password file from the source node to the corresponding location on the additional RAC cluster nodes. Make sure that you replace the ORACLE_SID name in each password file name appropriately for each additional instance.

  9. Edit the pfile and add the REMOTE_LISTENER=LISTENERS_DB_NAME and sid.LOCAL_LISTENER=LISTENER_SID parameters.

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.