RE: Listener is stopping !

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@xxxxxxxxxx> wrote:
         
  Are you running out of memory on the server?

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

Other related posts: