Re: Adding Second Database in oracle 10g

From: Bob Jones <email_at_me.not>
Date: Sun, 19 Mar 2006 23:42:20 GMT
Message-ID: <w%lTf.40304$_S7.10677@newssvr14.news.prodigy.com>

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:tv6dnc2s8Mfgy4DZnZ2dnUVZ_sydnZ2d_at_comcast.com...
>
> "Frank van Bortel" <frank.van.bortel_at_gmail.com> wrote in message
> news:dvjdc2$e8p$1_at_news1.zwoll1.ov.home.nl...
> : Bob Jones wrote:
> : >
> : > Are you trying to add a second database to the same instance? It will
> not
> : > work in Oracle. Unlike most other databases, it is one database per
> instance
> : > in Oracle. So add a new instance before creating the database.
> : >
> :
> : Nitpicking: multiple instances can connect to one database.
> : RAC would be a prime example of that.
> :
> : So to say: "it's one database per instance"... it's simply not true
>
> actually it is true.
>
> but, you can have multiple instances per database (simple 1:m relationship
> phraseology) ;-)
>
> ++ mcs
>
>

What I was trying to tell OP was that there cannot be more than one database per instance in Oracle. Received on Sun Mar 19 2006 - 17:42:20 CST