Batch SQLPLUS on Win 2000

2002-11-13 Thread Smith, Ron 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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



RE: Batch SQLPLUS on Win 2000

2002-11-13 Thread Mercadante, Thomas F
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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).