WE have oracle installed on a VMS platform so we will have a look at it.

Thanks

On Mon, 1 Aug 2005 12:45:00 +0530, Neelam Dhir 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
>
> 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 " [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