Re: long conect times?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 11 Mar 1999 07:05:28 +0100
Message-ID: <36E75D27.7E040631@sybrandb.demon.nl>

Hi Steve,

This could also be a plug and pray setup of sqlnet. In some cases it searches for well known nameservers.
Verify names.directory_path in sqlnet.ora. The default is (onames,tnsnames). Change it in (tnsnames,onames), or remove onames. To see what is really happening

trace_level_client = 16
trace_unique_client = true
trace_directory_client = <any directory, except oracle_home\bin>

And sqlnet will dump all connection options it tries to the trace file.

Hth,

Sybrand Bakker, Oracle DBA

Steve Haynes wrote:

> Hi All,
>
> A friend is experiencing 60 secs to connect with
> 8.0.5 on a unix box (same box!).
>
> I suggested a few things to try:
> bequeath driver,
> automatic_ipc=off in sqlnet.ora
> changing the ip address in tnsnames.ora to 127.0.0.1 (loopback)
> and testing ftp/ping etc to see if it was oracle or a more general
> network issue.
>
> Any other known causes for long connect times?
>
> Thanks
> Steve
> --
> Please remove nospam from my address to Reply.

Received on Thu Mar 11 1999 - 00:05:28 CST