-
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.
Best wishes!
Dmitri
-
Re: TNS-03505: Failed to resolve name
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
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)
Giani
-
Tried all above still not worked
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
Saurabh Garg
OCP 9i
-
Tried all above, still same error message.
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)
)
)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|