Firewall dropping connection every ~50 days

[RahilShaikh4066]

Hello Everyone,

I have been trying to figure it but unable to know what's the problem. 

Our Oracle database server is behind the Cisco ASA firewall and after every 50 days, it randomly drops/closes few connections from its side, but the connection object is still inside the connection pool of the application. 

As soon as I try to that connection which has been broken, my application gets stuck due to TCP Retransmissions and Timeout algorithm is kicked in. 

Application---------->ASA(Firewall)----------->OracleDatabase. 

This actually puts my application is in blocking state which is only recovered once TCP Timeout is reached. 

Can someone please help me...!!

thanks

--

Raj

[Marvin Rhoads]

Thanks for suggesting the database change. Most problems in information technology can be solved multiple ways.

We endeavor to keep a professional approach here at Cisco Communities so that we can all benefit in a non-judgemental environment.