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

From: RSL <rob.langmuir_at_joking.plus.com>
Date: Wed, 23 Jun 2004 12:43:14 +0100
Message-ID: <001f01c45917$44ce30e0$0100000a@lan>

Paul,

        This scenario below is because the sid is not set.
        If you set oracle_sid=xxxx, and then simply type sqlplus
        and enter username/password when prompted, you will not
        get ORA-12560. 

        The other servers must have oracle_sid set.

HTH....../Bob          

        .......... 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     

---

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 - 06:42:19 CDT