Thursday, June 7, 2012

Persistent Connections from database on Cisco Firewall

I've posted before about how our Cisco firewall tears down inactive connections and modifying the tcp_keepalive_time on the Linux kernel so as to not loose the connection. Similar options exist on the database side.

If you're running MySQL then update /etc/my.cnf to have:

wait_timeout=900

If you're running an Oracle then update sqlnet.ora to have:
SQLNET.EXPIRE_TIME=10
This option is in $ORACLE_HOME/network/admin/sqlnet.ora.

No comments: