"Daniel Stephens" <daniel.stephens_at_manches.co.uk> wrote in message
news:bcbb7b14.0306030750.5d194b3a_at_posting.google.com...
> Problem: After change of IP address on server, login to databases is
> alot slower than before, when doing so from certain machines.
>
> Server: Oracle 7.4.3.5.0
> Windows NT 4.0 SP 5
>
> We have recently changed the network card and IP address in our server
> from our token-ring network to ethernet, and consequently the IP
> address has changed.
>
> This IP address change has been reflected in all/any tnsnames.ora and
> listener.ora throughout the network(as far as I can tell). The copies
> on the server have been changed. listener and tnsnames use the IP
> address rather than the host name.
>
> DNS and WINS are updated with the correct IP address for the server.
>
> When logging in to a database on the server, from the server, (e.g.
> svrmgr23, or plus33w) it takes ages (possibly a minute). This didn't
> happen before the IP address change.
> There are a few other client machines that take a long time to log in
> to the database. All other client machines are fine with login speed.
>
> There is one NT 4 server machine that is slow, and one windows 2000
> machine that is slow. There is also a windows 2000 machine that is
> perfectly fine.
> All appear to have the same settings.
>
> I cannot think of anywhere else that the IP address could need to be
> changed .. anyone got any ideas???
>
> Even when trying the wonderful T.O.A.D., I get the same slow login.
>
> I can't think of anything else pertinant, but if any questions please
> let me know.
>
> Regards
>
> Dan!
Can you perform regular/reverse DNS lookups on the server hostname/IP?
Sounds like a DNS / nameserver issue, slow logins due to DNS queries
failing.
Received on Tue Jun 03 2003 - 12:02:35 CDT
