Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Listener is stopping !

RE: Listener is stopping !

From: kathy duret <>
Date: Fri, 1 Dec 2006 11:27:20 -0800 (PST)
Message-ID: <>

Been there done that.......    

  You are running out of virtual bytes on Windows...    

  Are you using the 3G switch? If not this is the first thing you should do.        

  beware of using the /PAE switch others have reported memory leaks using this up to and including not sure if it is fixed in or beyond. You take a performance hit to with /PAE I understand.    

  Also use DCD in sqlnet.ora to get of old windows connections.    

  We used orastack to reduce the connections from 1M to 700M and that is buying us some time.    

  Else Oracle recommends that you upgrade to 10g or use windows 64.           

walid alkaakati <> wrote:

    Hi Again .    

  When the dbase hangs the listener.log file shows the following errors :    

  TNS-12547: TNS:lost contact
 TNS-12560: TNS:protocol adapter error
  TNS-00517: Lost contact
   32-bit Windows Error: 54: Unknown error     TNS-12500: TNS:listener failed to start a dedicated server process      TNS-12560: TNS:protocol adapter error    

  After i serached about window error 54 i found it is a network error ,also the error may be from swap space and virtual memory ( number of semaphores...) i will increase these and monitor performace event log.    

  Oracle version on window nt 2000 .    

  Can any of you add another suggestions ?    


"Best, David" <> wrote:          

  Are you running out of memory on the server?     

  From: [] On Behalf Of Ghassan Salem Sent: Saturday, November 18, 2006 4:11 AM To: walid alkaakati
Subject: Re: Listener is stopping !   

What version of Oracle is this? (and what Win version)? Put the listener in debug mode (lsnrctl then trace debug , or modify the listener.ora )


  On 11/18/06, walid alkaakati <> wrote: Thanks Ghassan,    

  I checked the listener.log it shows every thing normal.   however when the problem happens i check tns-service in contral panel->services i find sid service is running however the listner service is not running so i restart the server and so on... is the listener becoming tired when i have many connectins !   the system adminstrator cannot find the meaning of the error " local agent reponse " in the system event , how shall i proceed in the investigation.         

Ghassan Salem <> wrote:   Walid,
what do you mean by 'listener is stopping'? if you do a 'ps -ef|grep tns', you see no tns program running? if that is the case, look at the listener.log (in oh/network/log) to see if there is any error message there.


  On 11/18/06, walid alkaakati <> wrote: Hi list ,    

  I need your help on this urgent issue .    

  Each day iam facing a problem , the applicaton is freezing and all my users (150) can not do any thing and you cannot do any new connections , some times this is accompanied by message (" can ot open dedicated server process...."),   when i checked the services i found that listener is stopped automatically !    

  I wonder why it is stopping IS it that i have to add new listener or what ?   Net work problems ? how i verify that it is a network problem ?   the alert .log do not show anything , the window event shows " local agent error "   where i shall start?    

  Wating your help.

  Sponsored Link

Mortgage rates as low as 4.625% - $150,000 loan for $579 a month. Intro-*Terms     

  Sponsored Link

Mortgage rates near 39yr lows. $510,000 Mortgage for $1,698/mo - Calculate new house payment    

       This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.     

  Access over 1 million songs - Yahoo! Music Unlimited.  

Want to start your own business? Learn how on Yahoo! Small Business.
Received on Fri Dec 01 2006 - 13:27:20 CST

Original text of this message