OraFAQ Forum: Networking and Gateways » TNSPING HOSTNAME gives error

Home » RDBMS Server » Networking and Gateways » TNSPING HOSTNAME gives error

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

TNSPING HOSTNAME gives error [message #499888]

Wed, 16 March 2011 10:12

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.

Report message to a moderator

Re: TNSPING HOSTNAME gives error [message #499889 is a reply to message #499888]

Wed, 16 March 2011 10:22

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: TNSPING HOSTNAME gives error [message #499890 is a reply to message #499889]

Wed, 16 March 2011 10:29

ThomasG
Messages: 3212
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

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)
)
)

Report message to a moderator