We had this problem few months back. You are to check how many sessions are
opened at that point of time,
select count(*) from v$session.
1.Check for processes parameters in your pfile
2.We had limitation on operating system parameters. Since we were using
linux we had to tune kernal parameters to overcome this problem.
Hope it will help
Regards
Neelam

----- Original Message -----
From: "simion " <oracledba-ezmlmshield-x6172559.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Monday, August 01, 2005 12:36
Subject: RE: RE TNS Listener


> This is my log and trace files. Do any of them look familiar
>
> LISTENER.LOG
>
> TNS-12500: TNS:listener failed to start a dedicated server process
> TNS-12537: TNS:connection closed
> TNS-12560: TNS:protocol adapter error
> TNS-00507: Connection closed
> VMS Error: 2160:
>
>
> LISTENER.TRC
> nttcnp: Validnode Table IN use; err 0x0
> nttcnp: getting sockname
> nttcnr: waiting to accept a connection.
> ntt2err: soc 6 error - operation=1, ntresnt[0]=530, ntresnt[1]=65535,
> ntresnt[2]
> nsevdrcvreq: got CBK1: evt = 1 packet
> nsevdrcvreq: got CBK2: q = 1 packet
> nsevdrcvreq: got CBK2: evt = 1 packet
> nserror: nsres: id=1, op=68, ns=12537, ns2=12560; nt[0]=507, nt[1]=0,
> nt[2]=2160
> nserror: nsres: id=1, op=65, ns=12560, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0;
> ora[0]=
> nsopen: unable to open transport
> nsglhc: nsanswer error 12560
> nsglhc: Deallocating cxd 0x10f9aa8.
>
> On Mon, 1 Aug 2005 14:22:24 +0800, Nirmal Kumar wrote:
> > **A LazyDBA.com subscriber has responded to your lazydba.com post**
> > **LazyDBA.com mail shield has forwarded you this email,
> > **and removed any attachments, and kept your email address secret
> > **from this person, and any viruses/trojans.
> > **If you reply to this email, the person will see your email
> > address as normal
> > **Anything below this line is the original email text
> >
> > Check the listener.log file..
> > Or LSNRCTL> show staus.
> > -----Original Message-----
> > From: simion
> > [Email address protected]
> > Sent: Monday, August 01, 2005 9:54 AM
> > To: LazyDBA Discussion
> > Subject: RE TNS Listener
> > Hi everyone
> > My TNS Listener keep going down. Has anyone had this problem before.
> > Could be be
> > related to the opening of too many connections on ORACLE.
> > Regards
> > Simion
> >
> > --------
> > website: http://www.LazyDBA.com
> > Please don't reply to RTFM questions
> > Oracle documentation is here: http://tahiti.oracle.com
> > To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> > To subscribe: see http://www.lazydba.com
> > By using this list you agree to these
> > terms:http://www.lazydba.com/legal.html
>
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>


Oracle LazyDBA home page