Home » RDBMS Server » Networking and Gateways » TNS-03505: Failed to resolve name (oracle 10.2.0.3.0 linux rel4)
TNS-03505: Failed to resolve name [message #347073] Wed, 10 September 2008 10:19 Go to next message
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
Re: TNS-03505: Failed to resolve name [message #347121 is a reply to message #347073] Wed, 10 September 2008 15:55 Go to previous messageGo to next message
BlackSwan
Messages: 25047
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.
Re: TNS-03505: Failed to resolve name [message #349532 is a reply to message #347121] Mon, 22 September 2008 02:42 Go to previous messageGo to next message
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...
Re: TNS-03505: Failed to resolve name [message #349587 is a reply to message #347073] Mon, 22 September 2008 05:17 Go to previous messageGo to next message
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.
Re: TNS-03505: Failed to resolve name [message #352225 is a reply to message #349587] Mon, 06 October 2008 12:48 Go to previous messageGo to next message
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
Re: TNS-03505: Failed to resolve name [message #353170 is a reply to message #347073] Sun, 12 October 2008 03:29 Go to previous message
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.
Previous Topic: configuring tnsnames.ora
Next Topic: TNS ERROR
Goto Forum:
  


Current Time: Fri Dec 09 09:31:44 CST 2016

Total time taken to generate the page: 0.15244 seconds