| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Problem upgrading from Windows 2000 Oracle 8.0.6 to Oracle 9.2.0.1.0
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_at_uce.ac.uk>
Reply-To: oracle-l_at_freelists.org
To: <oracle-l_at_freelists.org>
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of RSL
Sent: 23 June 2004 12:43
To: oracle-l_at_freelists.org
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_at_DLIB", ,,,,,,,,,,
I suspect=20
=20
 |
 |