RE: Listener is stopping !
- From: kathy duret <katpopins21@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 1 Dec 2006 11:27:20 -0800 (PST)
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@xxxxxxxxx> 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@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.
---------------------------------
Want to start your own business? Learn how on Yahoo! Small Business.
Other related posts:
