Re: Can someone interpret this SQL net trace for me..

andy.crutchlow_at_service.britgas.co.uk (Andy Crutchlow) wrote:

>versions of s/w:
>TCP/IP Adapter 2.1.4.1.3A
>SQL Net 2.1.4.1.4
>SQL Net TCP/IP 1.1.9.0A
 

>sqlnet.ora is :
 

>################
># Filename......: sqlnet.ora
># Name..........: wmis1.world
># Date..........: 03-MAY-96 12:31:40
>################
>AUTOMATIC_IPC = ON
>TRACE_LEVEL_CLIENT = OFF
>SQLNET.EXPIRE_TIME = 0
>NAMES.DEFAULT_DOMAIN = world
>NAME.DEFAULT_ZONE = world
>SQLNET.CRYPTO_SEED = "-919994674-919967963"
>trace_level_client = 16
>trace_file_client = sqlnet
>trace_directory_client=C:\ORAWIN\network\trace
>log_file_client = sqlnet
>log_directory_client=C:\ORAWIN\network\log
>netman.trace_level=16
>netman.trace_file=netman
>netman.trace_directory=C:\ORAWIN\network\trace
 

>tnsname.ora is :
 

>################
># Filename......: tnsnames.ora
># Name..........: LOCAL_REGION.world
># Date..........: 03-MAY-96 12:31:40
>################
>XXX.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = wmis1.world)
> (PROTOCOL = TCP)
> (Host = wmis1)
> (Port = 1527)
> )
> )
> (CONNECT_DATA =
> (SID = WMSC)
> (GLOBAL_NAME = XXX.world)
> )
> )

>###########V1 CONNECT STRINGS###########
>CASE2.world = T:wmis1,1527:WMSC

>Trace file produced is :
 

>--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
>New trace stream is "C:\ORAWIN\network\trace\sqlnet.trc"
>New trace level is 16
>--- TRACE CONFIGURATION INFORMATION ENDS ---
 
>--- PARAMETER SOURCE INFORMATION FOLLOWS ---
>Attempted load of system pfile source C:\ORAWIN\network\admin\sqlnet.ora
>Parameter source loaded successfully
 

>Attempted load of local pfile source C:\ORAWIN\BIN\sqlnet.ora
>Parameter source was not loaded
 

> -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
>Successful parameter table load
> -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
> AUTOMATIC_IPC = ON
> trace_directory_client = C:\ORAWIN\network\trace
> netman.trace_file = netman
> netman.trace_directory = C:\ORAWIN\network\trace
> SQLNET.CRYPTO_SEED = -919994674-919967963
> SQLNET.EXPIRE_TIME = 0
> trace_level_client = 16
> trace_file_client = sqlnet
> log_file_client = sqlnet
> netman.trace_level = off
> NAME.DEFAULT_ZONE = world
> NAMES.DEFAULT_DOMAIN = world
> log_directory_client = C:\ORAWIN\network\log
>--- PARAMETER SOURCE INFORMATION ENDS ---
 
>--- LOG CONFIGURATION INFORMATION FOLLOWS ---
>Log stream will be "C:\ORAWIN\network\log\sqlnet.log"
>Log stream validation not requested
>--- LOG CONFIGURATION INFORMATION ENDS ---
 
>osnqig: entry
>osnqig: Count in the NL global area is now 1
>osnqig: Count in OSN global area now: 1
>nrigbi: entry
>nrigbni: entry
>nrigbni: Could not find local communities
>nrigbni: Empty TNSNAV.ORA present
>nrigbni: exit
>nrigbi: exit
>osnqig: exit
>osntns: entry
>nncpmlf_make_local_addrfile: construction of local names file failed
>nncpmsf_make_sys_addrfile: system names file is C:\ORAWIN\network\admin\tnsnames.ora
>nncpcin_maybe_init: first request sent to name server will have ID 27152
>nncpcin_maybe_init: initial retry timeout for all name servers is 500 csecs
>nncpcin_maybe_init: max request retries per name server is 2
>nngsini_init_streams: initializing stream subsystem, cache size is 0
>nngtini_init_msg: initializing PDU subsystem, initial pool size is 2
>nncpcin_maybe_init: default name server domain is world
>osnqrn: Using nnfsn2a() to build connect descriptor for (possibly remote) database.
>nnfsinit: entry
>nnfsinit: Obtaining native use parameter native_names.use_native
>nnfsinit: Using Oracle naming
>nncin2a: name "S:.world" is invalid
>osnqrn: Return code from nnfsn2a is 1
>-<ERROR>- osntns: Couldn't connect, returning 12154
>osntns: exit
>osnqtg: Count in the OSN global area is now 0
>nngsdei_deinit_streams: deinit
>nrigbd: entry
>nrigbd: exit
>nrigbd: entry
>nrigbd: No Routing global data found
>nrigbd: exit
>osnqtg: Count in the NL global area is now 0

>both XXX and CASE2 are reconised as database's but both produce
>same connect error for name 'S:.world'. I don't understand where it
>gets the 'S' from???
 

>Can anyone help.
>e-mail andy.cructhlow_at_service.britgas.co.uk
 

>Thanks.
>Andy Crutchlow.

Are you using Secure Network Services and SQL*NET V1? I would recommend trying this using SQL*NET V2.

Jim Joslin Received on Fri May 10 1996 - 00:00:00 CEST