Oracle-L: RE: important question about SID environment variable (NT)

From: Naveen Nahata <naveen_nahata_at_mindtree.com>
Date: Mon, 25 Nov 2002 21:28:42 -0800
Message-ID: <F001.0050BA6B.20021125212842@fatcity.com>

Are you talking about ORACLE_SID? It gets stored in the registry under HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE -> HOME<ID>

If you want to set it via environment variables so that it is accessible to all DOS shells for a particular login, you can right click on MY COMPUTER, go to PROPERTIES -> ENVIRONMENT -> and then set ORACLE_SID in the user variables

Regards
Naveen

-----Original Message-----
Sent: Tuesday, November 26, 2002 4:19 AM To: Multiple recipients of list ORACLE-L

for NT4.0 ver 8i

does a typical oracle install create the environement variable SID ?

i just checked, via set command on windows NT. the env variable for SID is not set. though there are other oracle related env variables like path, classpath that point to various files of oracle install etc

so should i manually set the SID environment variable ?? if so how ? if set it manually then it is good for that shell only. what about programs like Database config assistant that are lauched via the Start>>Programs>>OraHome..... how would they read this or such an enviroment variable that is set via the command prompt. (env variable set via the command prompt with command like set variable1 = c:\ora\bin\..... etc etc will only be vaild in that shell which created it. how to make it across the whole OS ?

i am asking this because the Oracle DB Config Assistant requires the SID environment variable to be set.

from where should i launch the GUI for oracle config assistant. if to be launched from shell ie command prompt, then what is the name of the executable for this GUI ?

Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: john
INET: john_g123_9_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Naveen Nahata
INET: naveen_nahata_at_mindtree.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------