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
