Re: Two instances with same SID in a same machine

"Firehawk®" <firehawk-brazil_at_gmx.net> wrote in message news:<Xns9551D26DEBDAfirehawkcom_at_200.207.210.100>...
> Is it possible ?
> I am debating this question with a job partner.
> My opinion is if I
> use two diferents Oracle users like oracleA and oracleB

I don't think it's nessesary.

> and make two instalations wholly separated, it's possible

It's a must. You must have two separate oracle homes. Lock file names gonna be identical so they must live in different places.

> and to attach to instances use differents listeners ports.

I suspect even this is not nessesary but don't have time to check.

> Am I correct ?

Possible on Unix but why not check it by yourself?

> Thanks,
> Marcelo

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<412ea3d7$0$27732$afc38c87_at_news.optusnet.com.au>...

> can two areas of shared memory be referenced by exactly the same identifier
> (SID)? To which the answer is, try as you might, no.

Don't shared memory segments are referenced by unique _numbers_, not strings? Also instance can allocate several shmem segments to satisfy sga requirements. They couldn't all be referenced by the same SID if SID indeed was used.

Hans Forbrich <forbrich_at_yahoo.net> wrote in message news:<aRuXc.56501$X12.21029_at_edtnps84>...

> Two people caled Marcelo in the same room. Someone yells 'Hey Marcelo, come
> here' - which one is supposed to answer?

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

Cheers,
Igor Received on Fri Aug 27 2004 - 03:33:43 CDT