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
LVL 1
DCCoolBreezeAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

seazodiacCommented:
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 [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                                              
                                                                               
seazodiacCommented:
DCCoolBreeze:

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
TRACE_FILE_CLIENT = CLIENT
TRACE_LEVEL_CLIENT = 16

then try to connect again use sqlplus , then read the log trace file in the designated file directory.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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

you are very welcome..
JamesEvangelosCommented:
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?
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.