sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
tnsnames.ora
TESTDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = *******************)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TESTDB)
)
)
Listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = E:\app\usernameproduct\11.2.0\dbhome_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = ********************)(PORT = 1521))
)
)
Tnsping Testdb
TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 07-FEB-2013 20:58:25
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
C:\oracle\sqlnet.ora
TNS-03505: Failed to resolve name
how to resolve
TNS-03505: Failed to resolve name
checked this site
http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/
I checked all the options but couldn't find what is missing
where as for
Tnsping orcl i am able to ping