Re: Oracle TNS error

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Wed, 07 May 2003 16:34:41 -0700
Message-ID: <lKgua.27181$MJ5.20578_at_fed1read03>


Carol wrote:

> Hi
> I have checked the listener.log and there seems to be no errors logged
> here.
> I have errors in the sqlnet.ora log files and found one that occurs at
> the same time as I get the entry in the alert.log, the error is as
> follows:

I have experience reading SQL*Trace files, but here is my (educated?) guess.

Within the output are numerous sections which are similar to the following one...

[06-MAY-2003 16:07:15:015] ntt2err: soc 7804 error - operation=6,

ntresnt[0]=530, ntresnt[1]=54, ntresnt[2]=0

[06-MAY-2003 16:07:15:015] ntt2err: exit
[06-MAY-2003 16:07:15:015] nttwr: exit
[06-MAY-2003 16:07:15:031] nspsend: transport write error
[06-MAY-2003 16:07:15:031] nspsend: error exit
[06-MAY-2003 16:07:15:031] nserror: entry
[06-MAY-2003 16:07:15:031] nserror: nsres: id=1, op=67,
ns=12571,ns2=12560; nt[0]=530, nt[1]=54, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[06-MAY-2003 16:07:15:031] nsdofls: exit (-1)
[06-MAY-2003 16:07:15:031] nsdo: nsctxrnk=0
[06-MAY-2003 16:07:15:031] nsdo: error exit
[06-MAY-2003 16:07:15:031] nioqrc: send failed: bl = 1, nicbl = 1
[06-MAY-2003 16:07:15:031] nioqper: error from nioqrc
[06-MAY-2003 16:07:15:031] nioqper: nr err code: 0
[06-MAY-2003 16:07:15:031] nioqper: ns main err code: 12571
[06-MAY-2003 16:07:15:031] nioqper: ns (2) err code: 12560
[06-MAY-2003 16:07:15:031] nioqper: nt main err code: 530
[06-MAY-2003 16:07:15:031] nioqper: nt (2) err code: 54
[06-MAY-2003 16:07:15:031] nioqper: nt OS err code: 0
[06-MAY-2003 16:07:15:031] nioqer: entry
[06-MAY-2003 16:07:15:031] nioqer: incoming err = 12150
[06-MAY-2003 16:07:15:031] niomapnserror: entry
[06-MAY-2003 16:07:15:031] niomapnserror: entry
[06-MAY-2003 16:07:15:031] niqme: entry
[06-MAY-2003 16:07:15:031] niqme: reporting NS-12571 error as ORA-12571

My rudimentary interpretation is that at the heartr of the problem are NT reported errors. SQL*Net is doing its best to report a problem.

HTH & YMMV! Received on Thu May 08 2003 - 01:34:41 CEST

Original text of this message