ORA-12539: TNS:buffer over- or under-flow

This error was recived due to big NSPTCN packet size. I think this is a bug we have 11.1.0.7 Client. When NSPTRD packet is bigger than a NSPTCN packet and If NSPTRD packet size is over 532 byte, client received ORA-12539.

In our case PROGRAM was using big path and once it was shorten it got resolved. Here in trace I had removed/replaced some parts.


(47200) [000003 16-MAR-2012 13:40:09:063] nspsend: plen=414, type=6
(47200) [000003 16-MAR-2012 13:40:09:063] nttwr: entry
(47200) [000003 16-MAR-2012 13:40:09:063] nttwr: socket 2392 had bytes written=414
(47200) [000003 16-MAR-2012 13:40:09:063] nttwr: exit
(47200) [000003 16-MAR-2012 13:40:09:063] nspsend: packet dump
(47200) [000003 16-MAR-2012 13:40:09:063] nspsend: 01 9E 00 00 06 00 00 00  |........|
(47200) [000003 16-MAR-2012 13:40:09:063] nspsend: 00 00 28 44 45 53 43 52  |..(DESCR|
(47200) [000003 16-MAR-2012 13:40:09:063] nspsend: 49 50 54 49 4F 4E 3D 28  |IPTION=(|
(47200) [000003 16-MAR-2012 13:40:09:063] nspsend: 41 44 44 52 45 53 53 3D  |ADDRESS=|
(47200) [000003 16-MAR-2012 13:40:09:063] nspsend: 28 50 52 4F 54 4F 43 4F  |(PROTOCO|
(47200) [000003 16-MAR-2012 13:40:09:063] nspsend: 4C 3D 54 43 50 29 28 48  |L=TCP)(H|
(47200) [000003 16-MAR-2012 13:40:09:063] nspsend: 4F 53 54 3D 75 74 78 67  |OST=XXXX|
(47200) [000003 16-MAR-2012 13:40:09:063] nspsend: 72 61 6E 72 61 63 75 30  |XXXXXXXX|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 34 2D 76 69 70 2E 74 78  |XXXXXXXX|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 2E 65 70 73 69 6C 6F 6E  |XXXXXXXX|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 2E 63 6F 6D 29 28 50 4F  |XXXX)(PO|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 52 54 3D 31 35 32 32 29  |RT=XXXX)|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 29 28 4C 4F 41 44 5F 42  |)(LOAD_B|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 41 4C 41 4E 43 45 3D 79  |ALANCE=y|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 65 73 29 28 43 4F 4E 4E  |es)(CONN|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 45 43 54 5F 44 41 54 41  |ECT_DATA|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 3D 28 53 45 52 56 45 52  |=(SERVER|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 3D 44 45 44 49 43 41 54  |=DEDICAT|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 45 44 29 28 53 45 52 56  |ED)(SERV|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 49 43 45 5F 4E 41 4D 45  |ICE_NAME|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 3D 55 31 47 52 41 4E 5F  |=XXXXXXX|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 47 43 5F 53 45 52 56 49  |XXXXXXXX|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 43 45 29 28 46 41 49 4C  |XX)(FAIL|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 4F 56 45 52 5F 4D 4F 44  |OVER_MOD|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 45 3D 28 54 59 50 45 3D  |E=(TYPE=|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 53 45 4C 45 43 54 29 28  |SELECT)(|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 4D 45 54 48 4F 44 3D 42  |METHOD=B|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 41 53 49 43 29 28 52 45  |ASIC)(RE|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 54 52 49 45 53 3D 33 30  |TRIES=30|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 29 28 44 45 4C 41 59 3D  |)(DELAY=|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 35 29 29 28 43 49 44 3D  |5))(CID=|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 28 50 52 4F 47 52 41 4D  |(PROGRAM|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 3D 43 3A 5C 53 4D 61 6E  |=XXXXXXX|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 64 69 67 61 5C 73 72 63  |XXXXXXXX|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 5C 47 72 61 6E 64 43 65  |XXXXXXXX|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 6E 74 72 61 6C 5C 47 43  |XXXXXXXX|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 5F 52 6F 6F 74 5C 44 65  |XXXXXXXX|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 76 5C 50 43 6F 6E 66 69  |XXXXXXXX|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 67 5F 76 4E 65 78 74 5C  |XXXXXXXX|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 42 61 74 63 68 5C 41 75  |XXXXXXXX|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 74 6F 42 61 74 63 68 50  |XXXXXXXX|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 72 6F 63 65 73 73 6F 72  |XXXXXXXX|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 5C 62 69 6E 5C 44 65 62  |XXXXXXXX|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 75 67 5C 41 75 74 6F 42  |XXXXXXXX|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 61 74 63 68 50 72 6F 63  |XXXXXXXX|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 65 73 73 6F 72 2E 76 73  |XXXXXXXX|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 68 6F 73 74 2E 65 78 65  |XXXXXXXX|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 29 28 48 4F 53 54 3D 57  |)(HOST=X|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 54 58 45 50 53 49 44 45  |XXXXXXXX|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 56 34 36 29 28 55 53 45  |XXX)(USE|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 52 3D 73 6D 61 6E 64 69  |R=yyyyyy|
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 67 61 29 29 29 29        |yy))))  |
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: 414 bytes to transport
(47200) [000003 16-MAR-2012 13:40:09:064] nspsend: normal exit
(47200) [000003 16-MAR-2012 13:40:09:064] nsdofls: exit (0)
(47200) [000003 16-MAR-2012 13:40:09:064] nsdoacts: flushing transport
(47200) [000003 16-MAR-2012 13:40:09:064] nttctl: entry
(47200) [000003 16-MAR-2012 13:40:09:064] nsdoacts: normal exit
(47200) [000003 16-MAR-2012 13:40:09:064] nsdo: normal exit
(47200) [000003 16-MAR-2012 13:40:09:064] nscon: exit (0)
(47200) [000003 16-MAR-2012 13:40:09:064] snsbitts_ts: entry
(47200) [000003 16-MAR-2012 13:40:09:064] snsbitts_ts: acquired the bit
(47200) [000003 16-MAR-2012 13:40:09:064] snsbitts_ts: normal exit
(47200) [000003 16-MAR-2012 13:40:09:064] nsdo: nsctxrnk=0
(47200) [000003 16-MAR-2012 13:40:09:064] snsbitcl_ts: entry
(47200) [000003 16-MAR-2012 13:40:09:064] snsbitcl_ts: normal exit
(47200) [000003 16-MAR-2012 13:40:09:064] nsdo: normal exit
(47200) [000003 16-MAR-2012 13:40:09:064] nsdo: entry
(47200) [000003 16-MAR-2012 13:40:09:064] nsdo: cid=0, opcode=68, *bl=512, *what=9, uflgs=0x0, cflgs=0x3
(47200) [000003 16-MAR-2012 13:40:09:064] snsbitts_ts: entry
(47200) [000003 16-MAR-2012 13:40:09:064] snsbitts_ts: acquired the bit
(47200) [000003 16-MAR-2012 13:40:09:064] snsbitts_ts: normal exit
(47200) [000003 16-MAR-2012 13:40:09:064] nsdo: rank=64, nsctxrnk=0
(47200) [000003 16-MAR-2012 13:40:09:064] snsbitcl_ts: entry
(47200) [000003 16-MAR-2012 13:40:09:064] snsbitcl_ts: normal exit
(47200) [000003 16-MAR-2012 13:40:09:064] nsdo: nsctx: state=2, flg=0x4005, mvd=0
(47200) [000003 16-MAR-2012 13:40:09:064] nsdo: gtn=10, gtc=10, ptn=10, ptc=8155
(47200) [000003 16-MAR-2012 13:40:09:064] nscon: entry
(47200) [000003 16-MAR-2012 13:40:09:064] nscon: recving a packet
(47200) [000003 16-MAR-2012 13:40:09:064] nsprecv: entry
(47200) [000003 16-MAR-2012 13:40:09:064] nsprecv: reading from transport...
(47200) [000003 16-MAR-2012 13:40:09:064] nttrd: entry
(47200) [000003 16-MAR-2012 13:40:09:064] nttrd: socket 2392 had bytes read=536
(47200) [000003 16-MAR-2012 13:40:09:064] nttrd: exit
(47200) [000003 16-MAR-2012 13:40:09:064] nsprecv: 536 bytes from transport
(47200) [000003 16-MAR-2012 13:40:09:064] nsprecv: tlen=536, plen=10, type=5
(47200) [000003 16-MAR-2012 13:40:09:064] nsprecv: 526 bytes to leftover
(47200) [000003 16-MAR-2012 13:40:09:064] nsprecv: packet dump
(47200) [000003 16-MAR-2012 13:40:09:064] nsprecv: 00 0A 00 00 05 02 00 00  |........|
(47200) [000003 16-MAR-2012 13:40:09:064] nsprecv: 02 04                    |..      |
(47200) [000003 16-MAR-2012 13:40:09:064] nsprecv: normal exit
(47200) [000003 16-MAR-2012 13:40:09:064] nscon: got NSPTRD packet
(47200) [000003 16-MAR-2012 13:40:09:064] nscon: connect data overflow
(47200) [000003 16-MAR-2012 13:40:09:064] nserror: entry
(47200) [000003 16-MAR-2012 13:40:09:064] nserror: nsres: id=0, op=77, ns=12539, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
(47200) [000003 16-MAR-2012 13:40:09:064] nscon: error exit
(47200) [000003 16-MAR-2012 13:40:09:064] snsbitts_ts: entry
(47200) [000003 16-MAR-2012 13:40:09:064] snsbitts_ts: acquired the bit
(47200) [000003 16-MAR-2012 13:40:09:064] snsbitts_ts: normal exit
(47200) [000003 16-MAR-2012 13:40:09:064] nsdo: nsctxrnk=0
(47200) [000003 16-MAR-2012 13:40:09:064] snsbitcl_ts: entry
(47200) [000003 16-MAR-2012 13:40:09:064] snsbitcl_ts: normal exit
(47200) [000003 16-MAR-2012 13:40:09:064] nsdo: error exit

About these ads

About Taral
I am Rookie to Oracle Technology so let's see where it goes

2 Responses to ORA-12539: TNS:buffer over- or under-flow

  1. Mike says:

    Wonderful post! We have exactly the same problem here and your investigation saved us days and days of work!
    Mike

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: