TNS-03505: Failed to resolve name

I am receiving the above error when performing a tnsping or sqlplus connect to a Database I have created on Oracle 817 on Windows 2000.

Despite all efforts to amend the TNSNAMES file and SQLNET.ORA file LISTENER.ORA file I still receive this error. I have created database with a global name of LITTLE, SID = LITTLE.
Services running on WIndows are:-
Oracleora8iTNSListener
OracleServiceLITTLE
Oracleora8iAgent
OracleWebAssistant


LSNRCTL status shows the following:
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Pr
tion
Start Date 20-DEC-2002 09:27:42
Uptime 0 days 2 hr. 52 min. 40 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File c:\ora8i\network\admin\listener.ora
Listener Log File c:\ora8i\network\log\listener.log
Services Summary...
LITTLE has 1 service handler(s)
LITTLE has 1 service handler(s)
PLSExtProc has 1 service handler(s)
dsd01 has 1 service handler(s)
dsdora81 has 1 service handler(s)

Here are my configuration Files

TNSNAMES.ORA
***************

# TNSNAMES.ORA Network Configuration File: C:\oracle\ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORA817 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dsd)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora817)
)
)

LITTLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dsd)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = LITTLE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)


SQLNET.ORA
******************
# SQLNET.ORA Network Configuration File: c:\ora8i\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

#DISABLE_OOB = ON

NAME.DEFAULT_ZONE = world

NAMES.DEFAULT_DOMAIN = world

SQLNET.AUTHENTICATION_SERVICES= (NONE)

#AUTOMATIC_IPC = OFF
#TRACE_LEVEL_CLIENT = OFF
#names.directory_path = (TNSNAMES)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES)

LISTENER.ORA
***********

# LISTENER.ORA Network Configuration File: c:\ora8i\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dsd)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\ora8i)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = dsdora81)
(ORACLE_HOME = c:\ora8i)
(SID_NAME = dsdora81)
)
(SID_DESC =
(GLOBAL_DBNAME = dsd01)
(ORACLE_HOME = c:\ora8i)
(SID_NAME = dsd01)
)
(SID_DESC =
(GLOBAL_DBNAME = LITTLE)
(ORACLE_HOME = c:\ora8i)
(SID_NAME = LITTLE)
)
)

Delete SQLNET.ORA or commect all lines.

Quote:

---

Originally posted by bal
TNSNAMES.ORA
***************
...
ORA817 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dsd)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora817)
)
)

...

---

try use here SID keyword instead of SERVICE_NAME. If it works, then there is an issue of backward compatibility flag on one of conf. assistant tab (sorry, I don't remember more exactly where it is). It comes with default installation.

Commenting SQLNET.ORA did not work. Still receive the same error.TNS-03505: Failed to resolve name

Are you sure your host is dsd? if so try like below :

LITTLE=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dsd)(PORT = 1521))
)
(CONNECT_DATA = (SID = LITTLE)(SERVER = DEDICATED))
)

Also try commenting out the following line in sqlnet.ora :
# NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES)

Tried all above still not worked

in sqlnet.ora
NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, ONAMES)

also in your listener.ora
LISTENER.ORA
***********

# LISTENER.ORA Network Configuration File: c:\ora8i\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dsd)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = c:\ora8i)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = dsdora81)
(ORACLE_HOME = c:\ora8i)
(SID_NAME = dsdora81)
)
(SID_DESC =
(GLOBAL_DBNAME = dsd01)
(ORACLE_HOME = c:\ora8i)
(SID_NAME = dsd01)
)
(SID_DESC =
(GLOBAL_DBNAME = LITTLE)
(ORACLE_HOME = c:\ora8i)
(SID_NAME = LITTLE)
)
)


do
GLOBAL_DBNAME as LITTLE.world everywhere

Tried all above, still same error message. what could be wrong.

Did you install multiple oracle clients in your box?

Make sure your init*.ora file located in directory
%ORACLE_HOME%\admin\LITTLE\pfile\init*.ora
has the following values:




db_name = "LITTLE"

db_domain = WORLD <--- this had better match the value
<---- NAMES.DEFAULT_DOMAIN in SQLNET.ORA

instance_name = LITTLE

service_names = LITTLE.WORLD <-- This should be db_name + db_domain
<-- and this name MUST match the value
<-- in your TNSNAMES.ORA file item
<-- CONNECT_DATA->SERVICE_NAME. see
<-- below

LITTLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = YOURSERVERGOESHERE)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = LITTLE.WORLD)
)
)

sqlnet.ora and tnsnames.ora file relationship

The NAMES.DIRECTORY_PATH parameter in sqlnet.ora can be commented out (or not even included) because the order shown below is the default search order for names resolution in Net8 (Oracle Net for 9i).

The service name equals the instance name + the default domain. If you are trying to connect to an instance running on your machine, you don't need to have the listener running. Net8 spawns a bequeath session, which is the same as a dedicated server process. You DO need to have the ORACLE_SID environment variable set to the name of the database on your machine you are trying to connect to. If you set the NAMES.DEFAULT_DOMAIN parameter in this file (e.g., company.com), then Oracle will append company.com to the net service name in the connect string (the net service name is the name following the @ sign). After that, Oracle will look for an address of name_you_used.company.com. If your database names are not named that way in the tnsnames.ora file, you will see a TNS- or ORA-12154 error ("could not resolve service name"). Other errors are possible too.

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

If you are using NAMES.DEFAULT_DOMAIN, the value should match the domain name of your local environment. For example, assume your domain name is company.com. A fully qualified net service name for a database named kfm would be kfm.company.com. If you are connecting remotely (and you can do this on the server by going thru the
network), the connect descriptor is username/password@kfm. What Oracle Net8 does is take "kfm" and add the value for NAMES.DEFAULT_DOMAIN to it (i.e., kfm.company.com) and then looks for an entry of kfm.company.com in your tnsnames.ora file. If Net8 does not see kfm.company.com in the file, you get an error.

If you don't use a default domain name, leave that parameter commented out or just delete the line in sqlnet.ora. That way, when you use username/password@kfm, Net8 simply looks for a stanza begining with "kfm" in the tnsnames.ora file.

NAMES.DEFAULT_DOMAIN = company.com

Note: If you are using the Database Configuration Assistant (usually see this when installing the RDBMS software at the point where the seed database is created), don't use a hyphen in the domain name because the assistant won't recognize a hyphen as a valid character. You can go back later and manually edit sqlnet.ora and tnsnames.ora
to add the hyphen in the domain name.

Modify ur TNS.ora, give the servername with domain.
Say domainz company.net.......try with

dds.comany.net
(
....
HOST = dsd.company.net or IP
....
)

while login try with domain in connect string.

Set defualt domain in SQLNet.ora as ur compnay domain.

Hope this shud work

Abhay.

Was my explanation not clear enough?