Welcome to the dBforums forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact support.

If you prefer not to see double-underlined words and corresponding ads, place your cursor
here for ContentLink opt out.

Go Back  dBforums > Database Server Software > Oracle > Help!! internmittently getting ORA-12560. Here is a snipset..

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-15-04, 22:25
upward upward is offline
Registered User
 
Join Date: Sep 2003
Location: South Korea
Posts: 5
Unhappy 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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On