OraFAQ Forum: Networking and Gateways » TNS-03505: Failed to resolve name

Home » RDBMS Server » Networking and Gateways » TNS-03505: Failed to resolve name (oracle 10.2.0.3.0 linux rel4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TNS-03505: Failed to resolve name [message #347073]

Wed, 10 September 2008 10:19

n.dba
Messages: 6
Registered: September 2008
Location: NJ

Junior Member

I m trying this tnsping Iranda (here Iranda is my database name).
i got the error

# tnsping IRANDA

TNS Ping Utility for Linux: Version 10.2.0.3.0 - Production on 09-SEP-2008 11:10:40

Copyright (c) 1997, 2006, Oracle. All rights reserved.

Used parameter files:
/u02/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

TNS-03505: Failed to resolve name

My listener.ora setting
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = titan.plymouth.edu)(PORT = 1521))
)
)
)
(SID_DESC =
(GLOBAL_DBNAME = IRANDA)
(ORACLE_HOME = /u02/app/oracle/product/10.2.0/db_1)
(SID_NAME = IRANDA)
)
its working fiine.

My Tnsnames.ora setting
IRANDA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = titan)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = IRANDA)
)
)

My sqlnet.ora setting
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

# Generated by Jon Graton
SQLNET.INBOUND_CONNECT_TIMEOUT = 5

please let me know the solution.bcos i have already spend lot of time on it.solution for the error

Report message to a moderator

Re: TNS-03505: Failed to resolve name [message #347121 is a reply to message #347073]

Wed, 10 September 2008 15:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

03505, 00000, "Failed to resolve name"
// *Cause:  The service name you provided could not be found in TNSNAMES.ORA,
//          an Oracle Names server, or a native naming service.
// *Action: Verify that you entered the service name correctly.  You may need
//          to ensure that the name was entered correctly into the network
//          configuration.

Report message to a moderator

Re: TNS-03505: Failed to resolve name [message #349532 is a reply to message #347121]

Mon, 22 September 2008 02:42

dilip56
Messages: 6
Registered: September 2008

Junior Member

please put the IP address of your host instead of host name (titan) in the tnsnames.ora and try...

Report message to a moderator

Re: TNS-03505: Failed to resolve name [message #349587 is a reply to message #347073]

Mon, 22 September 2008 05:17

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Did you check TNS_ADMIN variable point correct directory for the TNSNAMES.ORA, SQLNET.ORA file?
or
set TNS_ADMIN varible where TNSNAMES.ORA or SQLNET.ORA file is exists.

Report message to a moderator

Re: TNS-03505: Failed to resolve name [message #352225 is a reply to message #349587]

Mon, 06 October 2008 12:48

vikram1780
Messages: 222
Registered: January 2007
Location: Bangalore

Senior Member

Do we have to set the variable tns_admin in client machine too.

If so let us know how can we do it?

Thanks in advance

Report message to a moderator

Re: TNS-03505: Failed to resolve name [message #353170 is a reply to message #347073]

Sun, 12 October 2008 03:29

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

Do we have to set the variable tns_admin in client machine too.

In the machine from which you are trying to connect. It is better aviod using tnsnames.ora.

Report message to a moderator

Previous Topic:	configuring tnsnames.ora
Next Topic:	TNS ERROR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 23:22:41 CDT 2024