RE: Listener is stopping !

Your listener is not stopping.
It fails to create server process for the new client connection.
Pay attention to this message:
 
TNS-12500: TNS:listener failed to start a dedicated server process
 
which usually means there isn't enough resources on the machine (i.e.
memory), or oracle reached max # of allowed processes, defined by init
parameter.
 
Igor

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of walid alkaakati
Sent: Friday, December 01, 2006 4:00 AM
To: Best, David
Cc: oracle-l@xxxxxxxxxxxxx
Subject: 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 <mailto: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
<https://www2.nextag.com/goto.jsp?product=100000035&url=%2fst.jsp&tm=y&s
earch=b_rate150k&s=3968&p=5035&disc=y&vers=722>  



                
________________________________

                Sponsored Link
                
                Mortgage rates near 39yr lows. $510,000 Mortgage for
$1,698/mo - Calculate new house payment
<http://www.lowermybills.com/lre/index.jsp?sourceid=lmb-9134-16416&moid=
4119>  


         
             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://pa.yahoo.com/*http://us.rd.yahoo.com/evt=36035/*http://music.yah
oo.com/unlimited/>

Other related posts: