Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TNS-03505 Failed to resolve name

972260Jan 31 2013 — edited Jan 31 2013
Having 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 28 2013
Added on Jan 31 2013
5 comments
911 views