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