Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2003-11-17
8
Medium Priority
?
6,305 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
[X]
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
  • 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 2000 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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
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
 
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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to take different types of Oracle backups using RMAN.

722 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