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

  • From: "Mathias Zarick" <Mathias.Zarick@xxxxxxxxxxxx>
  • To: <tony.adolph.dba@xxxxxxxxx>
  • Date: Wed, 28 Jan 2009 09:25:51 +0100

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

Other related posts: