RE: Listener is stopping !

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Sat, 18 Nov 2006 11:38:17 -0500
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC1663B8A2@ENYC11P32005.corpny.csfb.com>

Check the value of instance initialization parameter PROCESSES. You may be reaching the limit; if so, increase the parameter and restart instance.

Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of walid alkaakati Sent: Saturday, November 18, 2006 3:55 AM To: Ghassan Salem
Cc: oracle-l_at_freelists.org
Subject: Re: Listener is stopping !

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_at_gmail.com> 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_at_yahoo.com <mailto:walid_alkaakati_at_yahoo.com> > 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