RE: playing around with oracle 10.2, RAC with VMWare Server and Suse 10.1

From: Mathias Zarick <Mathias.Zarick_at_trivadis.com>
Date: Wed, 28 Jan 2009 09:25:51 +0100
Message-ID: <370BF313301A024C962B057686863683017CF456_at_MSXVS04.trivadis.com>



Hi Tony,  

first of all your ASM instances have to be set up clustered. You need to access the diskgroups from all
nodes.  

To turn a single instance database into RAC you could use rconfig which will do the job for you.
see chapter D in the os specific 10g Docs "Oracle Clusterware and Oracle Real Application Clusters Installation and Configuration Guide for ..."  

If you want to do it on your own:
Create undo tablespaces for the other instances. Create redo log groups for the other threads. e.g.
ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 4 SIZE 100M, GROUP 5 SIZE 100M, GROUP 6 SIZE 100M;
ALTER DATABASE ENABLE PUBLIC THREAD 2;
Parameters that should be set instance specific: instance_number,thread,instance_name,undo_tablespace. It is not neccessary to recreate your controlfile! Nevertherless the error you posted when trying this was related to ASM. Diskgroup was not mounted.  

HTH Mathias

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 28 2009 - 02:25:51 CST

Original text of this message