Re: oracle database connection timed out
The answer by Toshi is one part of it- there is also a config change on the oracle side. You need to add the line SQLNET.EXPIRE_TIME to your sqlnet.ora. That parameter sets a time in minutes for the server to check if a client is still connected. this causes a small amount of traffic on port 1521 and keeps the connection alive for the firewall to reset the session TTL. In general, most people set the SQLNET.EXPIRE_TIME = 10 which would do a keepalive (in effect) every 10 minutes. As long as the session-ttl setting on the fortigate is greater than that, you should not have any more oracle timeouts. The oracle setting also has the side effect of purging stale connections that didn't terminate properly which helps when you need to change the online or mount status of the oracle system.
Some FGT500Es, 500Ds, 60Ds at work
FWF60E, FWF80CM at home