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

Search Discussions

  • Mercadante, Thomas F at Nov 13, 2002 at 2:54 pm
    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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedNov 13, '02 at 1:58p
activeNov 13, '02 at 2:54p
posts2
users2
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase