Issue

[Marco_Broker]

Hi All ,

            May someone encountered this kind of issue . Below are the details.

A few months ago I installed a Fortigate 100D . In this network we have different vlans 9,10,20,30,40,60,70 and all these vlans have it own policy to access the internet, configured on the fortigate  .

Users in Vlan 10,20,30,40,60,70 are able to communicate with the server oracle in vlan 9 in order to get resources through policies create on the fortigate .

Not it happened sometime when users open a session in vlans 10,20,30,40,50,60,70 to access resource to server Oracle vlan 9

after 40 minutes of used the users got a error message .

Your database connection has been reset . Any pending transaction or session state has been lost .

But am still able to ping the server Oracle and to go the internet .

Thanking you in advance if someone find a solution for me.

[emnoc]

Maybe use the cli  cmd diag debug flow, but what's the oracle server seeing? Do you have idle KAs, or a enable session timeout, or something to have  the client+server know there's a session if the  client is idle. Does the oracle server have a min or mx idle timer?