FreeLists / oracle-l / RE: Conversion of Single instance ASM Database to RAC ?

["Peter McLarty" <p.mclarty@xxxxxxxxxx>]

Oracle has a lot of information on this, but you have it about right,
you are right your init.ora file will need updating and I am assuming
you are really meaning spfile as you need to use a SP file. for a
cluster db
 
A tip you need to create the spfile with your database open and you will
need to point the init.ora in your dbs directory to that spfile which i
would recommend will reside in ASM.
 
There is a number of parameters that need to be setup for the second
instance, The may automatically create but then they may not or might
use some defaults which would not be helpful.
 
You need to add a service if you want failover and shared load 
Cheers

Peter

 

________________________________

From: VIVEK_SHARMA [mailto:VIVEK_SHARMA@xxxxxxxxxxx] 
Sent: Friday, 24 August 2007 04:42 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Conversion of Single instance ASM Database to RAC ?



Folks

 

How is Conversion of Existing Single instance Database(ASM) to
2-instance RAC done?

 

STEPS Envisaged:-

*       RE-Creation of Controlfile using "RAC Related ORACLE_HOME" with
init.ora parameter cluster_database=FALSE. 

NOTE - This is Done & the Single Instance ASM Database is brought up.

*       Add Redo logfiles for THREAD 2 & Enable the Same. 
*       Change init.ora parameters on Both Nodes (Set
cluster_database=TRUE, cluster_database_instances=2 etc) 
*       Issue following 3 srvctl commands 

$ srvctl add database -d ASMDBR -o /ora/asm10gr2/product

$ srvctl add instance -d ASMDBR -i ASMDBR1 -n spesuns4p-2

$ srvctl add instance -d ASMDBR -i ASMDBR2 -n spesuns4p-4

 

 

NOTE - CRS Setup for 2 Node ASM-RAC is already done & working as seen
below.

$ crs_stat -t

Name           Type           Target    State     Host

------------------------------------------------------------

ora....SM1.asm application    ONLINE    ONLINE    spesuns4p-2

ora....p-2.gsd application    ONLINE    ONLINE    spesuns4p-2

ora....p-2.ons application    ONLINE    ONLINE    spesuns4p-2

ora....p-2.vip application    ONLINE    ONLINE    spesuns4p-2

ora....SM2.asm application    ONLINE    ONLINE    spesuns4p-4

ora....p-4.gsd application    ONLINE    ONLINE    spesuns4p-4

ora....p-4.ons application    ONLINE    ONLINE    spesuns4p-4

ora....p-4.vip application    ONLINE    ONLINE    spesuns4p-4

 

CONFIG:-

*       Oracle 10gR2 
*       Solaris 10 

 

Cheers & Thanks indeed,

 

Vivek

 

 

**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
solely for the use of the addressee(s). If you are not the intended
recipient, please notify the sender by e-mail and delete the original
message. Further, you are not to copy, disclose, or distribute this
e-mail or its contents to any other person and any such actions are
unlawful. This e-mail may contain viruses. Infosys has taken every
reasonable precaution to minimize this risk, but is not liable for any
damage you may sustain as a result of any virus in this e-mail. You
should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content
of all messages sent to or from this e-mail address. Messages sent to or
from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***