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 - 09:05:01 CDT
