Re: Slow login after change of server IP address:

On Tue, 03 Jun 2003 18:22:20 +0200, "Daniel Stephens" <danielstephe.news.invalid_at_web2news.net> wrote:

>Thanks for responding .. :-)
>
>Excerpt from tnsnames:
>
>DBNAME.company.co.uk =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = IP_address)
> (Port = 1521)
> )
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = IP_address)
> (Port = 1526)
> )
> )
> (CONNECT_DATA = (SID = DBNAME)
> )
> )
>
>I have changed DBNAME, company, and IP_address
>

Evidently you can safely rule out DNS as you seem to use hardcoded IP addresses (which you shouldn't do)

Question: you probably didn't perform elementary tests like pinging the server from a client, or issuing a tracert from the client to the server?
So, what makes you think it is is a sqlnet issue?

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Jun 03 2003 - 12:39:24 CDT