Reputation: 1932
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.
Upvotes: 0
Views: 2953
Reputation: 67722
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.
Upvotes: 1