Oracle Database Tips by Donald Burleson

Oracle10g Grid Computing with RAC
Chapter 15 - RAC Migration Topics

Conversion of a Single Instance on a Cluster Running from a RAC-Disabled Oracle Home

3. Relink the oracle binary by executing the following commands:

make -f ins_rdbms.mk rac_on
make -f ins_rdbms.mk ioracle

4. Now use the normal conversion procedure for a RAC enabled Oracle home.

Conversion of a Single Instance on a Cluster Running from non-Cluster Installed Oracle Home

This situation is only possible if the local installation option was specified on the OUI Specify Hardware Cluster Installation screen during an Oracle Database 10g installation.

To covert this type database to a RAC database, perform the procedures described under these previous sections:

1. "Duplicate the Original Single-Instance Database ".
    

2. "Perform the Pre-Installation Steps".
    

3. "Setting up the Cluster ".
    

4. "Install Oracle Database 10g Software with RAC". In this step, make sure that a new Oracle home other than the one from which the single-instance database was running is selected.

Required Post-Conversion Steps

After completing the conversion, review the following items as covered in other chapters of this book:

• Use load balancing and TAF
   

• Use locally managed tablespaces instead of dictionary managed tablespaces to reduce contention and manage sequences
   

• Follow the guidelines for configuring an interconnect, for using automatic segment space management and for using SRVCTL to administer multiple instances
   

• Database buffer cache and shared pool capacity requirements in RAC are greater than those in single-instance Oracle databases. Therefore, increase the size of the buffer cache by at least 10% and the size of the shared pool by at least 15%.
   

• If ASM is used for your file systems, use RMAN for backup.

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