Re: Slow Connection for SQL*Plus

Mickey Zoller wrote:
>
> I just downloaded the Personal Oracle7 for Windows 95. I istalled just the
> SQL*Net V2 with TCP/IP adapeter and SQL*Plus. Now when I make a network
> connection to a remote database it takes about 60 seconds for the connection to
> be made. Does anyone have any Ideas?

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.

Anyway, I still have a long delay problem connecting from Windows 3.1 on a Novell Lan via SQL*Net V2.1 to an OpenVMS Alpha Server with ORACLE7 V7.1 25 seconds is typical. Far too long.

Wayne Linton Received on Tue Oct 01 1996 - 00:00:00 CEST