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@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Paul Vincent
Sent: mercredi, 23. juin 2004 05:21
To: oracle-l@(protected)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
