Forum Discussion
brian_11825
Nimbostratus
NimbostratusIntermittent connection errors
We have a Big-Ip VIP fronting our two-node Oracle RAC. All too frequently we get application connection errors when connecting through the VIP. The nodes are fine and connecting directly to them works...
bletardph_10497Nimbostratus
NimbostratusHi Chris, Rcorder,
First of all thanks for your help !
I will try to start sniffing the traffic today...
These are the parameters in the sqlnet.ora file:
NAMES.DIRECTORY_PATH= (TNSNAMES)
TCP.CONNECT_TIMEOUT=10
SQLNET.EXPIRE_TIME=10
In the several tests I've made, I've also tried setting SQLNET.EXPIRE_TIME=0 (to try with the connections left open indefinitely) but still the same...
I've also added a screenshot of the client tcp profile... I had unchecked the 'Reset On Timeout' to avoid the RST but I will check it again...
BR,
Phil
