Re: Slow Connection for SQL*Plus

Wayne Linton wrote:
>
> 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

I thnik the solution should be changing the local parameter in the Oracle.ini in Window directory to tnsservice. The typical connect time in my site is about 3-5 second.

David Ng Received on Wed Oct 02 1996 - 00:00:00 CEST