RE: Problem upgrading from Windows 2000 Oracle 8.0.6 to Oracle 9.2.0.1.0

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Wed, 23 Jun 2004 11:52:38 -0700
Message-ID: <B5C5F99D765BB744B54FFDF35F60262109F87920@irvmbxw02>

In case you didn't know, the variable LOCAL on Windows acts the same way as TWO_TASK on Unix.
If you set both LOCAL and ORACLE_SID (on Windows) or both TWO_TASK and ORACLE_SID (on Unix) then LOCAL / TWO_TASK will be used.
-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Paul Vincent Sent: mercredi, 23. juin 2004 05:21
To: oracle-l_at_freelists.org
Subject: RE: Problem upgrading from Windows 2000 Oracle 8.0.6 to Oracle 9.2.0.1.0

Solved the "sqlplus" problem - it wasn't anything to do with setting = ORACLE_SID (tried that - didn't work). The trick is to set the "LOCAL" = system variable to the name of the required instance. Setting a system = variable made it permanent, but the same affect could be achieved = temporarily in a DOS window by typing "set LOCAL=3Dxxxxxx" before typing =
"sqlplus".

Another thing I never knew (and didn't know I didn't know)!

That still hasn't solved the main problem with Database Upgrade = Assistant, alas...

---

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

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Wed Jun 23 2004 - 13:49:29 CDT