It is better to use manual upgrade path. Follow Oracle upgrade instruction
for manual upgrade. I tried DBUA and it fails with all type of strange
errors specially relating to listener.
My experience with manual upgrade is really good. However I am upgarding
mostly from 8.1.7.4 to 9.2.0.4. Oracle doc is really good for manual
upgrade.
Regards
Rafiq
From: "Paul Vincent " <Paul.Vincent@(protected) >
Reply-To: oracle-l@(protected)
To: <oracle-l@(protected) >
Subject: RE: Problem upgrading from Windows 2000 Oracle 8.0.6 to Oracle
9.2.0.1.0
Date: Wed, 23 Jun 2004 13:21:18 +0100
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...
Cheers,
Paul
-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of RSL
Sent: 23 June 2004 12:43
To: oracle-l@(protected)
Subject: Re: Problem upgrading from Windows 2000 Oracle 8.0.6 to Oracle
9.2.0.1.0
Paul,
This scenario below is because the sid is not set.
If you set oracle_sid=3Dxxxx, and then simply type sqlplus
and enter username/password when prompted, you will not
get ORA-12560 (See ORA-12560.ora-code.com).=20
The other servers must have oracle_sid set.
HTH....../Bob =20
.......... peculiarity on this server that, if I open a DOS
window and simply type "sqlplus ", then I 'm asked for a username and
password, which I supply, and then I get an error message ORA-12560 (See ORA-12560.ora-code.com):
TNS:protocol adapter error.
If however I type "sqlplus myuserid/mypasswd@(protected) ", ,,,,,,,,,,
I suspect=20
=20
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ __
FREE pop-up blocking with the new MSN Toolbar ?get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
