Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

RE: Listener is stopping !

From: walid alkaakati <walid_alkaakati_at_yahoo.com>
Date: Fri, 1 Dec 2006 01:00:12 -0800 (PST)
Message-ID: <20061201090012.79835.qmail@web61117.mail.yahoo.com>


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 9.2.0.4.0 on window nt 2000 .    

  Can any of you add another suggestions ?    

  Thnaks

"Best, David" <David.Best_at_cognos.com> wrote:          

  Are you running out of memory on the server?     



  From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ghassan Salem Sent: Saturday, November 18, 2006 4:11 AM To: walid alkaakati
Cc: oracle-l_at_freelists.org
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 )

rgds

  On 11/18/06, walid alkaakati <walid_alkaakati_at_yahoo.com> 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 <salem.ghassan_at_gmail.com> 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.

rgds

  On 11/18/06, walid alkaakati < walid_alkaakati_at_yahoo.com> 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.
  BYE     



  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.
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 01 2006 - 03:00:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US