Re: Two instances with same SID in a same machine

Hans Forbrich <forbrich_at_yahoo.net> wrote in message news:<5GFXc.19626$A8.2621_at_edtnps89>...
> Igor Laletin wrote:
>
> > What if two people (listeners) called two different Marcelo's
> > (instances with the same SID) in two different rooms (oracle homes)?
> >
>
> Your attempt to twist this {home=room} analogy is not quite appropriate to
> the situation ... in Oracle's case {server=room} and {home=chair}

Not a twist. The analogy is quite appropriate to the listeners. For them oracle home is a room. Everything listener needs is (or could be) in OH.

It's actually quite appropriate to the database engine itself. You can keep almost everything in separate rooms for them. Some things like /tmp/.oracle seems to be hardcoded but again I never tried to change TMP/TMP_DIR. There is a chance even this could be kept separate.

In short, on Unix (server != room && OH == room:)

Regards,
Igor Received on Fri Aug 27 2004 - 17:07:39 CDT