Oracle Database Tips by Donald Burleson

Oracle10g Grid Computing with RAC
Chapter 15 - RAC Migration Topics

Install the Oracle Database 10g RAC Software

5. If raw storage is to be utilized, then on the DBCA File Locations Tab on the Initialization Parameters page, if you have not setup the DBCA_RAW_CONFIG environment variable,  replace the data files, control files, and log files, and so on, with the corresponding raw device files. Replace default database files with raw devices on the Storage page as well.
    

6. Once the RAC database is created, the DBCA utility displays the Password Management page. Use this page to change the passwords for privileged database users who have the SYSDBA and SYSOPER roles. Once the DBCA finishes, the conversion process is complete.

This method works because the template creation makes a compressed copy of the database datafiles. Do not allow any transactions on the source database or the RAC instances will not be in sync.

Creating a Single Instance on a Cluster to Oracle Database 10g RAC

There are three possible scenarios where a single-instance database can exist on a cluster machine, they are:

• The Oracle home where the database is running is cluster installed.

• The Oracle home where the database is running is cluster installed but the RAC feature is disabled.

• The Oracle home where the database is running is not cluster installed.

In the above situation, use the following sections to convert your single-instance database on a clustered machine into a RAC instance for all three of these scenarios.

The Instance Is on a Cluster and Running from a Cluster Enabled Oracle Home

Use the next procedure for conversion of a single-instance database on a cluster running from a cluster installed (Oracle Database 10g with RAC) Oracle home into a RAC enabled instance.

1. Use the DBCA to create a preconfigured image of your single-instance database as was previously documented, then shut down the single-instance database.
    

2. To add other nodes to your cluster, add and connect these nodes to the cluster as described earlier. Verify that all of the nodes added to the cluster can access the shared storage.
    

3. To verify that your installation is configured correctly, perform the following steps:

a. Verify that the new cluster nodes can access the private interconnect. The interconnects must be properly configured before you can complete these procedures.

b. When a cluster file system is not used, determine the location where the cluster software was installed on the existing nodes. Verify that there is at least 250MB of free space on the same location on each of the new nodes in which to install the Cluster Ready Services software. In addition, make sure there is enough free space on each new node to install the Oracle binaries (about 2 gigabytes).

c. Ensure that user equivalence is established on the new nodes by executing the following platform-specific commands:

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