Home » RDBMS Server » Networking and Gateways » TNSPING HOSTNAME gives error
TNSPING HOSTNAME gives error [message #499888] Wed, 16 March 2011 10:12 Go to next message
infinitenumbers
Messages: 33
Registered: November 2010
Member
Hi Guys,

the command tnsping remotehostname

its gives the following error. PING remotehostname works fine.


TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 16-MAR-2
011 11:09:37

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

Used parameter files:
D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name


I know it could be the most usual error. But I am not able to figure it out. Please help me with this.


Thank you.
Re: TNSPING HOSTNAME gives error [message #499889 is a reply to message #499888] Wed, 16 March 2011 10:22 Go to previous messageGo to next message
BlackSwan
Messages: 26752
Registered: January 2009
Location: SoCal
Senior Member
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.


Too bad COPY & PASTE seem broken for you

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

post content of tnsnames.ora
Re: TNSPING HOSTNAME gives error [message #499890 is a reply to message #499889] Wed, 16 March 2011 10:29 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
"remotehostname" is wrong. You don't tnsping a remote host, you have to tnsping an Oracle TNS_ALIAS.

[Updated on: Wed, 16 March 2011 11:04]

Report message to a moderator

Re: TNSPING HOSTNAME gives error [message #499891 is a reply to message #499888] Wed, 16 March 2011 10:30 Go to previous messageGo to next message
infinitenumbers
Messages: 33
Registered: November 2010
Member
Hi,

Below are the contents of tnsnames.ora. I am sure I have provided the correct host name.



TESTDB.COMPANY.COM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = myremotehostname)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = testdb)
)
)
Re: TNSPING HOSTNAME gives error [message #499892 is a reply to message #499891] Wed, 16 March 2011 10:37 Go to previous messageGo to next message
BlackSwan
Messages: 26752
Registered: January 2009
Location: SoCal
Senior Member
tnsping TESTDB.COMPANY.COM

will work better than what you did

use COPY & PASTE so we can see what you do & how Oracle responds
Re: TNSPING HOSTNAME gives error [message #499893 is a reply to message #499891] Wed, 16 March 2011 10:38 Go to previous message
infinitenumbers
Messages: 33
Registered: November 2010
Member
Thank you Thomas. it worked.
Previous Topic: Heterogeneous services
Next Topic: Listener for oracle HS not starting
Goto Forum:
  


Current Time: Thu Oct 29 03:43:31 CDT 2020