Re: Oracle hangs on select statement on certain computers

On Wed, 22 Feb 2006 00:51:13 +0800, Dan wrote (in article <1140540673.893089.63120_at_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?
>

try changing the network cable between the computer nic & your wall socket. i had the same, when the cable flapped about it caused the oracle to hang. Received on Fri Feb 24 2006 - 04:52:48 CST