Forum Discussion

dmattiuzzo_1794's avatar
dmattiuzzo_1794
Icon for Nimbostratus rankNimbostratus
Dec 08, 2014

Webservice behind F5 X Oracle active connections

Dear All,

 

I am facing a problem, and i am trying to found the root cause. I have two webservices balanced by F5(also failovered). Station machines call these two servers in order to build sql strings and send to oracle database. And get back the response. Some times after a datacenter reboot, oracle DB becomes flood of active sessions coming from these servers. So the database becomes unavailable until a DB reboot.

 

Does somebody know what can cause this situation? Can it be related to F5?

 

Thanks in advance!

 

3 Replies

  • Is the connectivity from the application server to your DB proxied through your F5? Is your F5 sending health checks to the webservice servers that result in queries being sent to the DB?

     

  • Hi Brad,

     

    The F5 is between station machines and webservice server. Between webservice server and DB i have nothing.

     

    Yes F5 send helth check to the webservice servers.

     

    • Brad_Parker's avatar
      Brad_Parker
      Icon for Cirrus rankCirrus
      I would check to see if that health check results in queries to the DB. If so I would investigate that a bit to see if the health check may be possibly causing the webservers to open to many sessions to the DB.