[askdba] Re: Strange Problem with TNSPING

  • From: Todd Pepling <tpepling@xxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Fri, 01 Oct 2004 16:43:22 -0400

If on Window, did you perform a DNS flush?
What are the results of ping?

-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]On
Behalf Of Rajesh Puneyani
Sent: Friday, October 01, 2004 4:08 PM
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Re: Strange Problem with TNSPING

Hi all,

I did not get any response on that so I was wondering if it is too
stupid a question to be answered.

Pls tell me why the following problem is happening.

On Fri, 1 Oct 2004 13:28:21 -0400, Rajesh Puneyani
<rajpuneyani@xxxxxxxxx> wrote:
> Hi guys,
> I have this very strange problem with TNSPING.
> My tnsnames.ora file had IP Address (rather than server names)
> hardcoded for databases and now those IP Address are changed (but
> server names remain the same) and I have changed those old IP
> Addresses to SERVER NAMES.
> But now when I TNSPING those databases then it is still trying to
> resolve the database alias from old IP Address and it is not picking
> up the SERVER name.
> --------------------------------------------------------------------------
> Used TNSNAMES adapter to resolve the alias
> Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
> (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))) (CONNECT_DATA
> Here xxx.xxx.xxx.xxx is the old IP address
> --------------------------------------------------------------------------
> Am I missing something here ? Is there anything cached that I needed to
clear ?
> Thanks and Regards

-- Attached file included as plaintext by Ecartis --
-- Desc: Signature

The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material.  If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited.   If you are not the intended
recipient, please contact the sender and delete the material from any

Other related posts: