Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: HELP net8 on NT very slow

Re: HELP net8 on NT very slow

From: Dmitry M.Seminikhin <sam_at_eximb.kiev.ua>
Date: Thu, 3 Jun 1999 11:12:02 +0300
Message-ID: <ABIZZLt0XN@eximb.kiev.ua>


Db_alias contains not only IP, but listener port number and SID also. Actually SQL*Net searches for the appropriate listener on some predefined port numbers (1521,1526 may be others). If your listener resides on another port, the number of attempts may be huge(infinite if only those ports are checked). In any case it's preferable to use db_alias or full connect string. Hope this will help.

PL> Help, I have some serious trouble connecting from a NT Client (8.0.4) to a
PL> 8.0.4 server. The client machine connects through an ISDN modem.
PL> Standard ping is fine, tnsping <db-alias> is fine, but tnsping<host-ip>
PL> takes minuttes before attempting to connect, then connects fine!. My
PL> application takes forever to connect.

PL> I am not sure where to search for the problem? Client or host? Why is
PL> tnsping<host-ip> so slow?
PL> Any ideas?

PL> Thanks
PL> Peter

PL> Scenario:
PL> 1) ping <host-ip> indicates fine connection (approx 60 ms connection), no
PL> delays
PL> 2) tnsping80 <db-alias> indicates fine connection, no delays
PL> 3) tnsping80 <host-ip> has a very long delay (several minuttes) before it
PL> displays the text: Attempting to contact ... and then indicates a fine
PL> connection???
PL> 4) sqlplus takes a minute or more to establish a connection, however when
PL> connected select speed is fine
PL> 5) An application opening several sessions and selecting some data takes
PL> 20-30 minuttes or more initialising!!




Received on Thu Jun 03 1999 - 03:12:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US