Re: Oracle Listener failure

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