ORA - 12537: TNS: Connection Closed error
726996Jul 27 2011 — edited Jul 28 2011Hi,
I am facing connection issue from an Oracle application (using OCI interface) to Oracle Database. Both Oracle client (on Solaris 64 sparcv9 platform) and server (on Windows 64 bit platform) are 11gR1.
The same application works fine when using Oracle 10g client connecting to same 11gR1 database. please provide your help.
Following is my tnsnames.ora entry
{
oeora11g1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.17.100)(PORT = 1521))
)
(CONNECT_DATA =
(service_name = orcl)
)
)
}
I have enabled the sqlnet.ora client trace, but i have no idea what is happening here.
Following is the excerpt from the client trace file.
{
[27-JUL-2011 08:21:18:011] nsdo: rank=64, nsctxrnk=0
[27-JUL-2011 08:21:18:011] nsdo: nsctx: state=14, flg=0x4005, mvd=0
[27-JUL-2011 08:21:18:012] nsdo: gtn=10, gtc=10, ptn=10, ptc=4059
[27-JUL-2011 08:21:18:012] nscon: entry
[27-JUL-2011 08:21:18:012] nscon: doing connect handshake...
[27-JUL-2011 08:21:18:012] nscon: recving a packet
[27-JUL-2011 08:21:18:012] nsprecv: entry
[27-JUL-2011 08:21:18:012] nsprecv: reading from transport...
[27-JUL-2011 08:21:18:012] nttrd: entry
[27-JUL-2011 08:22:18:013] nttrd: exit
[27-JUL-2011 08:22:18:013] ntt2err: entry
[27-JUL-2011 08:22:18:014] ntt2err: Read unexpected EOF ERROR on 12
[27-JUL-2011 08:22:18:014] ntt2err: exit
[27-JUL-2011 08:22:18:014] nsprecv: error exit
[27-JUL-2011 08:22:18:014] nserror: entry
[27-JUL-2011 08:22:18:014] nserror: nsres: id=0, op=68, ns=12537, ns2=12560; nt[0]=507, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
}
Similarly I enabled the lister log and listener trace and found following tracing information
{
[27-JUL-2011 08:21:17:959] nsopen: global context check-in (to slot 3) complete
[27-JUL-2011 08:21:17:959] nsopen: lcl[0]=0xf4ffefff, lcl[1]=0x12003, gbl[0]=0x7abf, gbl[1]=0x2001, tdu=32767, sdu=8192
[27-JUL-2011 08:21:17:959] nsfull_opn: entry
[27-JUL-2011 08:21:17:959] nsfull_opn: cid=3, opcode=65, bl=0, what=0, uflgs=0x0, cflgs=0x0
[27-JUL-2011 08:21:17:959] nsfull_opn: nsctx: state=7, flg=0x4000, mvd=0
[27-JUL-2011 08:21:17:959] nsbal: entry
[27-JUL-2011 08:21:17:959] nsbgetfl: entry
[27-JUL-2011 08:21:17:959] nsbgetfl: normal exit
[27-JUL-2011 08:21:17:959] nsbal: normal exit
[27-JUL-2011 08:21:17:959] nsbal: entry
[27-JUL-2011 08:21:17:959] nsbgetfl: entry
[27-JUL-2011 08:21:17:959] nsbgetfl: normal exit
[27-JUL-2011 08:21:17:959] nsbal: normal exit
[27-JUL-2011 08:21:17:959] nsfull_opn: normal exit
[27-JUL-2011 08:21:17:959] nsopen: normal exit
[27-JUL-2011 08:21:17:959] nsanswer: deferring connect attempt; at stage 5
[27-JUL-2011 08:21:17:959] nsanswer: normal exit
[27-JUL-2011 08:21:17:959] nsevreg: entry
[27-JUL-2011 08:21:17:959] nsevreg: begin registration process for 3
[27-JUL-2011 08:21:17:959] nsevregPrePost: entry
[27-JUL-2011 08:21:17:959] nsevregPrePost: normal exit
[27-JUL-2011 08:21:17:959] nsevreg: sgt=0, evn=4, evt[2]=0x0
[27-JUL-2011 08:21:17:959] nsevreg: begin notification process for 3
[27-JUL-2011 08:21:17:959] nsevregAffectNotif: entry
[27-JUL-2011 08:21:17:959] nsrah: entry
[27-JUL-2011 08:21:17:959] nsrah: setting transport read mode (2)
[27-JUL-2011 08:21:17:959] nttctl: entry
[27-JUL-2011 08:21:17:959] nttctl: Clearing non-blocking mode
[27-JUL-2011 08:21:17:959] nttctl: entry
[27-JUL-2011 08:21:17:959] nttctl: Setting connection into async mode
[27-JUL-2011 08:21:17:959] nsrah: normal exit
[27-JUL-2011 08:21:17:959] nsevregAffectNotif: exit (0)
[27-JUL-2011 08:21:17:959] nsevreg: rdm=2, sgt=0, evt[0]=0x20, [1]=0x20, [2]=0x0, nrg=0
[27-JUL-2011 08:21:17:959] nsevreg: registering for 0x20
[27-JUL-2011 08:21:17:959] nsiorasy: entry
[27-JUL-2011 08:21:17:959] nsiorecv: entry
[27-JUL-2011 08:21:17:959] nttmrd: entry
[27-JUL-2011 08:21:17:959] nttrd: entry
[27-JUL-2011 08:21:17:959] ntt2err: entry
[27-JUL-2011 08:21:17:959] ntt2err: soc 452 error - operation=5, ntresnt[0]=524, ntresnt[1]=997, ntresnt[2]=0
[27-JUL-2011 08:21:17:959] ntt2err: exit
[27-JUL-2011 08:21:17:959] nttrd: exit
[27-JUL-2011 08:21:17:959] nsiorecv: exit (0)
[27-JUL-2011 08:21:17:959] nsiorasy: exit (0)
[27-JUL-2011 08:21:17:959] nsiooverflow: entry
[27-JUL-2011 08:21:17:959] nsevreg: normal exit
[27-JUL-2011 08:21:17:959] nsglhe: exit
[27-JUL-2011 08:21:17:959] nsevwait: entry
[27-JUL-2011 08:21:17:959] nsevwait: 3 registered connection(s)
[27-JUL-2011 08:21:17:959] nsevwait: 0 pre-posted event(s)
[27-JUL-2011 08:21:17:959] nsevwait: waiting for transport event (0 thru 3)...
[27-JUL-2011 08:22:17:946] nsevwait: 0 newly-posted event(s)
[27-JUL-2011 08:22:17:946] nstoToqWalk: entry
[27-JUL-2011 08:22:17:946] nstoHandleEventTO: entry
[27-JUL-2011 08:22:17:946] nserror: entry
[27-JUL-2011 08:22:17:946] nserror: nsres: id=0, op=0, ns=12535, ns2=12606; nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[27-JUL-2011 08:22:17:946] nstoSetupTimeout: entry
[27-JUL-2011 08:22:17:946] nstoSetupTimeout: ATO enabled for ctx=0x0000000003268A00, val=60000(millisecs)
[27-JUL-2011 08:22:17:946] nstoUpdateActive: entry
[27-JUL-2011 08:22:17:946] nstoUpdateActive: Active timeout is 0 (see nstotyp)
[27-JUL-2011 08:22:17:946] nstoHandleEventTO: ATO occurred for ctx=0x0000000003268A00
[27-JUL-2011 08:22:17:946] nstoToqWalk: exit (0)
[27-JUL-2011 08:22:17:946] nsevwait: 1 posted event(s)
[27-JUL-2011 08:22:17:946] nsevwait: exit (0)
[27-JUL-2011 08:22:17:946] nsglhe: entry
}
Thanks.