asked on

Oracle 9i: Windows Client: TNS-03505: Failed to resolve name

OK. I have setup an Oracle personal database on one of my networked computers. Now I want to be able to access the database. I get the infamous error TNS-03505: Failed to resolve name.

my sqlnet.ora is

AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = OFF
names.directory_path = (TNSNAMES)
names.default_domain = WORLD
name.default_zone = WORLD

my tnsnames.ora

VADHome =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = delaware-xp)(PORT = 1521))
)
(CONNECT_DATA =
(SID = VADHome)
)
)

Can anyone help???

Thanks in advance

seazodiac

can you check in the command prompt if

1. ping delaware-xp (make sure tcp/ip protocol working...)

2. tnsping VADHome

3. change your computer host name from "delaware-xp" to the physical IP address of the oracle host machine.

and post your results here...

DCCoolBreeze

ASKER

[C:\Documents and Settings\Delaware]ping delaware-xp

Pinging delaware-xp [192.168.0.103] with 32 bytes of data:

Reply from 192.168.0.103: bytes=32 time<1ms TTL=128
Reply from 192.168.0.103: bytes=32 time<1ms TTL=128
Reply from 192.168.0.103: bytes=32 time<1ms TTL=128
Reply from 192.168.0.103: bytes=32 time<1ms TTL=128

Ping statistics for 192.168.0.103:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms
[C:\Documents and Settings\Delaware]tnsping vadHome

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 17-NOV-20
03 13:46:22

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
D:\oracle\ora92\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name

ASKER CERTIFIED SOLUTION

seazodiac

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

seazodiac

in case you don't know already how to check the status of the oracle server side listener process;

you can use "C:\>lsnrctl status" or you can just "C:\> lsnrctl start" to start the listener.

also regarding my previous post, when you add those three lines to your client sqlnet.ora file,
you need to comment out the line "trace_level_client = off" in your original file.

good luck.

DCCoolBreeze

ASKER

[17-NOV-2003 14:56:53:539]
--- TRACE CONFIGURATION INFORMATION FOLLOWS ---
[17-NOV-2003 14:56:53:539] New trace stream is D:\TMP\client_2184_1.trc
[17-NOV-2003 14:56:53:539] New trace level is 16
[17-NOV-2003 14:56:53:539] --- TRACE CONFIGURATION INFORMATION ENDS ---
[17-NOV-2003 14:56:53:539]
--- PARAMETER SOURCE INFORMATION FOLLOWS ---
[17-NOV-2003 14:56:53:539] Attempted load of system pfile source D:\oracle\ora92\network\admin\sqlnet.ora
[17-NOV-2003 14:56:53:539] Parameter source loaded successfully
[17-NOV-2003 14:56:53:539]
[17-NOV-2003 14:56:53:539] Attempted load of local pfile source D:\tmp\sqlnet.ora
[17-NOV-2003 14:56:53:539] Parameter source was not loaded
[17-NOV-2003 14:56:53:539]
[17-NOV-2003 14:56:53:539] -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
[17-NOV-2003 14:56:53:539] Successful parameter table load
[17-NOV-2003 14:56:53:539] -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
[17-NOV-2003 14:56:53:539] name.default_zone = WORLD
[17-NOV-2003 14:56:53:539] AUTOMATIC_IPC = OFF
[17-NOV-2003 14:56:53:539] TRACE_DIRECTORY_CLIENT = D:\TMP
[17-NOV-2003 14:56:53:539] names.directory_path = (TNSNAMES)
[17-NOV-2003 14:56:53:539] TRACE_LEVEL_CLIENT = 16
[17-NOV-2003 14:56:53:539] TRACE_FILE_CLIENT = CLIENT
[17-NOV-2003 14:56:53:539] names.default_domain = WORLD
[17-NOV-2003 14:56:53:539] --- PARAMETER SOURCE INFORMATION ENDS ---
[17-NOV-2003 14:56:53:539]
--- LOG CONFIGURATION INFORMATION FOLLOWS ---
[17-NOV-2003 14:56:53:539] Log stream will be "D:\tmp\sqlnet.log"
[17-NOV-2003 14:56:53:539] Log stream validation not requested
[17-NOV-2003 14:56:53:539] --- LOG CONFIGURATION INFORMATION ENDS ---

