Oracle Server dropping sessions Frequently

Question

I have an oracle server which is dropping Sessions (Connections) frequently, with just about 5 minutes idle time it is dropping the connection. Resource limit is not set on this server, and the IDLE_TIME for the User profile is set to unlimited, the strange thing is this happens even when we create a new instance, and that too behaves in the same way.

I am using Oracle 10g R2 on Windows 2000.

Answer 1

Hi Dinesh,

this could be caused by a firewall rule (kill idle connections after X minutes). You could check this SO question and ask your network administrator to check the firewall configuration.