Re: Oracle Listener failure

sybrandb wrote:
> On Nov 29, 8:51 am, aone1..._at_yahoo.com wrote:
> > We have Oracle server 9i in our site and sometimes the Listener process
> > fails. This happens roughly twice a month(not regularly) and affects
> > our production. When we try to log into the server we get the message
> > Oracle Listener Failed. And, after this we restart the database server.
> > But we lose about 20 minutes every time this happens.
> >
> > Can anyone tell me why Listener process fails ? and is there any way of
> > preventing this ?
> >
> > Thanks,
> > Srini
>
>
> This is way too little information to work on. First of all 'Listener
> failed' is not an Oracle error message. One would need an Oracle error
> message.
> Secondly, you would need to examine the listener log (located in
> $ORACLE_HOME/network/log) for error messages, preferably *prior* to
> calling for assistance.
> My experience is listeners *never* fail. So you are calling for someone
> to take their crystal ball and have them resolve it, without any
> *relevant* information.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Well, never say never. While listener failures are pretty rare, I've seen a couple. On just this last weekend that sent upper management looking for a head on a platter. Left nary a trace in the listener log and we eventually gave up trying to explain it. Then, while looking for information on another listener issue, I stumbled across MetaLink Note:340091.1 Received on Wed Nov 29 2006 - 07:58:47 CST