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

Jim,
It appears that Oracle is trying to resolve your address using Oracle Names Server. Try turning it off.

Check in SQLNET.ORA for the following parms:

names.default_domain 
names.default_zone 
names.preferred_servers  

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

>In article <4n18pf$4tk_at_tribune.concentric.net>, jjoslin_at_concentric.com says:
>>
>>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
>>
 

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

>I'm using SQL*NET V2. I've tried a V1 connect string entry in tnsnames.ora file
>and have directly entered full connect string but all with no effect. All
>variations produce ......
 

>>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
 

>....in trace - implying something fundamental wrong or missing. Something
>is causing name resolution to go wrong???

Chandra Chakicherla
Database Consultant
compros_at_erols.com Received on Mon May 20 1996 - 00:00:00 CEST