Re: Insight into SQLnet Tracefile

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

Worry, I forgot

Oracle 8.0.5

The problem started because I was getting a TNS-12154 as an error on a active server page (using Microsoft ODBC drivers).

However, TNSPING worked fine.

"Greg Akins" <insomnia_at_cvzoom.net> wrote in message news:3dc6cf97_at_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
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

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

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