Pual, 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@xxxxxxxxx> Reply-To: oracle-l@xxxxxxxxxxxxx To: <oracle-l@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of RSL Sent: 23 June 2004 12:43 To: oracle-l@xxxxxxxxxxxxx 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.=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: TNS:protocol adapter error. If however I type "sqlplus myuserid/mypasswd@DLIB", ,,,,,,,,,, I suspect=20 =20 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------