[askdba] Re: Strange Problem with TNSPING
- From: Rajesh Puneyani <rajpuneyani@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Mon, 4 Oct 2004 13:36:51 -0400
Hi all,
Thanks everyone for responding..I have not been able to resolve it..I
can ping the server by new IP address and by new servername but
still...Anyhow I can got the work around and which is -
Put another entry for that database (with a different alias though)
with new IP address. For the time being, I am back online but will
keep working on finding that cached entry.
Thank you everyone.
Regards
On Sat, 2 Oct 2004 01:52:23 -0400, Irfan Khan <irfan.khan@xxxxxxxxxxxx> wrote:
> 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:
