Insight into SQLnet Tracefile

From: Greg Akins <insomnia_at_cvzoom.net>
Date: Mon, 4 Nov 2002 15:19:54 -0500
Message-ID: <3dc6cf97@post.usenet.com>

• Post for FREE via your newsreader at post.usenet.com ****

Can anyone give me an idea what's going on in this Tracefile? I highlighted with '*'s the area that I think is causing my tns-12154 error.

Any help would be greatly appreciated.

• TRACE CONFIGURATION INFORMATION FOLLOWS --- New trace stream is d:\sqlnet.log New trace level is 6
• 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 C:\WINNT\SYSTEM32\sqlnet.ora Parameter source was not loaded

 -> PARAMETER TABLE LOAD RESULTS FOLLOW <- Successful parameter table load
 -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-   SQLNET.EXPIRE_TIME = 10
  NAME.DEFAULT_ZONE = ami.alcoa.com
  AUTOMATIC_IPC = OFF
  TRACE_LEVEL_CLIENT = ADMIN
  NAMES.PREFERRED_SERVERS = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(Host = onames.ami.alcoa.com) (Port = 1580)) (ADDRESS = (PROTOCOL = TCP)
(Host = onames1.ami.alcoa.com) (Port = 1580)) (ADDRESS = (PROTOCOL = TCP)
(Host = onames2.ami.alcoa.com) (Port = 1580)) (ADDRESS = (PROTOCOL = TCP)
(Host = onames3.ami.alcoa.com) (Port = 1580)) (ADDRESS = (PROTOCOL = TCP)
(Host = onames4.ami.alcoa.com) (Port = 1580)))
  NAMES.DIRECTORY_PATH = (ONAMES,TNSNAMES)   SQLNET.CRYPTO_SEED = 766822122
  LOG_FILE_CLIENT = sqlnet
  sqlnet.authentication_services = (NONE)   NAME.PREFERRED_SERVERS = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host

= onames.ami.alcoa.com) (Port = 1580)) (ADDRESS = (PROTOCOL = TCP) (Host =
onames1.ami.alcoa.com) (Port = 1580)) (ADDRESS = (PROTOCOL = TCP) (Host =
onames2.ami.alcoa.com) (Port = 1580)) (ADDRESS = (PROTOCOL = TCP) (Host =
onames3.ami.alcoa.com) (Port = 1580)) (ADDRESS = (PROTOCOL = TCP) (Host =
onames4.ami.alcoa.com) (Port = 1580)))

  TRACE_FILE_CLIENT = d:\sqlnet.log
  NAMES.DEFAULT_DOMAIN = ami.alcoa.com
--- PARAMETER SOURCE INFORMATION ENDS ---

• LOG CONFIGURATION INFORMATION FOLLOWS --- Log stream will be "C:\WINNT\SYSTEM32\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.

*** What's happening here? *****
niotns: Calling address:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=ora
cleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT _DATA=(SID=ORCL)(CID=(PROGRAM=C:\WINNT\System32\inetsrv\inetinfo.exe)(HOST=N OAADC-PWEB01)(USER=SYSTEM))))

---

nsmal: 140 bytes at 0x4d9e39f8
nscall: connecting...

nladini: entry
nladini: exit
nladget: entry
nladget: exit
nlpcaini: entry
nlpcaini: prg =
nlpcaini: arg[0] =

nlpcaini: arg[1] =
nlpcaini: exit
nsmal: 420 bytes at 0x5a047df0
nsmal: 1712 bytes at 0xcc6858
snsbitts_ts: acquired the bit

nsopen: opening transport...
ntpcon: entry
ntpcon: toc = 1

sntpcall: entry
snlpcss: entry
ntpcon: exit
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
snsbitts_ts: acquired the bit
nsopen: unable to open transport
snsbitts_ts: acquired the bit
snsbitts_ts: acquired the bit
nsmfr: 1712 bytes at 0xcc6858
nsmfr: 420 bytes at 0x5a047df0
nladget: entry
nladget: exit
nsmfr: 140 bytes at 0x4d9e39f8

nladtrm: entry
nladtrm: 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
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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Received on Mon Nov 04 2002 - 14:19:54 CST