Re: Slow Connection for SQL*Plus

From: Stephen Atkinson <atkinson_at_world.net>
Date: 1996/10/02
Message-ID: <52t9hs$fbo_at_news.mel.aone.net.au>#1/1


>You are not alone in your SQL*Net connect time problems. Most of the
>solutions presented on the newsgroup have been around setting the
>TNSNAMES host address to use the IP address directly rather than the
>domain name. This works for some, but didn't work for me.
 

>One other suggestion related to setting a SQLNET parameter via the
>Network Manager tool to specifically use the TNSNAMES.ORA and bypass the
>domain name server. This must be something the Network Manager does in
>a later release of SQL*Net than what I have.

As the previous gentleman points out, many of us have a slow connect with sqlnet V2. I agree that using an IP address rather than a hostname seems to improve matters.

There has been a more detailed discussion of the "whys' on Compuserve.

Cheers,
  Steve   Received on Wed Oct 02 1996 - 00:00:00 CEST

Original text of this message