Re: ORACLE_SID

In article 739060634_at_dres.dnd.ca, bsmadu_at_dres.dnd.ca (Brenda E. Smadu) 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?
> ... other stuff deleted ...
>note -- I'm using a Sun Sparkserver with Sun OS 4.1.3
> RDBMS 6.0.36.4.1
>
>***********************************************************************
>Brenda E. Smadu | Defence Research Establishment Suffield
>bsmadu_at_dres.dnd.ca | Box 4000
>Phone: (403)544-4619 | Medicine Hat, AB Canada
>Fax: (403(544-3388 | T1A 8K6
>***********************************************************************

As far as I know you do no damage. In fact if you are connecting to the databases using the 'userid/passwd_at_connect_string' option, or setting the TWO_TASK environment variable, as problematic as setting ORACLE_SID I presume, you don't even need to have it set. Beware however this is an empirical determination.

Regards,
David TvE

---
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
David Thornewill von Essen                    I don't speak for Motorola
Motorola ASIC Division                                                   
Chandler, AZ-85224                                   fax: (602) 814-4451
email: ttg242_at_email.sps.mot.com                      tel: (602) 814-4395
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-