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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle hangs on select statement on certain computers

Re: Oracle hangs on select statement on certain computers

From: Dan <everkleer80_at_gmail.com>
Date: 21 Feb 2006 08:51:13 -0800
Message-ID: <1140540673.893089.63120@o13g2000cwo.googlegroups.com>


I ran a trace on this through my sqlnet.ora file and it seems to do a small amount of data processing and then it gets stuck in an infinite loop of the folowing:

[21-FEB-2006 10:31:02:568] nsdo: entry
[21-FEB-2006 10:31:02:568] nsdo: cid=0, opcode=85, *bl=0, *what=0,
uflgs=0x0, cflgs=0x3
[21-FEB-2006 10:31:02:568] nsdo: rank=64, nsctxrnk=0
[21-FEB-2006 10:31:02:568] nsdo: nsctx: state=8, flg=0x100420d, mvd=0
[21-FEB-2006 10:31:02:568] nsdo: gtn=127, gtc=127, ptn=10, ptc=2047
[21-FEB-2006 10:31:02:568] nsdo: switching to application buffer
[21-FEB-2006 10:31:02:568] nsrdr: entry
[21-FEB-2006 10:31:02:568] nsrdr: recving a packet
[21-FEB-2006 10:31:02:568] nsprecv: entry
[21-FEB-2006 10:31:02:568] nsprecv: reading from transport...
[21-FEB-2006 10:31:02:568] nttmrd: entry
[21-FEB-2006 10:31:02:568] ntt2err: entry
[21-FEB-2006 10:31:02:568] ntt2err: exit
[21-FEB-2006 10:31:02:568] nttmrd: socket 384 had bytes read=0
[21-FEB-2006 10:31:02:568] nttmrd: exit
[21-FEB-2006 10:31:02:568] nsprecv: transport read error
[21-FEB-2006 10:31:02:568] nsprecv: error exit
[21-FEB-2006 10:31:02:568] nserror: entry
[21-FEB-2006 10:31:02:568] nsrdr: error exit
[21-FEB-2006 10:31:02:568] nsdo: *what=0, *bl=0
[21-FEB-2006 10:31:02:568] nsdo: nsctxrnk=0
[21-FEB-2006 10:31:02:568] nsdo: error exit
[21-FEB-2006 10:31:02:568] nioqrc: wanted 1 got 0, type 0
[21-FEB-2006 10:31:02:568] nioqer: entry
[21-FEB-2006 10:31:02:568] nioqer: incoming err = 12151
[21-FEB-2006 10:31:02:568] nioqce: entry
[21-FEB-2006 10:31:02:568] nioqce: exit
[21-FEB-2006 10:31:02:568] nioqer: returning err = 3123
[21-FEB-2006 10:31:02:568] nioqer: exit
[21-FEB-2006 10:31:02:568] nioqrc: exit
[21-FEB-2006 10:31:02:678] nioqrc: entry

Anyone seen this? Received on Tue Feb 21 2006 - 10:51:13 CST

Original text of this message

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