Re: Slow Connection for SQL*Plus

Wayne Linton <lintonw_at_cadvision.com> 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

Guys,
We all know and love SQL*Net 2 (after all how would we get overtime without it?).
Here's a little useful info for you.

1. The initial connection can be (and usually is) much slower than subsequent connections.
2. If you set AUTOMATIC_IPC = OFF in the SQLNET.ORA file you should see an improvement in connect time as it wount look up the address.
3. You can also specify the IP address in the HOST part to sort of 'direct connect'.

Hope this lot helps.

RH.

DBA Extraordinairre. Received on Thu Oct 03 1996 - 00:00:00 CEST