Xref: alice comp.databases.oracle.server:33588 Path: alice!news-feed.fnsi.net!news.idt.net!netnews.com!newsfeed.enteract.com!news.he.net!news.pbi.net!192.160.13.7!bug.rahul.net!rahul.net!a2i!erinet.com!dca1-feed4.news.digex.net!digex!news1.bms.com!ganglia.bms.com!not-for-mail From: Dan Roberts Newsgroups: comp.databases.oracle.server Subject: How do I trouble Shoot the tns listner in UNIX?? Date: Wed, 11 Nov 1998 22:21:50 -0500 Organization: My Own Lines: 17 Message-ID: <364A544E.1734A502@bms.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: Mozilla 4.03 [en] (Win95; I) Hi All My TNS listener in UNIX/IRIX 6.4 was giving me trouble today and I am wondering if soemone can give me pointers on how to trouble shoot this. This what happened.. I noticed that we where having lots of network problems at work.. Someone called me and said that they couldn't get into oracle. I tried to login into sqlplus and I could..then I did a ps-eaf | grep tns and saw that the listener process was still running..but yet via our web interface we were gettting the tns ora error. So I restarted the listener and everything was back to normal. Does the listener die now and then if there is a lot of network delay for what ever reason?? Have any clues on how to go about troubleshooting these weirdness??>>Thanks,