Search This Blog

Monday, April 16, 2012

Single Instance Conversion To RAC Using DBCA.

This tutorial shows how to convert a single instance database to a RAC one by using DBCA.
Below is the configuration of my single instance Database and RAC Nodes.

Single Instance Database.

OS: RHEL4
Oracle Software Version: 10.2.0.4
SID: orascott

RAC NODES 1 and 2

Hostname: vmlinux1,vmlinux2
OS: RHEL4
Oracle Software Version: 10.2.0.4
CRS: Installed
ASM: Configured
ASM Groups: ORCL_DATA1, FLASH_RECOVERY

First step is to create a Database Template of the single instance Database
along with all the Datafiles and structures. <<===Click here for link.

After the Template creation is complete copy all the files starting with "ORSCOTT" from the
"{ORACLE_HOME}/assistants/dbca/templates/" directory to the
directory "{ORACLE_HOME}/assistants/dbca/templates/" of any one RAC node.

After Doing that enable user equivalence as the ORACLE user on the node from which the
database installation is to be done.

After that initiate DBCA.

Select The Template "ORASCOTT" which we had created earlier.
When The Installation is finished the Database will be up on all the RAC Nodes.

0 comments:

Post a Comment