Re: ORACLE_SID

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.

>>Also, the users of the databases are not computer literate and want to
>>do as little as possible, therefor, I created script files to take them
>>to their appropriate applications. The only problem I have encounted is
>>that if I put setenv ORACLE_SID SID# in my script files this line is
>>ignored. I have asked the users to type this line in at the prompt and
>>then select the appropriate option, but they have not been doing this.Is
>>there some way for me to set up the user's SID so that it
>>changes for them depending on what option they choose?
>>note -- I'm using a Sun Sparkserver with Sun OS 4.1.3

>Try export after setting ORACLE_SID, check spelling and case.

This does not make sense. setenv is csh syntax, export is sh/ksh syntax.

Either:

	Brenda is using sh/ksh in which case setenv is not being ignored
	it is being rejected as a syntax error.  In this case the script
	must be amended to assign ORACLE_SID correctly as well as export
	it.
Or:
	Brenda is using csh in which case setenv is almost certainly not
	being ignored, but is being amended again in a later script
	(coraenv perhaps?).

graeme

--
Disclaimer:	The author's opinions are his own, and not necessarily
		those of Pyramid Technology Ltd. or Pyramid Technology Inc.
---------------------------------------------------------------------------
      -m------- Graeme Sargent                 Voice: +44 (0)252 373035
    ---mmm----- Senior Database Consultant     Fax  : +44 (0)252 373135
  -----mmmmm--- Pyramid Technology Ltd.        Telex: Tell who???
-------mmmmmmm- Farnborough, Hants  GU14 7PL   Email: graeme_at_pyra.co.uk
---------------------------------------------------------------------------
    We have the technology.  The tricky bit is learning how to use it.