Batch SQLPLUS on Win 2000

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Wed, 13 Nov 2002 05:58:26 -0800
Message-ID: <F001.00501F20.20021113055826@fatcity.com>

We recently upgraded our Oracle server from NT to 2000. I have a batch script that runs SQLPLUS that no longer works. Like a good DBA I always included ORACLE_HOME and ORACLE_SID set command in each script. Now the script woll only run if I remove the ORACLE_HOME and ORACLE_SID set commands. There is only one sid on this server right now but that could change any time. Can anyone tell me what changed with Win 2000 and how to specify ORACLE_HOME and ORACLE_SID in Win 2000?

Thanks!

R. Smith
If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you.
--

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

Author: Smith, Ron L.
  INET: rlsmith_at_kmg.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). Received on Wed Nov 13 2002 - 07:58:26 CST