Hi, all,

I have a C++ application that connecting to a Oracle9i RAC (two nodes) system running on Linux IA64 platform, the version of DB is 9.2.0.5.0. Each time the application gets a request from client, it opens a connection to the DB and insert/update/delete data and then close this connection. This application gets many requests each day. In the log files of this application, we found the following Oracle errors:

ORA-12539: TNS:buffer or under-flow
ORA-12630: Native service operation not supported

It happens several times per day, it happens exactly before the application tries to connect the DB.

I checked the server side trace files under udump directory; listener.log file, nothing is special there at the time this problem happened; then I turn on the client side tracing by adding the following entries to sqlnet.ora of the client machine:

TRACE_LEVEL_CLIENT=16
TRACE_DIRECTORY_CLIENT=c:\temp
TRACE_FILE_CLIENT=client_trace.trc

Here is the part of the sqlnet trace files that caught these errors:

(2824) [000001 13-APR-2005 15:24:23:120] nscon: got NSPTRD packet
(2824) [000001 13-APR-2005 15:24:23:120] nsmal: entry
(2824) [000001 13-APR-2005 15:24:23:120] nsmal: 524 bytes at 0x13f1bc8
(2824) [000001 13-APR-2005 15:24:23:120] nsmal: normal exit
(2824) [000001 13-APR-2005 15:24:23:120] nscon: recving connect data
(2824) [000001 13-APR-2005 15:24:23:120] nsdo: entry
(2824) [000001 13-APR-2005 15:24:23:120] nsdo: cid=0, opcode=68, *bl=524, *what=1, uflgs=0x4001, cflgs=0x0
(2824) [000001 13-APR-2005 15:24:23:120] nsdo: nsctx: state=2, flg=0x804205, mvd=0
(2824) [000001 13-APR-2005 15:24:23:120] nsdo: gtn=10, gtc=10, ptn=10, ptc=2047
(2824) [000001 13-APR-2005 15:24:23:120] nsrdr: entry
(2824) [000001 13-APR-2005 15:24:23:120] nsrdr: recving a packet
(2824) [000001 13-APR-2005 15:24:23:120] nsprecv: entry
(2824) [000001 13-APR-2005 15:24:23:120] nsprecv: 534 bytes from leftover
(2824) [000001 13-APR-2005 15:24:23:120] nsprecv: tlen=534, plen=534, type=6
(2824) [000001 13-APR-2005 15:24:23:120] nsprecv: packet dump

...

(2824) [000001 13-APR-2005 15:24:23:120] nsprecv: normal exit
(2824) [000001 13-APR-2005 15:24:23:120] nsrdr: got NSPTDA packet
(2824) [000001 13-APR-2005 15:24:23:120] nsrdr: NSPTDA flags: 0x40
(2824) [000001 13-APR-2005 15:24:23:120] nsrdr: normal exit
(2824) [000001 13-APR-2005 15:24:23:120] nsdo: *what=1, *bl=524
(2824) [000001 13-APR-2005 15:24:23:120] nsdo: 524 bytes from NS buffer
(2824) [000001 13-APR-2005 15:24:23:120] nsdo: normal exit
(2824) [000001 13-APR-2005 15:24:23:120] nscon: got 524 bytes connect data
(2824) [000001 13-APR-2005 15:24:23:120] nsmfr: entry
(2824) [000001 13-APR-2005 15:24:23:120] nsmfr: 524 bytes at 0x13f1bc8
(2824) [000001 13-APR-2005 15:24:23:120] nsmfr: normal exit
(2824) [000001 13-APR-2005 15:24:23:120] nscon: connect data overflow
(2824) [000001 13-APR-2005 15:24:23:120] nserror: entry
(2824) [000001 13-APR-2005 15:24:23:120] 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
(2824) [000001 13-APR-2005 15:24:23:120] nscon: error exit
(2824) [000001 13-APR-2005 15:24:23:120] snsbitts_ts: entry
(2824) [000001 13-APR-2005 15:24:23:120] snsbitts_ts: acquired the bit
(2824) [000001 13-APR-2005 15:24:23:120] snsbitts_ts: normal exit
(2824) [000001 13-APR-2005 15:24:23:120] nsdo: nsctxrnk=0
(2824) [000001 13-APR-2005 15:24:23:120] snsbitcl_ts: entry
(2824) [000001 13-APR-2005 15:24:23:120] snsbitcl_ts: normal exit
(2824) [000001 13-APR-2005 15:24:23:120] nsdo: error exit
(2824) [000001 13-APR-2005 15:24:23:120] nscall: unexpected response