Re: Question on debugging TNS-12560

Swapnajit Mittra wrote:
> Hello all,
>
> I have oracle 9i installed on win2k. It works without problem
> most of the time, but once in a while I get TNS-12560:protocol
> adapter error --> during login <--.
>
> I know re-installation is probably one solution which I did
> earlier but seeing the mess it involves, I am not very inclined
> to do so.
>
> Following the suggestions of an earlier post in this newsgroup,
> I tried the following things in a DOS window:
>
> 1. Ping my machine: Worked
> 2. tnsping my ORACLE_SID (which is ORACL): Gave OK.
> 3. set ORACLE_SID=ORACL
> 4. sqlplus system/manger: This still gave a 12560 error.
>
> I am a novice in this. Can somebody please let me know
> how to debug this problem? I am attaching my listener.ora
> and tnsnames.ora from the D:\oracle\ora92\network\admin
> directory if that helps.
>
> Regards,
> - Swapnajit.

unset TWO_TASK environmental variable Received on Sun Nov 30 2003 - 19:12:52 CET