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.