Re: Two instances with same SID in a same machine

From: FM <fabrizio.magni_at_mycontinent.com>
Date: Fri, 27 Aug 2004 14:15:46 +0200
Message-ID: <412f2657$2@x-privat.org>

Howard J. Rogers wrote:

> 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

>
>

Maybe I misunderstood but this is a period where I have to test machine and features and I considered this a good challenge so I tried and here is the result:

oracle    9938     1  0 10:39 ?        00:00:00 ora_pmon_TEST9I
oracle    9943     1  0 10:39 ?        00:00:00 ora_dbw0_TEST9I
oracle    9952     1  0 10:39 ?        00:00:00 ora_lgwr_TEST9I
oracle    9954     1  0 10:39 ?        00:00:00 ora_ckpt_TEST9I
oracle    9962     1  0 10:39 ?        00:00:00 ora_smon_TEST9I
oracle    9967     1  0 10:39 ?        00:00:00 ora_reco_TEST9I
oracle    9969     1  0 10:39 ?        00:00:00 ora_cjq0_TEST9I
oracle    9972     1  0 10:39 ?        00:00:00 ora_qmn0_TEST9I
oracle    9976     1  0 10:39 ?        00:00:00 ora_s000_TEST9I
oracle    9981     1  0 10:39 ?        00:00:00 ora_d000_TEST9I
oracle   10011     1  0 10:39 ?        00:00:00 ora_p000_TEST9I
oraclet  13382     1  0 14:08 ?        00:00:00 ora_pmon_TEST9I
oraclet  13384     1  0 14:08 ?        00:00:00 ora_mman_TEST9I
oraclet  13386     1  0 14:08 ?        00:00:00 ora_dbw0_TEST9I
oraclet  13388     1  0 14:08 ?        00:00:00 ora_lgwr_TEST9I
oraclet  13390     1  0 14:08 ?        00:00:00 ora_ckpt_TEST9I
oraclet  13392     1  0 14:08 ?        00:00:00 ora_smon_TEST9I
oraclet  13394     1  0 14:08 ?        00:00:00 ora_reco_TEST9I
oraclet  13396     1  0 14:08 ?        00:00:00 ora_cjq0_TEST9I
oraclet  13398     1  0 14:08 ?        00:00:00 ora_d000_TEST9I
oraclet  13400     1  0 14:08 ?        00:00:00 ora_s000_TEST9I
oraclet  13402     1  0 14:08 ?        00:00:00 ora_p000_TEST9I

Two different DBs on the same host (a linux system). I needed two different users and two different ORACLE_BASE.

But maybe the main topic was another and my coompreension of the topic was messy...

-- 
Fabrizio Magni

fabrizio.magni_at_mycontinent.com

replace mycontinent with europe

Received on Fri Aug 27 2004 - 07:15:46 CDT