Why
it takes long time to connect?
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?
Ans:
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.