Oracle FAQ Your Portal to the Oracle Knowledge Grid

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

RE: Listener is stopping !

From: Igor Neyman <>
Date: Fri, 1 Dec 2006 09:36:59 -0500
Message-ID: <>

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.  


[] On Behalf Of walid alkaakati Sent: Friday, December 01, 2006 4:00 AM
To: Best, David
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 on window nt 2000 .  

Can any of you add another suggestions ?  


"Best, David" <> wrote:          

        Are you running out of memory on the server?

[] 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:

			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 < 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
< 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://music.yah>

Received on Fri Dec 01 2006 - 08:36:59 CST

Original text of this message