Re: Problem after IP address change

In addition to Frank's remarks

did you restart the listener ?

//tc

"Frank" <fvanbortel_at_netscape.net> wrote in message news:3EA6C90A.8020204_at_netscape.net...
> Peter Grübl wrote:
> > Hello
> >
> > I installed oracle 8.1.7 on a linux server. After I have changed the ip
> > address I can't connect to the server any longer. A tnsping from the
> > client works fine
>
> e.g. tnsping peter - that works?
>
> > but sqlplus username/password_at_instance dosen't work. I get allways the
> > error message ORA-12545 TNS name lookup failure.
> >
> And sqlplus user/passwd_at_peter does not?
>
> Odd - unless your tnsping is another client version than your sqlplus...
> Check how many tnsnames.ora files your client has. Must be two (or more).
>
> Another source might be the use of the ip-address in tnsnames.ora,
> but then tnsping should not work either.
>
> Sure nothing else was changed than the ip address? The domain, for
 instance?
> --
> Regards, Frank van Bortel
>
Received on Thu Apr 24 2003 - 15:00:31 CEST