Re: Oracle hangs on select statement on certain computers

"Dan" <everkleer80_at_gmail.com> wrote in news: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] 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?
>
>

12151, 00000, "TNS:received bad packet type from network layer"

// *Cause:  Internal error.
// *Action: Not normally visible to the user. For further details, turn
// on tracing and reexecute the operation. If error persists, contact
// Worldwide Customer Support.

03123, 00000, "operation would block"

// *Cause:  This is a status code that indicates that the operation
//          cannot complete now. 
// *Action: None; this is not an error.  The operation should be retried
//          again for completion.