ORA-12560
Hi,
I'm getting sporadic (2-4 times a day) ORA-12560 errors on an Oracle connections between Windows 2000 clients and an Oracle cluster (also Windows 2000 / Oracle 8.1.7.3.0). I turned on SQLNet tracing and after capturing a couple of these errors suspect that the reason for the errors may be network problems.
Could you please take a look at the attached extract of a trace file, and let me know if my assumption of a network error makes sense? Also, are there Oracle tools or tracing options to further narrow down where exactly these problems might happen?
Thanks!
Ingo
snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit
snsbitcl_ts: entry
snsbitcl_ts: normal exit
nsdo: what=1, bl=2037
snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit
nsdo: nsctxrnk=0
snsbitcl_ts: entry
snsbitcl_ts: normal exit
nsdo: normal exit
nioqrc: exit
ntt2err: entry
ntt2err: soc 1228 error - operation=5, ntresnt[0]=517, ntresnt[1]=54, ntresnt[2]=0
ntt2err: exit
nttrd: exit
nsprecv: transport read error
nsprecv: error exit
nserror: entry
nserror: nsres: id=0, op=68, ns=12547, ns2=12560; nt[0]=517, nt[1]=54, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit
snsbitcl_ts: entry
snsbitcl_ts: normal exit
nsrdr: error exit
snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit
snsbitcl_ts: entry
snsbitcl_ts: normal exit
snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit
nsdo: nsctxrnk=0
snsbitcl_ts: entry
snsbitcl_ts: normal exit
nsdo: error exit
nioqrc: wanted 1 got 0, type 0
nioqper: error from nioqrc
nioqper: nr err code: 0
nioqper: ns main err code: 12547
nioqper: ns (2) err code: 12560
nioqper: nt main err code: 517
nioqper: nt (2) err code: 54
nioqper: nt OS err code: 0
nioqer: entry
nioqer: incoming err = 12151
nioqce: entry
nioqce: exit
nioqer: returning err = 3113
nioqer: exit
nioqrc: exit
nioqbr: entry
nioqbr: state = normal (0)
nioqsm: entry
nioqsm: Sending break packet (1)...
nsdo: entry
nsdo: cid=0, opcode=67, bl=1, what=17, uflgs=0x100, cflgs=0x3
snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit
nsdo: rank=64, nsctxrnk=0
snsbitcl_ts: entry
snsbitcl_ts: normal exit
nsdo: nsctx: state=1, flg=0x420d, mvd=0
snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit
nsdo: nsctxrnk=0
snsbitcl_ts: entry
snsbitcl_ts: normal exit
nsdo: error exit
nioqsm: send-break: failed to send break...
nioqper: error from send-marker
nioqper: nr err code: 0
nioqper: ns main err code: 12583
nioqper: ns (2) err code: 0
nioqper: nt main err code: 0
nioqper: nt (2) err code: 0
nioqper: nt OS err code: 0
nioqsm: exit
nioqer: entry
nioqer: incoming err = 12152
nioqce: entry
nioqce: exit
nioqer: returning err = 3113
nioqer: exit
nioqbr: returning 3113
nioqbr: exit
nioqds: entry
nioqds: disconnecting...
nsdisc: entry
nsclose: entry
nstimarmed: entry
nstimarmed: no timer allocated
nstimarmed: normal exit
nsdo: entry
nsdo: cid=0, opcode=66, bl=0, what=0, uflgs=0x0, cflgs=0x2
snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit
nsdo: rank=64, nsctxrnk=0
snsbitcl_ts: entry
snsbitcl_ts: normal exit
nsdo: nsctx: state=1, flg=0x4209, mvd=0
nsdo: entry
nsdo: cid=0, opcode=67, bl=0, what=1, uflgs=0x0, cflgs=0x1
nsdo: nsctx: state=1, flg=0x4209, mvd=0
nsdo: error exit
nsbfr: entry
nsbaddfl: entry
nsbaddfl: normal exit
nsbfr: normal exit
nsbfr: entry
nsbaddfl: entry
nsbaddfl: normal exit
nsbfr: normal exit
snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit
nsdo: nsctxrnk=0
nsdo: normal exit
snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit
snsbitcl_ts: entry
snsbitcl_ts: normal exit
nsclose: closing transport
nttdisc: entry
nttdisc: Closed socket 1228
nttdisc: exit
snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit
snsbittrm_ts: entry
snsbittrm_ts: normal exit
snsbitcl_ts: entry
snsbitcl_ts: normal exit
nsclose: global context check-out (from slot 0) complete
nsnadisc: entry
nadisc: entry
nacomtm: entry
nacompd: entry
nacompd: exit
nacompd: entry
nacompd: exit
nacomtm: exit
nas_dis: entry
nas_dis: exit
nau_dis: entry
nau_dis: exit
naeetrm: entry
naeetrm: exit
naectrm: entry
naectrm: exit
nagbltrm: entry
nagbltrm: exit
nadisc: exit
nsnadisc: normal exit
snsbittrm_ts: entry
snsbittrm_ts: normal exit
snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit
snsbitcl_ts: entry
snsbitcl_ts: normal exit
nsbfr: entry
nsbaddfl: entry
nsbaddfl: normal exit
nsbfr: normal exit
nsmfr: entry
nsmfr: 1712 bytes at 0x92d30d8
nsmfr: normal exit
nsmfr: entry
nsmfr: 198 bytes at 0x92c8ee8
nsmfr: normal exit
nsmfr: entry
nsmfr: 140 bytes at 0x92d42f8
nsmfr: normal exit
nladtrm: entry
nladtrm: exit
nsmfr: entry
nsmfr: 420 bytes at 0x92d2f20
nsmfr: normal exit
nsclose: normal exit
nsdisc: exit (0)
nioqds: exit
nsbfree: entry
nsbaddfl: entry
nsbaddfl: normal exit
nsbfree: normal exit
nsbfree: entry
nsbaddfl: entry
nsbaddfl: normal exit
nsbfree: normal exit
nigtrm: Count in the NI global area is now 3
snsbittrm_ts: entry
snsbittrm_ts: normal exit
snsbittrm_ts: entry
snsbittrm_ts: normal exit
nsbfrfl: entry
nsbrfr: entry
nsbrfr: nsbfs at 0x92d1bb8, data at 0x92ce5f8.
nsbrfr: normal exit
nsbrfr: entry
nsbrfr: nsbfs at 0x92d1b38, data at 0x92cd5a8.
nsbrfr: normal exit
nsbrfr: entry
nsbrfr: nsbfs at 0x92d3e90, data at 0x92cddd0.
nsbrfr: normal exit
nsbrfr: entry
nsbrfr: nsbfs at 0x92d3ec8, data at 0x92ccd80.
nsbrfr: normal exit
nsbrfr: entry
nsbrfr: nsbfs at 0x92c8fc0, data at 0x92d1310.
nsbrfr: normal exit
nsbfrfl: normal exit
nigtrm: Count in the NL global area is now 3
nigini: entry
nigini: Count in NI global area now: 4
nigini: Count in NI global area now: 4
nigini: exit
niqname: Hst is already an NVstring.
niqname: Inserting CID.
niotns: entry
niotns: niotns: setting up interrupt handler...
snsbitini_ts: entry
snsbitini_ts: normal exit
snsbitcl_ts: entry
snsbitcl_ts: normal exit
snsbitini_ts: entry
snsbitini_ts: normal exit
niotns: Not trying to enable dead connection detection.
niotns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=d:\xxx\jdk\bin\java.exe)(HOST=xxx)(USER=xxx))))
nscall: entry
nsmal: entry
nsmal: 140 bytes at 0x92d42f8
nsmal: normal exit
nscall: connecting...
nladini: entry
nladini: exit
nladget: entry
nladget: exit
nsc2addr: entry
nlpcaini: entry
nlpcaini: prg =
nlpcaini: arg[0] =
nlpcaini: arg[1] =
nlpcaini: exit
nsc2addr: normal exit
nsopen: entry
nsmal: entry
nsmal: 420 bytes at 0x92d2f20
nsmal: normal exit
nsopenmplx: entry
nsmal: entry
nsmal: 1712 bytes at 0xd39cf78
nsmal: normal exit
snsbitini_ts: entry
snsbitini_ts: normal exit
snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit
snsbitcl_ts: entry
snsbitcl_ts: normal exit
nsopenmplx: normal exit
nsopen: opening transport...
ntpcon: entry
ntpcon: toc = 1
sntpcall: entry
snlpcss: entry
ntpcon: exit
nserror: entry
nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=530, nt[1]=126, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit
snsbitcl_ts: entry
snsbitcl_ts: normal exit
nsopen: unable to open transport
snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit
snsbittrm_ts: entry
snsbittrm_ts: normal exit
snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit
snsbitcl_ts: entry
snsbitcl_ts: normal exit
nsbfr: entry
nsbfr: normal exit
nsmfr: entry
nsmfr: 1712 bytes at 0xd39cf78
nsmfr: normal exit
snsbitcl_ts: entry
snsbitcl_ts: normal exit
nsmfr: entry
nsmfr: 420 bytes at 0x92d2f20
nsmfr: normal exit
nsopen: error exit
nsclose: entry
nsclose: normal exit
nladget: entry
nladget: exit
nsmfr: entry
nsmfr: 140 bytes at 0x92d42f8
nsmfr: normal exit
nladtrm: entry
nladtrm: exit
nscall: error exit
nioqper: error from nscall
nioqper: nr err code: 0
nioqper: ns main err code: 12560
nioqper: ns (2) err code: 0
nioqper: nt main err code: 530
nioqper: nt (2) err code: 126
nioqper: nt OS err code: 0
niomapnserror: entry
niqme: entry
niqme: reporting NS-12560 error as ORA-12560
niqme: exit
niomapnserror: returning error 12560
niomapnserror: exit
niotns: Couldn't connect, returning 12560
niotns: exit
snsbittrm_ts: entry
snsbittrm_ts: normal exit
snsbittrm_ts: entry
snsbittrm_ts: normal exit
nsbfrfl: entry
nsbfrfl: normal exit
nigtrm: Count in the NI global area is now 3
nigtrm: Count in the NL global area is now 3
ORA-12547: TNS:lost contact
Cause: Partner has unexpectedly gone away, usually during process start-up.
Action: Investigate partner application for abnormal termination. On an Interchange, this can happen if the machine is overloaded.
ORA-12560: TNS:protocol adapter error
Cause: A generic protocol adapter error occurred.
Action: Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors.For further details, turn on tracing and reexecute the operation. Turn off tracing when the operation is complete.
ORA-12152: TNS:unable to send break message
Cause: Unable to send break message. Connection probably disconnected.
Action: Re-establish connection. If the error is persistent, turn on tracing and reexecute the operation.