Re: Slow Connection for SQL*Plus

David Ng <david_ng_at_mindlink.bc.ca> wrote:

>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

We just reduced our connect time from 15-20 seconds to about 3 seconds by inserting the following line in the SQLNET.ORA file:

AUTOMATIC_IPC = OFF jon Received on Wed Oct 02 1996 - 00:00:00 CEST