Go Premium for a chance to win a PS4. Enter to Win

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6320
  • Last Modified:

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

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
  • 4
  • 3
1 Solution
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...
DCCoolBreezeAuthor Commented:
[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                                              

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.
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

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.
DCCoolBreezeAuthor Commented:
[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
DCCoolBreezeAuthor Commented:
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
precisely, that's what I will suggest you next step.

you are very welcome..
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now