Hello
We have had this issue for sometime now. We have solved it for numerous sites with dedicated L2 connections but for some outstanding sites with s2s VPN tunnels (asa to asa) we still run into it.
Basically when the VPN rekey's the SA (sametime everyday) all Oracle sessions are dropped. The tunnel stays up and the user stays connected but the oracle sessions ALWAYS drops. I cant for the life of me find a way to stop this from happening and it only happens with Oracle. It happens to both remote vpn clients and vpn tunnels.
Does anyone have any idea what I can do to pinpoint or log the problem from the ASA's?