Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

12571 tns packet writer failure when compiling large source code

user7424769Sep 5 2012 — edited Sep 7 2012

Hi gurus,
When we try to compile a large function from windows client (Toad or sqlplus) in a database (Oracle 11g) installed on a Red Hat server, we receive the following
ORA-12571.
When we try to compile the same function from sqlplus in the server, we haven't any problem,even from other Linux server in the same network.

Tracing sqlnet on windows client machine we can see this:
....................................................................
....................................................................
+[05-SEP-2012 15:28:54:642] nspsend: 46 20 78 69 64 5F 61 63 |F.xid_ac|+
+[05-SEP-2012 15:28:54:642] nspsend: 63 69 6F |cio |+
+[05-SEP-2012 15:28:54:642] nspsend: 2011 bytes to transport+
+[05-SEP-2012 15:28:54:642] nspsend: normal exit+
+[05-SEP-2012 15:28:54:642] nsdofls: exit (0)+
+[05-SEP-2012 15:28:54:642] nsdo: nsctxrnk=0+
+[05-SEP-2012 15:28:54:642] nsdo: normal exit+
+[05-SEP-2012 15:28:54:642] nioqsn: exit+
+[05-SEP-2012 15:28:54:642] nioqsn: entry+
+[05-SEP-2012 15:28:54:642] nsdo: entry+
+[05-SEP-2012 15:28:54:642] nsdo: cid=0, opcode=84, bl=0, what=1, uflgs=0x0, cflgs=0x3+
+[05-SEP-2012 15:28:54:642] nsdo: rank=64, nsctxrnk=0+
+[05-SEP-2012 15:28:54:642] nsdo: nsctx: state=8, flg=0x400d, mvd=0+
+[05-SEP-2012 15:28:54:642] nsdo: gtn=127, gtc=127, ptn=10, ptc=2011+
+[05-SEP-2012 15:28:54:642] nsdofls: entry+
+[05-SEP-2012 15:28:54:642] nsdofls: DATA flags: 0x0+
+[05-SEP-2012 15:28:54:642] nsdofls: sending NSPTDA packet+
+[05-SEP-2012 15:28:54:642] nspsend: entry+
+[05-SEP-2012 15:28:54:642] nspsend: plen=2011, type=6+
+[05-SEP-2012 15:28:54:642] nttwr: entry+
+[05-SEP-2012 15:28:54:642] ntt2err: entry+
+[05-SEP-2012 15:28:54:642] ntt2err: soc 424 error - operation=6, ntresnt[0]=530, ntresnt[1]=54, ntresnt[2]=0+
+[05-SEP-2012 15:28:54:642] ntt2err: exit+
+[05-SEP-2012 15:28:54:642] nttwr: exit+
+[05-SEP-2012 15:28:54:642] nspsend: 0 bytes to transport+
+[05-SEP-2012 15:28:54:642] nspsend: transport write error+
+[05-SEP-2012 15:28:54:642] nspsend: error exit+
+[05-SEP-2012 15:28:54:642] nserror: entry+
+[05-SEP-2012 15:28:54:642] nserror: nsres: id=0, op=67, ns=12571, ns2=12560; nt[0]=530, nt[1]=54, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0+
+[05-SEP-2012 15:28:54:642] nsdofls: exit (-1)+
+[05-SEP-2012 15:28:54:643] nsdo: nsctxrnk=0+
+[05-SEP-2012 15:28:54:643] nsdo: error exit+
+[05-SEP-2012 15:28:54:643] nioqsn: send failed: bl = 184, nicbl = 255+
+[05-SEP-2012 15:28:54:643] nioqper: error from nioqsn+
+[05-SEP-2012 15:28:54:643] nioqper: ns main err code: 12571+
+[05-SEP-2012 15:28:54:643] nioqper: ns (2) err code: 12560+
+[05-SEP-2012 15:28:54:643] nioqper: nt main err code: 530+
+[05-SEP-2012 15:28:54:643] nioqper: nt (2) err code: 54+
+[05-SEP-2012 15:28:54:643] nioqper: nt OS err code: 0+
+[05-SEP-2012 15:28:54:643] nioqer: entry+
+[05-SEP-2012 15:28:54:643] nioqer: incoming err = 12150+
+[05-SEP-2012 15:28:54:643] niomapnserror: entry+
+[05-SEP-2012 15:28:54:643] niqme: entry+
+[05-SEP-2012 15:28:54:643] niqme: reporting NS-12571 error as ORA-12571+
+[05-SEP-2012 15:28:54:643] niqme: exit+
+[05-SEP-2012 15:28:54:643] niomapnserror: exit+
+[05-SEP-2012 15:28:54:643] nioqce: entry+
+[05-SEP-2012 15:28:54:643] nioqce: exit+
+[05-SEP-2012 15:28:54:643] nioqer: returning err = 12571+
+[05-SEP-2012 15:28:54:643] nioqer: exit+
+[05-SEP-2012 15:28:54:643] nioqsn: returning error: 12571+
+[05-SEP-2012 15:28:54:643] nioqsn: exit+
+[05-SEP-2012 15:28:54:643] nioqrs: entry+
+[05-SEP-2012 15:28:54:643] nioqrs: state = interrupted (1)+
+[05-SEP-2012 15:28:54:643] nioqsm: entry+
+[05-SEP-2012 15:28:54:643] nioqsm: Sending break packet (1)...+
+[05-SEP-2012 15:28:54:643] nsdo: entry+
+[05-SEP-2012 15:28:54:643] nsdo: cid=0, opcode=67, bl=1, what=17, uflgs=0x100, cflgs=0x3+
+[05-SEP-2012 15:28:54:643] nsdo: rank=64, nsctxrnk=0+
+[05-SEP-2012 15:28:54:643] nsdo: nsctx: state=8, flg=0x400d, mvd=0+
+[05-SEP-2012 15:28:54:643] nsdo: gtn=127, gtc=127, ptn=10, ptc=2011+
+[05-SEP-2012 15:28:54:643] nsdofls: entry+
+[05-SEP-2012 15:28:54:643] nsdofls: DATA flags: 0x0+
+[05-SEP-2012 15:28:54:643] nsdofls: normal exit+
+[05-SEP-2012 15:28:54:643] nsdo: sending NSPTMK packet+
+[05-SEP-2012 15:28:54:643] nspsend: entry+
+[05-SEP-2012 15:28:54:643] nspsend: plen=11, type=12+
+[05-SEP-2012 15:28:54:643] nttwr: entry+
+[05-SEP-2012 15:28:54:643] ntt2err: entry+
+[05-SEP-2012 15:28:54:643] ntt2err: soc 424 error - operation=6, ntresnt[0]=530, ntresnt[1]=54, ntresnt[2]=0+
+[05-SEP-2012 15:28:54:643] ntt2err: exit+
+[05-SEP-2012 15:28:54:643] nttwr: exit+
+[05-SEP-2012 15:28:54:643] nspsend: 0 bytes to transport+
+[05-SEP-2012 15:28:54:643] nspsend: transport write error+
+[05-SEP-2012 15:28:54:643] nspsend: error exit+
+[05-SEP-2012 15:28:54:643] nsdo: error sending NSPTMK packet+
+[05-SEP-2012 15:28:54:643] nserror: entry+
+[05-SEP-2012 15:28:54:643] nserror: nsres: id=0, op=67, ns=12571, ns2=12560; nt[0]=530, nt[1]=54, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0+
+[05-SEP-2012 15:28:54:643] nsdo: nsctxrnk=0+
+[05-SEP-2012 15:28:54:643] nsdo: error exit+
+[05-SEP-2012 15:28:54:643] nioqsm: send-break: failed to send break...+
+[05-SEP-2012 15:28:54:643] nioqper: error from send-marker+
+[05-SEP-2012 15:28:54:643] nioqper: ns main err code: 12571+
+[05-SEP-2012 15:28:54:643] nioqper: ns (2) err code: 12560+
+[05-SEP-2012 15:28:54:643] nioqper: nt main err code: 530+
+[05-SEP-2012 15:28:54:643] nioqper: nt (2) err code: 54+
+[05-SEP-2012 15:28:54:643] nioqper: nt OS err code: 0+
+[05-SEP-2012 15:28:54:643] nioqsm: exit+
+[05-SEP-2012 15:28:54:643] nioqer: entry+
+[05-SEP-2012 15:28:54:643] nioqer: incoming err = 12152+
+[05-SEP-2012 15:28:54:643] niomapnserror: entry+
+[05-SEP-2012 15:28:54:643] niqme: entry+
+[05-SEP-2012 15:28:54:643] niqme: reporting NS-12571 error as ORA-12571+
+[05-SEP-2012 15:28:54:643] niqme: exit+
+[05-SEP-2012 15:28:54:643] niomapnserror: exit+
+[05-SEP-2012 15:28:54:643] nioqce: entry+
+[05-SEP-2012 15:28:54:643] nioqce: exit+
+[05-SEP-2012 15:28:54:643] nioqer: returning err = 12571+
+[05-SEP-2012 15:28:54:643] nioqer: exit+
+[05-SEP-2012 15:28:54:643] nioqrs: nioqrs: Couldn't send break. returning 12571+
+[05-SEP-2012 15:28:54:643] nioqrs: exit+
+[05-SEP-2012 15:28:54:643] nioqds: entry+
+[05-SEP-2012 15:28:54:643] nioqds: disconnecting...+
+[05-SEP-2012 15:28:54:644] nsclose: entry+
+[05-SEP-2012 15:28:54:644] nstimarmed: entry+
....................................................................
....................................................................

We haven't got any problem compiling any other function or source code from windows client. This is the largest function database.

Could be a problem related to firewall configuration???

Any help would be appreciated.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 5 2012

Added on Sep 5 2012

#general-database-discussions

6 comments

739 views