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