Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Listener is stopping !

Re: Listener is stopping !

From: Ghassan Salem <salem.ghassan_at_gmail.com>
Date: Mon, 27 Nov 2006 12:12:50 +0100
Message-ID: <411d50f60611270312s12208af8y3e5458ee3eaf9fc6@mail.gmail.com>


Walid,
what version is this listener (is it the same as the db?, how many oracle_homes do you have on this machine?)

rgds

On 11/27/06, walid alkaakati <walid_alkaakati_at_yahoo.com> wrote:
>
> Hi again ,
>
> Finally the database hanged again but this time the listener did not stop
> ,i could not make any connection even from the server.
>
> The listener.trace shows the following errors :
>
> *Incoming connection section :*
> ntt2err: soc 432 error - operation=5, ntresnt[0]=524, ntresnt[1]=36,
> ntresnt[2]=0
> ntt2err: soc 452 error - operation=5, ntresnt[0]=524, ntresnt[1]=997,
> ntresnt[2]=0
> ntn2err: error: handle=444, op=5, nt[0]=524, nt[1]=997
> nserror: nsres: id=4, op=68, ns=12537, ns2=12560; nt[0]=507, nt[1]=0,
> nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
>
> NA disabled remotely for this connection
> NA services unavailable on both processes - negotiation not needed .
>
> Do any of you have any idea about these errors ?
>
> Thank you all for your help.
>
>
>
>
> *Ghassan Salem <salem.ghassan_at_gmail.com>* wrote:
>
> Walid,
> from the menu where you have oracle tools, go to the configuration part,
> choose 'net manager', then from the general parameters of the listener, you
> can set the tracing level for your listener.
>
>
> On 11/18/06, walid alkaakati <walid_alkaakati_at_yahoo.com> wrote:
> >
> > hi ,
> > It oracle 9.2.0.4.0 version on windows server 2000 .
> > Can please elaborate on modifing listener.ora ? do you mean add new
> > listener?
> > how can i trace debug?
> >
> > *Ghassan Salem <salem.ghassan_at_gmail.com>* wrote:
> >
> > 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
> > > > ------------------------------
> > > > 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&search=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>
> > >
> >
> >
> > ------------------------------
> > Sponsored Link
> >
> > $200,000 mortgage for $660/mo - 30/15 yr fixed, reduce debt, home equity
> > - Click now for info<http://www.ratemarketplace.com/forms/form.jsp?ADEL=Os4fVJ19lSwzAOc%2FzMz%2FCYLqA5sBlJ%2FHICjGxkSe1FKtmWyM5TR8Nlp9tRyEufWO&PI=y_mail_textlink>
> >
>
>
> ------------------------------
> Everyone is raving about the all-new Yahoo! Mail beta.<http://us.rd.yahoo.com/evt=45083/*http://advision.webevents.yahoo.com/mailbeta>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 27 2006 - 05:12:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US