Forum Discussion

brian_11825's avatar
brian_11825
Icon for Nimbostratus rankNimbostratus
Aug 17, 2010

Intermittent 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...
oracle
partner
bletardph_10497's avatar
bletardph_10497
Icon for Nimbostratus rankNimbostratus
Aug 04, 2011
Hi 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