Re: Changed IP address causing ORA-01092

Russ, a few things may be causing your error, first a few questions:

1. Are you using a DNS, and has it been updated?
2. If you are using dhcp is the change there?
3. Are you using an LMHOSTS file?
4. Have you hard coded the IP address in the tnsnames and/or listener.ora?
5. Ping your server by name and see if you get the IP address you expect?
6. If you have multiple NICs insure you are getting to the correct one.

Hope this helps or at least is a start....

js

Russ Conway wrote in message <3ADCD45B.9BE4ED0E_at_hallofsports.com>...
>I changed the IP address on a NT 4.0 development server today and began
>getting errors when I tried to connect to the Oracle 8i database. I got
>the following error:
>
>ORA-01092: ORACLE instance terminated. Disconnection forced.
>
>I'm not having much luck with trouble-shooting so far and would greatly
>appeciate suggestions.
>
Received on Tue Apr 17 2001 - 20:03:07 CDT