Understanding PRECONNECT network connections
Hi,
I have a 2 node Oracle 11g RAC system that appears to be working fine. I am trying to understand from a client perspective what I should be seeing. On the server side here is my tnsnames.ora...
RAC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC.COMPANY)
)
)
LISTENERS_RAC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
)
RAC2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC.COMPANY)
(INSTANCE_NAME = RAC2)
)
)
RAC1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RAC.COMPANY)
(INSTANCE_NAME = RAC1)
)
)
On the client side I am using the following jdbc URL...
jdbc:oracle:oci:@(DESCRIPTION\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=rac1-vip.company.com)(PORT\=1521))(ADDRESS\=(PROTOCOL\=TCP)(HOST\=rac2-vip.company.com)(PORT\=1521))(LOAD_BALANCE\=yes)(CONNECT_DATA\=(SERVER\=DEDICATED)(SERVICE_NAME\=RAC.COMPANY)(FAILOVER_MODE\=(TYPE\=SELECT)(METHOD\=PRECONNECT)(RETRIES\=90)(DELAY\=1))))
What I thought I would see when connecting was two established connections (one to each node of the cluster), this is not the case. Sometimes, in fact most times, I will have two connections to the same node...
tcp 0 0 iglinux.company:33273 rac1-vip.iglinux.company:1521 ESTABLISHED
tcp 0 0 iglinux.company:33271 rac1-vip.iglinux.company:1521 ESTABLISHED
tcp 0 0 iglinux.company:33270 rac2-vip.iglinux.company:1521 TIME_WAIT
tcp 0 0 iglinux.company:33272 rac2-vip.iglinux.company:1521 TIME_WAIT
Notice the connections in TIME_WAIT also. This could be the reverse with the established connections on rac2. What should I be seeing here?
Also can someone confirm that the thin client does not support TAF and that I must use the oci driver?
Thanks in advance.
Edited by: user650217 on Dec 24, 2008 7:00 AM