I am running 8.0.4.3.1 on AIX 4.3.3. Our users connect through a
firewall to the database. We have DCD set up on 10 minute timers, and
the firewall has a 30 minute idle timeout. Under normal circumstances,
the DCD probe to the client is enough to keep the connection alive,
even if the user is truly idle. However, we have, on very rare
occasions, had some sort of problem where this stops working. It seems
to happen after the server has been up for 8-9 months without a
reboot. For whatever reason, the DCD probe doesn't make it through the
firewall properly, so the firewall times out the users, but the
database connections don't get cleaned up. This leads to us exceeding
the maximum number of user connections. Bouncing the database clears
current connections but doesn't solve the problem; rebooting the
server does. I know we have seen this at least twice, with different
apps, both running against 8.0.4.3.1 databases. Does anyone know if
this is a known bug in Oracle, AIX, both?
Thanks
Roy Speaker
Received on Sat Apr 27 2002 - 21:38:13 CDT
