RE: Conversion of Single instance ASM Database to RAC ?

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_at_infosys.com] Sent: Friday, 24 August 2007 04:42 AM
To: oracle-l_at_freelists.org
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***

--
http://www.freelists.org/webpage/oracle-l