Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Batch SQLPLUS on Win 2000

RE: Batch SQLPLUS on Win 2000

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Wed, 13 Nov 2002 06:54:16 -0800
Message-ID: <F001.0050201E.20021113065416@fatcity.com>


Ron,

Did you re-install Oracle after you upgraded to Win2k? I use ORACLE_HOME and ORACLE_SID in all by Win2k scripts and it works fine.

Maybe the path got screwed up? What error do you get exactly?

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Wednesday, November 13, 2002 8:58 AM To: Multiple recipients of list ORACLE-L

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).
--

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

Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us
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 - 08:54:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US