In sweet memories of my ever loving brother "kutty thambi " ARUN KUMAR

Tuesday, July 27, 2010

Converting Single instance to RAC instance Database Using DBCA

There are different ways to convert a single instance database to RAC.
1) Manual Method
3) Using DBCA
In this post we will see step by step method to convert a single instance database to RAC Using DBCA(Database Configuration Assitant).

In this example, I already configured two node oracle asm, clusterware homes. also i already  converted the file system from non-asm to asm 
For converting filesystem to ASM click the link above.

follow steps for creating a template to convert a single instance to rac instance.

[oracle@rac1 ~]$ dbca &
Screen Name Response
Welcome Screen Select Single Instance database.
Operations Select Manage Templates.
Template management operation Select From an existing database(structure as well as data).
Choose the database Select Database instance: testing
Specify the name and description example: testing and description testing_database_convert_from_single_to_rac_instance_database
specify whether you want to convert
all database
 related file locations to OFA,
or You want to main the file
locations in the template.
Select Maintain the file locations.  and click FINISH.
The following operations
will be performed:
create a clone template from
the source database.
click ok
Do you want to perform
another operation
Click No to EXIT

Templates for existing single instance database has been created.

Go to $ORACLE_HOME/assistants/dbca/templates and check generated backup of single instance.

[oracle@rac1 templates]$ pwd
[oracle@rac1 templates]$ ls -ltr
total 213584
-rw-r-----  1 oracle oinstall    12050 May 16  2005 New_Database.dbt
-rw-r-----  1 oracle oinstall     5728 Jun 30  2005 Data_Warehouse.dbc
-rw-r-----  1 oracle oinstall     5665 Jun 30  2005 Transaction_Processing.dbc
-rw-r-----  1 oracle oinstall     5608 Jun 30  2005 General_Purpose.dbc
-rwxr-xr-x  1 oracle oinstall  7061504 Jul  2  2005 Seed_Database.ctl
-rwxr-xr-x  1 oracle oinstall 93569024 Jul  2  2005 Seed_Database.dfb
-rwxr-xr-x  1 oracle oinstall   991232 Jul  2  2005 example.dmp
-rwxr-xr-x  1 oracle oinstall 13017088 Jul  2  2005 example01.dfb
-rw-r-----  1 oracle oinstall 96714752 Jul 27 13:47 testing.dfb
-rw-r-----  1 oracle oinstall  7061504 Jul 27 13:47 testing.ctl
-rw-r-----  1 oracle oinstall     5349 Jul 27 13:49 testing.dbc

Copy the pre-configured database image from rac1 machine $ORACLE_HOME/assistants/ dbca/ templates/ testing.dbf & testing.dbc    to  host rac2 environment  $ORACLE_HOME/assistants/dbca/templates/ folder

[oracle@rac1 templates]$ scp testing.dfb oracle@rac2:/u01/app/oracle/product/10.2.0/db_1/assistants/dbca/templates/
testing.dfb                                   100%   92MB   2.5MB/s   00:37
[oracle@rac1 templates]$ scp testing.dbc oracle@rac2:/u01/app/oracle/product/10.2.0/db_1/assistants/dbca/templates/
testing.dbc                                   100% 5349     5.2KB/s   00:00
[oracle@rac1 templates]$ scp testing.ctl oracle@rac2:/u01/app/oracle/product/10.2.0/db_1/assistants/dbca/templates/
testing.ctl                                   100% 6896KB   2.2MB/s   00:03
[oracle@rac2 templates]$ pwd
[oracle@rac2 templates]$ ls -ltr
-rw-r-----  1 oracle oinstall 96714752 Jul 27 14:24 testing.dfb
-rw-r-----  1 oracle oinstall     5349 Jul 27 14:26 testing.dbc
-rw-r-----  1 oracle oinstall  7061504 Jul 27 14:26 testing.ctl
Start the dbca to convert the single instance to rac single database.
[oracle@rac2 templates]$ dbca &

Screen Name Response
Welcome to the Database
configuration assitant
Select Oracle Real Application Database
Select the operation select : create a database
Select the nodes on which you
want to create the cluster
Select select all.
Select a template from the
following list to create
the database:
Select the template: testing(template name created by you)
Select the
Global database name
and SID:
  Type name as you want, eg: raj.
Each oracle database may be managed
centrally using the Oracle Enterprise
Manager Grid Control or locally using
the Enterprise Manager Database Control.
Choose the management option that you
would like to use to manage this

   Select:  configure the database with enterprise manager
For security reasons, you must specify
password for the following user
accounts in the new database.
select: Use the same password for ALL accounts password: yourpassword confirm password: yourpassword
Select the Listeners
Select:Register this database with all listeners
Select the storage mechanism
Select: Automatic Storage Management(ASM)
select the disk groups to be used as
storage for the database.

Select the disk group names: eg: DATA
Specify locations for the database
files to be created.

Select:  use Oracle-Managed Files
Choose the recovery options
uncheck all
Custom Scripts
Select: No scripts to run
Oracle Database Services Details
Click: Next
Initialization Parameters
Click: Next
Database storage
Click: Next
creation options
click: Finish

[oracle@rac2 templates]$ vi /etc/oratab
edit the oratab file for instances raj as raj1 and raj2 on both nodes
[oracle@rac2 templates]$ . oraenv
ORACLE_SID = [oracle] ? raj2
[oracle@rac2 templates]$ sqlplus '/as sysdba'

SQL*Plus: Release - Production on Tue Jul 27 19:37:27 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> select instance_name from gv$instance;


hope, this helps you.

related documents: (rconfig method)


Jay said...

Hi Arun,
Thanks for the informative blog. I was following your steps for upgrading from Single-instance to RAC and ran into an error when trying to create the db on the 2nd node. I can run "dbca" and get to the the "create database" part at the end and then it blows up with "ORA-202 instance_number busy".

Did you happen to run into similar issues? Thank You!

Anonymous said...

from your article i have succesfully installed rac on ole5.5. and i have also converted from single to rac database instance .....
all your posts /articles work without any issue hey could u post some kind ofbackup and recovery for ex hot backup ,rman and small tests such as transcations .......

Thanks in Advance

keep doing the gud work ......

god bless u

Best Regards

Anonymous said...

Excellent, thank you so much.

Greetings from Costa Rica


Anonymous said...

A very Good link to DBA.