[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 =
at.

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

Regards
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.
Thanks
Rajesh


On Fri, 1 Oct 2004 13:28:21 -0400, Rajesh Puneyani
<rajpuneyani@xxxxxxxxx> wrote:
> Hi guys,
>=20
> I have this very strange problem with TNSPING.
>=20
> 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.
>=20
> 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.
>=20
> =
-------------------------------------------------------------------------=
-------------------------------
> 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))) =
(CONNECT_DATA
> =3D (SERVER =3D DEDICATED) (SERVICE_NAME =3D GLIDEV)))
>=20
> Here xxx.xxx.xxx.xxx is the old IP address
> =
-------------------------------------------------------------------------=
--------------------------------
>=20
> Am I missing something here ? Is there anything cached that I needed =
to clear ?
>=20
> Thanks and Regards
>


Other related posts: