Re: ORACLE_SID

In article <1993Jun4.180752.20859_at_pyra.co.uk>, graeme_at_pyra.co.uk (Graeme Sargent) writes:
|> In <739084860snz_at_artemis.demon.co.uk> tinalondon_at_artemis.demon.co.uk (tina london) writes:
|>
|> >In article <bsmadu.2.739060634_at_dres.dnd.ca> bsmadu_at_dres.dnd.ca writes:
 

|> >>Sorry if this is a stupid question but I'm curious about something.
|> >>Can anyone explain to me what damage occurs if your ORACLE_SID points
|> >>to another database on the system (not the one you are using)
|> >>For example, we have four instances/databases running on our server.
|> >>What happens if my ORACLE_SID is SID1 yet I'm using instance 2 which
|> >>should have ORACLE_SID set to SID2?
 

|> >You will be accessing SID1.
|>
|> I agree with Tina. I do not believe you could have achieved this. If
|> ORACLE_SID is SID1 you must, *by definition*, be using instance SID1,
|> not instance 2.

Not necessarily; the TWO_TASK environment variable ignores ORACLE_SID. (It tells SQL*net which instance to access).

--rest deleted---

-- 
                               John Peach
                           Chevron (UK) Ltd.
   Ninian House, Crawpeel Road, Altens, Aberdeen, AB1 4LG, Scotland.
   Internet: epeas_at_aberdeen.chevron.com        Phone: +44 224 242637