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/>