Solved

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

Posted on 2003-11-17
8
6,239 Views
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

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
0
Comment
Question by:DCCoolBreeze
  • 4
  • 3
8 Comments
 
LVL 23

Expert Comment

by:seazodiac
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...
0
 
LVL 1

Author Comment

by:DCCoolBreeze
ID: 9765853
[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                                              
                                                                               
0
 
LVL 23

Accepted Solution

by:
seazodiac earned 500 total points
ID: 9765989
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.
0
 
LVL 23

Expert Comment

by:seazodiac
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.
0
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 1

Author Comment

by:DCCoolBreeze
ID: 9766339
[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
0
 
LVL 1

Author Comment

by:DCCoolBreeze
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
0
 
LVL 23

Expert Comment

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

you are very welcome..
0
 

Expert Comment

by:JamesEvangelos
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?
0

Featured Post

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.

Join & Write a Comment

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to recover a database from a user managed backup

762 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now