Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

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

Posted on 2003-11-17
Last Modified: 2007-12-19
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

names.directory_path = (TNSNAMES)
names.default_domain = WORLD
name.default_zone = WORLD

my tnsnames.ora

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

Can anyone help???

Thanks in advance
Question by:DCCoolBreeze
  • 4
  • 3
LVL 23

Expert Comment

ID: 9765778
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...

Author Comment

ID: 9765853
[C:\Documents and Settings\Delaware]ping delaware-xp
Pinging delaware-xp [] with 32 bytes of data:                      
Reply from bytes=32 time<1ms TTL=128                            
Reply from bytes=32 time<1ms TTL=128                            
Reply from bytes=32 time<1ms TTL=128                            
Reply from bytes=32 time<1ms TTL=128                            
Ping statistics for                                              
    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 - Production on 17-NOV-20
03 13:46:22                                                                    
Copyright (c) 1997 Oracle Corporation.  All rights reserved.                    
Used parameter files:                                                          
TNS-03505: Failed to resolve name                                              
LVL 23

Accepted Solution

seazodiac earned 500 total points
ID: 9765989

this is very obvious, but have you checked whether the Listener process is running on the oracle server machine or not?

if the listener is already running, then add these three lines to your client sqlnet.ora file:
TRACE_DIRECTORY_CLIENT = Some fully qualified directory like D:\TEMP

then try to connect again use sqlplus , then read the log trace file in the designated file directory.
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

LVL 23

Expert Comment

ID: 9766073
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.

Author Comment

ID: 9766339
[17-NOV-2003 14:56:53:539]
[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]
[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]   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]
[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

Author Comment

ID: 9766387
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
LVL 23

Expert Comment

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

you are very welcome..

Expert Comment

ID: 11089707
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?

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle Pivot Question 8 71
How to free up undo space? 3 50
SQL Developer 6 60
oracle numeric condition check 4 27
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question