Re: Two instances with same SID in a same machine

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 27 Aug 2004 21:15:31 +1000
Message-ID: <412f17f2$0$9811$afc38c87@news.optusnet.com.au>

Sybrand Bakker wrote:

> On 27 Aug 2004 01:33:43 -0700, ilaletin_at_usa.net (Igor Laletin) wrote:
>

>>What if two people (listeners) called two different Marcelo's
>>(instances with the same SID) in two different rooms (oracle homes)?
>>
>>Cheers,
>>Igor

>
> It will be an administration nightmare wouldn't it?

It will be an administration impossibility.

You and I are both in agreement, I think: it's not actually *possible*. Never mind would it be a good idea.

If someone wants to jump through the necessary hoops to prove me wrong, be my guest: in the meantime, it is impossible to create two instances on the same machine with the same ORACLE_SID, and I don't care how clever you get in distinguishing between different installations.

Regards
HJR
> And sooner or
> later account 1 will screw up the database located in account 2.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Fri Aug 27 2004 - 06:15:31 CDT