TNS-03505 Failed to resolve name
972260Jan 31 2013 — edited Jan 31 2013Having error from windows 11gR2 client to database server:
sqlnet.ora:
SQLNET.AUTHENTICATION_SERVICES = (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
tnsnames.ora:
TASK=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=task1.domain.net)
(PORT=1521)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=task.domain.net)
)
)
Tnsping error:
TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 31-JAN-2
013 14:05:10
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
C:\app\websenseadmin\product\11.2.0\client_2\network\admin\sqlnet.ora
TNS-03505: Failed to resolve name
Sqlplus error:
ORA-12154: TNS:could not resolve the connect identifier specified
Location of sqlnet.ora is correct to which would mean that path is correct in environment variable.
Windows server is 64-bit but application need 32-bit client. so I have used 32 bit client. I am just not able to tnsping and use sqlplus to connect to that database.
MM