Re: Oracle TNS error

"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:<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!
On totally different tack, we appear to have sorted out our problem by increasing the size of the shared_pool_size param in the init.ora file from 50M to 100M. We originally thought ours was a network problem but since we have implemented this change (on the advice of Oracle) our problem has not re-appeared! Not saying this is a deffo' fix for your problem but it might be worth a try.

Hope this helps. Received on Fri May 16 2003 - 14:44:01 CEST