Can someone interpret this SQL net trace for me..
Date: 1996/05/03
Message-ID: <4mcu02$599_at_gate.service.britgas.co.uk>#1/1
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 :
################# Name..........: wmis1.world
# Filename......: sqlnet.ora
# 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\tracelog_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 :
################# Name..........: LOCAL_REGION.world
# Filename......: tnsnames.ora
# 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 communitiesnrigbni: 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 0nngtini_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.
Received on Fri May 03 1996 - 00:00:00 CEST