TNS-03505: Failed to resolve name

[bal]

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

[kgb]

Delete SQLNET.ORA or commect all lines.

[kiewer]

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.

[bal]

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

[Giani]

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)

[bal]

Tried all above still not worked

[saurabhg29]

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

[bal]

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

[supower]

Did you install multiple oracle clients in your box?

[ianh]

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