Re: Problem after IP address change

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