Re: ORA-12560 when testing connection in Net8 Assistant

From: Michael Helmich <michael.helmich_at_entory.com>
Date: 17 Jan 2003 01:07:20 -0800
Message-ID: <6dbfc615.0301170107.5d5e1b7d@posting.google.com>

I was just trying to keep my posting as short as possible, as it was going to be rather long because of the messages from sqlnet.log. I did not wish to withhold any useful information, so here is the output of the level 16 trace:

• TRACE CONFIGURATION INFORMATION FOLLOWS --- New trace stream is D:\Oracle\Ora81\network\tools\cli.trc New trace level is 16
• TRACE CONFIGURATION INFORMATION ENDS ---
• PARAMETER SOURCE INFORMATION FOLLOWS --- Attempted load of system pfile source D:\Oracle\Ora81\network\admin\sqlnet.ora Parameter source loaded successfully

Attempted load of local pfile source
D:\Oracle\Ora81\network\tools\sqlnet.ora Parameter source was not loaded

 -> PARAMETER TABLE LOAD RESULTS FOLLOW <- Successful parameter table load
 -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-   TRACE_LEVEL_CLIENT = 16
  NAMES.DIRECTORY_PATH = (TNSNAMES)
  SQLNET.CRYPTO_SEED = 4fhfguweotcadsfdsafjkdsfqp5f201p45mxskdlfdasf   SQLNET.AUTHENTICATION_SERVICES = (NTS)
--- PARAMETER SOURCE INFORMATION ENDS ---

• LOG CONFIGURATION INFORMATION FOLLOWS --- Log stream will be "D:\Oracle\Ora81\network\tools\sqlnet.log" Log stream validation not requested
• LOG CONFIGURATION INFORMATION ENDS ---

nigini: entry
nigini: Count in NI global area now: 1
nigini: Count in NI global area now: 1
nrigbi: entry
nrigbni: entry

nrigbni: Unable to get data from navigation file tnsnav.ora nrigbni: exit
nrigbi: exit
nigini: exit
niqname: Hst is already an NVstring.
niqname: Inserting CID.

niotns: entry
niotns: niotns: setting up interrupt handler...
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=C:\Programme\Oracle\jre\1.1.7\bin\jrew.exe)(HOST=KBZ00W015)(USER=mi_he)))) nscall: entry

nsmal: entry
nsmal: 140 bytes at 0x8a2de0
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: 428 bytes at 0x8ab100
nsmal: normal exit

nsopenmplx: entry

nsmal: entry
nsmal: 1712 bytes at 0x3df64c8
nsmal: 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
nsopen: unable to open transport

nsbfr: entry
nsbfr: normal exit
nsmfr: entry
nsmfr: 1712 bytes at 0x3df64c8
nsmfr: normal exit
nsmfr: entry
nsmfr: 428 bytes at 0x8ab100
nsmfr: normal exit

nsopen: error exit

nsclose: entry
nsclose: normal exit
nladget: entry
nladget: exit
nsmfr: entry

nsmfr: 140 bytes at 0x8a2de0
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
nsbfrfl: entry
nsbfrfl: normal exit
nigtrm: Count in the NI global area is now 0 nnfgdei: entry

nrigbd: entry
nrigbd: exit
nigtrm: Count in the NL global area is now 0

Regards
Michael Helmich Received on Fri Jan 17 2003 - 03:07:20 CST