RE: Listener is stopping !

From: kathy duret <katpopins21_at_yahoo.com>
Date: Fri, 1 Dec 2006 11:27:20 -0800 (PST)
Message-ID: <941087.17712.qm@web38202.mail.mud.yahoo.com>

Been there done that.......

You are running out of virtual bytes on Windows...

Are you using the 3G switch? If not this is the first thing you should do.

beware of using the /PAE switch others have reported memory leaks using this up to and including 9.2.0.6 not sure if it is fixed in 9.2.0.7 or beyond. You take a performance hit to with /PAE I understand.

Also use DCD in sqlnet.ora to get of old windows connections.

We used orastack to reduce the connections from 1M to 700M and that is buying us some time.

Else Oracle recommends that you upgrade to 10g or use windows 64.

walid alkaakati <walid_alkaakati_at_yahoo.com> wrote:

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_at_cognos.com> wrote:

Are you running out of memory on the server?

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ghassan Salem Sent: Saturday, November 18, 2006 4:11 AM To: walid alkaakati
Cc: oracle-l_at_freelists.org
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_at_yahoo.com> 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_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> 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