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

From: Paul Vincent <Paul.Vincent_at_uce.ac.uk>
Date: Wed, 23 Jun 2004 10:58:59 +0100
Message-ID: <14C5F9616FF43F479F67E41A1DF4D94A02048ECA@exchangeb.staff.uce.ac.uk>

One other thought, which may have some bearing on the problem.

It's always been a 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", thereby forcing resolution, everything works fine.

None of our other Windows Oracle servers have this peculiarity, so I'd wondered if it was a quirk of 8.0 (this is the only 8.0 server). Now I'm not so sure.

Just wondered if this might ring some bells, as it may be linked to my database upgrade assistant problem.

Paul

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 - 04:55:52 CDT