[askdba] Re: Strange Problem with TNSPING

  • From: "Irfan Khan" <irfan.khan@xxxxxxxxxxxx>
  • To: <askdba@xxxxxxxxxxxxx>
  • Date: Sat, 2 Oct 2004 01:52:23 -0400

Your Servername is getting resolved against some naming service =
(probably DNS) or could be host file or NIS or NIS+

try nornal ping of servername and check what is the IP it is resolving =

Ask ur network admin to change the entry in the DNS.

Irfan Khan

-----Original Message-----
From: Rajesh Puneyani [mailto:rajpuneyani@xxxxxxxxx]
Sent: Saturday, October 02, 2004 4:08 AM
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 =3D (ADDRESS_LIST =3D (ADDRESS =3D
> (PROTOCOL =3D TCP)(HOST =3D xxx.xxx.xxx.xxx)(PORT =3D 1521))) =
> 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

Other related posts: