Re: Using dbca and RAC with 9.2.0.5

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 24 Nov 2004 16:21:29 +1100
Message-ID: <41a41a53$0$17544$afc38c87@news.optusnet.com.au>

Michael wrote:
> Hi,
>
> DBCA normally does a great job

It does an exceptional job ...of creating single instance databases. It does a less spectacularly brilliant job of creating RAC instances. Not saying it doesn't work: usually it does. But not always.

> and and in case you work with a well
> prepared (own) templates you save a lot of work and manually tasks to
> step through - especially when you create a RAC database.

There are about 8 alter system commands required to convert single instance database to a multi-instance one (assuming, as I should have said in my first post, that you are using an spfile, of course). I don't think that's a lot of effort.

> I worked for
> years with Oracle 7 and the Parallel Server Option on a 6 node OpenVMS
> Cluster and compared with this time today it's nearly easy doing.
> Just to think about ....
>
> Michael

Fair enough. Different experiences, different suggestions. Mine is based on several dozen RAC installations (real ones) that all went extremely smoothly doing it the way I suggested, and a couple where I used the dbca create-and-propagate method with mixed results.

Regards
HJR Received on Tue Nov 23 2004 - 23:21:29 CST