Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2003
    Location
    South Korea
    Posts
    5

    Unhappy Unanswered: Help!! internmittently getting ORA-12560. Here is a snipset..

    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
    Last edited by upward; 06-15-04 at 22:28. Reason: Syntax Correction

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •