Re: HELP net8 on NT very slow

Make the following modifications in sqlnet.ora automatic_ipc = off -- this is useful on the database server only

trace_level_client = 16
trace_unique_client = true
trace_directory_client = c:\orant\network\trace

And the trace file will show you all it is doing in order to connect.

Hth,

Sybrand Bakker, Oracle DBA
Peter Laursen wrote in message <01bead07$60213d40$2c289a0a_at_apollo>...
>I forgot to tell in that tnsnames.ora is only the host-ip not hostname
>
>Peter Laursen < ptl_at_edbgruppen.dk> skrev i artiklen
><01bead03$38e7b910$2c289a0a_at_apollo>...
>> Help, I have some serious trouble connecting from a NT Client (8.0.4) to
>a
>> 8.0.4 server. The client machine connects through an ISDN modem.
>> Standard ping is fine, tnsping <db-alias> is fine, but tnsping<host-ip>
>> takes minuttes before attempting to connect, then connects fine!. My
>> application takes forever to connect.
>>
>> I am not sure where to search for the problem? Client or host? Why is
>> tnsping<host-ip> so slow?
>> Any ideas?
>>
>> Thanks
>> Peter
>>
>> Scenario:
>> 1) ping <host-ip> indicates fine connection (approx 60 ms connection), no
>> delays
>> 2) tnsping80 <db-alias> indicates fine connection, no delays
>> 3) tnsping80 <host-ip> has a very long delay (several minuttes) before it
>> displays the text: Attempting to contact ... and then indicates a fine
>> connection???
>> 4) sqlplus takes a minute or more to establish a connection, however when
>> connected select speed is fine
>> 5) An application opening several sessions and selecting some data takes
>> 20-30 minuttes or more initialising!!
>>
>>
Received on Wed Jun 02 1999 - 12:02:14 CDT