Hello..
i have MS com+ objects which are calling stored procedures simultaneously and rapidly and intermittently getting ORA-12560 TNS Protocol Adapter error. with 8.1.7.4.0 on Sun Solaris. here is a snippset of trace log..
please give me comments to solve this problem
================================================== =======
(6600) nigini: entry
(6600) nigini: Count in NI global area now: 1
(6600) nigini: Count in NI global area now: 1
(6600) nrigbi: entry
(6600) nrigbni: entry
(6600) nrigbni: Unable to get data from navigation file tnsnav.ora
(6600) nrigbni: exit
(6600) nrigbi: exit
(6600) nigini: exit
(6600) niqname: Hst is already an NVstring.
(6600) niqname: Inserting CID.
(6600) niotns: entry
(6600) niotns: niotns: setting up interrupt handler...
(6600) snsbitini_ts: entry
(6600) snsbitini_ts: normal exit
(6600) snsbitcl_ts: entry
(6600) snsbitcl_ts: normal exit
(6600) snsbitini_ts: entry
(6600) snsbitini_ts: normal exit
(6600) niotns: Not trying to enable dead connection detection.
(6600) niotns: Calling address: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) (HOST=192.168.99.117)(PORT=1521)))(CONNECT_DATA=(S ID=ESCROW0)(SERVICE_NAME=ESCROW0)(CID=(PROGRAM=C:\ WINNT\system32\dllhost.exe)(HOST=MATDEV)(USER=Admi nistrator))))
(6600) nscall: entry
(6600) nsmal: entry
(6600) nsmal: 164 bytes at 0x319fba8
(6600) nsmal: normal exit
(6600) nscall: connecting...
(6600) nladini: entry
(6600) nladini: exit
(6600) nladget: entry
(6600) nladget: exit
(6600) nsc2addr: entry
(6600) nttbnd2addr: entry
(6600) nttgetport: entry
(6600) nttgetport: port resolved to 1521
(6600) nttgetport: exit
(6600) nttbnd2addr: using host IP address: 192.168.99.117
(6600) nttbnd2addr: exit
(6600) nsc2addr: normal exit
(6600) nsopen: entry
(6600) nsmal: entry
(6600) nsmal: 492 bytes at 0x3197008
(6600) nsmal: normal exit
(6600) nsopenmplx: entry
(6600) nsmal: entry
(6600) nsmal: 2348 bytes at 0x3194f30
(6600) nsmal: normal exit
(6600) snsbitini_ts: entry
(6600) snsbitini_ts: normal exit
(6600) snsbitts_ts: entry
(6600) snsbitts_ts: acquired the bit
(6600) snsbitts_ts: normal exit
(6600) snsbitcl_ts: entry
(6600) snsbitcl_ts: normal exit
(6600) nsopenmplx: normal exit
(6600) nsopen: opening transport...
(6600) nttcon: entry
(6600) nttcon: toc = 1
(6600) nttcnp: entry
(6600) ntvlin: entry
(6600) ntvllt: entry
(6600) ntvllt: tcp.validnode_checking not turned on
(6600) ntvllt: exit
(6600) ntvlin: exit
(6600) nttcnp: Validnode Table IN use; err 0x0
(6600) nttcnp: creating a socket.
(6600) nttcnp: exit
(6600) nttcni: entry
(6600) nttcni: trying to connect to socket 10093.
(6600) ntt2err: entry
(6600) ntt2err: soc 10093 error - operation=1, ntresnt[0]=530, ntresnt[1]=93, ntresnt[2]=0
(6600) ntt2err: exit
(6600) nttcni: exit
(6600) nttcon: exit
(6600) nserror: entry
(6600) nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=530, nt[1]=93, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
(6600) snsbitts_ts: entry
(6600) snsbitts_ts: acquired the bit
(6600) snsbitts_ts: normal exit
(6600) snsbitcl_ts: entry
(6600) snsbitcl_ts: normal exit
(6600) nsopen: unable to open transport
(6600) snsbitts_ts: entry
(6600) snsbitts_ts: acquired the bit
(6600) snsbitts_ts: normal exit
(6600) snsbitcl_ts: entry
(6600) snsbitcl_ts: normal exit
(6600) snsbittrm_ts: entry
(6600) snsbittrm_ts: normal exit
(6600) snsbitts_ts: entry
(6600) snsbitts_ts: acquired the bit
(6600) snsbitts_ts: normal exit
(6600) snsbitcl_ts: entry
(6600) snsbitcl_ts: normal exit
(6600) nsbfr: entry
(6600) nsbfr: normal exit
(6600) nsbfr: entry
(6600) nsbfr: normal exit
(6600) nsmfr: entry
(6600) nsmfr: 2348 bytes at 0x3194f30
(6600) nsmfr: normal exit
(6600) nsmfr: entry
(6600) nsmfr: 492 bytes at 0x3197008
(6600) nsmfr: normal exit
(6600) nsopen: error exit
(6600) nsclose: entry
(6600) nsclose: normal exit
(6600) nladget: entry
(6600) nladget: exit
(6600) nsmfr: entry
(6600) nsmfr: 164 bytes at 0x319fba8
(6600) nsmfr: normal exit
(6600) nladtrm: entry
(6600) nladtrm: exit
(6600) nscall: error exit
(6600) nioqper: error from nscall
(6600) nioqper: nr err code: 0
(6600) nioqper: ns main err code: 12560
(6600) nioqper: ns (2) err code: 0
(6600) nioqper: nt main err code: 530
(6600) nioqper: nt (2) err code: 93
(6600) nioqper: nt OS err code: 0
(6600) niomapnserror: entry
(6600) niqme: entry
(6600) niqme: reporting NS-12560 error as ORA-12560
(6600) niqme: exit
(6600) niomapnserror: returning error 12560
(6600) niomapnserror: exit
(6600) niotns: Couldn't connect, returning 12560
(6600) niotns: exit
(6600) snsbittrm_ts: entry
(6600) snsbittrm_ts: normal exit
(6600) snsbittrm_ts: entry
(6600) snsbittrm_ts: normal exit
(6600) nsbfrfl: entry
(6600) nsbfrfl: normal exit
(6600) nigtrm: Count in the NI global area is now 0
(6600) nrigbd: entry
(6600) nrigbd: exit
(6600) nigtrm: Count in the NL global area is now 0
thanks in advance
yahoo : pchanjo