-
ORA-12539 and ORA-12630 errors in SQLNET trace file
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|