[17-NOV-2003 14:56:53:539] nigini: entry
[17-NOV-2003 14:56:53:539] nigini: Count in NI global area now: 1
[17-NOV-2003 14:56:53:539] nigini: Count in NI global area now: 1
[17-NOV-2003 14:56:53:539] nrigbi: entry
[17-NOV-2003 14:56:53:539] nrigbni: entry
[17-NOV-2003 14:56:53:539] nrigbni: Unable to get data from navigation file tnsnav.ora
[17-NOV-2003 14:56:53:539] nrigbni: exit
[17-NOV-2003 14:56:53:539] nrigbi: exit
[17-NOV-2003 14:56:53:539] nigini: exit
[17-NOV-2003 14:56:53:539] niqname: Using nnfsn2a() to build connect descriptor for (possibly remote) database.
[17-NOV-2003 14:56:53:539] nnfgiinit: entry
[17-NOV-2003 14:56:53:539] nnftboot: entry
[17-NOV-2003 14:56:53:539] nnftboot: exit
[17-NOV-2003 14:56:53:539] nnfoboot: entry
[17-NOV-2003 14:56:53:539] nnfoboot: exit
[17-NOV-2003 14:56:53:539] nnfoboot: entry
[17-NOV-2003 14:56:53:539] nnfoboot: exit
[17-NOV-2003 14:56:53:539] nnfhboot: entry
[17-NOV-2003 14:56:53:539] nnfhboot: exit
[17-NOV-2003 14:56:53:539] nnflcls: entry
[17-NOV-2003 14:56:53:539] nnflcls: exit
[17-NOV-2003 14:56:53:539] nncpcin_maybe_init: first request sent to name server will have ID 222
[17-NOV-2003 14:56:53:539] nncpcin_maybe_init: initial retry timeout for all name servers is 1500 csecs
[17-NOV-2003 14:56:53:539] nncpcin_maybe_init: max request retries per name server is 1
[17-NOV-2003 14:56:53:539] nngsini_init_streams: initializing stream subsystem, cache size is 10
[17-NOV-2003 14:56:53:539] nngtini_init_msg: initializing PDU subsystem, initial pool size is 2
[17-NOV-2003 14:56:53:539] nncpcin_maybe_init: default name server domain is WORLD
[17-NOV-2003 14:56:53:539] nnfun2a: entry
[17-NOV-2003 14:56:53:539] nlolgobj: entry
[17-NOV-2003 14:56:53:539] nnfgrne: entry
[17-NOV-2003 14:56:53:539] nnfgrne: Installing read path
[17-NOV-2003 14:56:53:539] nnfgsrsp: entry
[17-NOV-2003 14:56:53:539] nnfgsrsp: Obtaining path parameter from names.directory_path or native_names.directory_path
[17-NOV-2003 14:56:53:539] nnfgsrdp: entry
[17-NOV-2003 14:56:53:539] nnfgsrdp: Setting path:
[17-NOV-2003 14:56:53:539] nnfgsrdp: checking element TNSNAMES
[17-NOV-2003 14:56:53:539] nnfgsrdp: Path set
[17-NOV-2003 14:56:53:539] nnfgrne: Going though read path adapters
[17-NOV-2003 14:56:53:539] nnfgrne: Switching to TNSNAMES adapter
[17-NOV-2003 14:56:53:539] nnfgrne: Original name: vadHome
[17-NOV-2003 14:56:53:539] nnftinit: entry
[17-NOV-2003 14:56:53:539] nnftinit: Tnsnames refresh interval is 0
[17-NOV-2003 14:56:53:539] nlpaxini: entry
[17-NOV-2003 14:56:53:539] nlpaxini: exit
[17-NOV-2003 14:56:53:539] nnftmlf_make_local_addrfile: entry
[17-NOV-2003 14:56:53:539] nnftmlf_make_local_addrfile: construction of local names file failed
[17-NOV-2003 14:56:53:539] nnftmlf_make_local_addrfile: exit
[17-NOV-2003 14:56:53:539] nlpaxini: entry
[17-NOV-2003 14:56:53:539] nlpaxini: exit
[17-NOV-2003 14:56:53:539] nnftmlf_make_system_addrfile: entry
[17-NOV-2003 14:56:53:539] nnftmlf_make_system_addrfile: system names file is D:\oracle\ora92\network\admin\tnsnames.ora
[17-NOV-2003 14:56:53:539] nnftmlf_make_system_addrfile: exit
[17-NOV-2003 14:56:53:539] nnftinit: exit
[17-NOV-2003 14:56:53:539] nnftqnm: entry
[17-NOV-2003 14:56:53:539] nnfcagmd: entry
[17-NOV-2003 14:56:53:539] nnfcagmd: Attempting to find metadata for type a.smd
[17-NOV-2003 14:56:53:539] nnfcagmd: Attribute name a.smd is a predefined meta type, syntax is 4.
[17-NOV-2003 14:56:53:539] nnfcagmd: exit
[17-NOV-2003 14:56:53:539] nnfttran: entry
[17-NOV-2003 14:56:53:539] nnftqnm: Error querying vadHome.WORLD of attribute A.SMD errcode 406
[17-NOV-2003 14:56:53:539] nnfgrne: Query unsuccessful, skipping to next adapter
[17-NOV-2003 14:56:53:539] nnfgrne: exit
[17-NOV-2003 14:56:53:539] nnfun2a: address for name "vadHome" not found
[17-NOV-2003 14:56:53:539] niqname: Return code from nnfsn2a is 1
[17-NOV-2003 14:56:53:539] nigtrm: Count in the NI global area is now 0
[17-NOV-2003 14:56:53:539] nrigbd: entry
[17-NOV-2003 14:56:53:549] nrigbd: exit
[17-NOV-2003 14:56:53:549] nigtrm: Count in the NL global area is now 0

DCCoolBreeze

ASKER

I just solved it. Given the log entry errcode 406, I realized that I did not append .world to my name. Thanks for your help

seazodiac

precisely, that's what I will suggest you next step.

you are very welcome..

JamesEvangelos

Dear DCCoolBreeze and/or seazodiac. I have read this discussion article, and I have a very, very similar problem. However, I am using Oracle 9i . And I even put on the trace flags per seazodiac's suggestion. However, I get the following output in my log file:

Error querying DEVEL of attribute A.SMD errcode 406.

I follow the same exact procedures that you guys followed. How do I understand this error code?