home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 730 of 2,288   
   Anna C. Dent to Swapnajit Mittra   
   Re: Question on debugging TNS-12560   
   30 Nov 03 10:12:52   
   
   From: anacdent@hotmail.com   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca