firewall timeout sessions

From: Ivan Chow <ichow2_at_hotmail.com>
Date: Tue, 29 Jun 2004 11:31:35 -0400
Message-ID: <BAY12-F55AZXA9DC3ea0001fb99@hotmail.com>

Hi,
I have a 4hr job that kept on getting disconnected from the database server due to a firewall security policy. The firewall timeout any sessions that have been idling for more than 30mins. The job runs on a HPUX server and connects to the database server(9204) running on an IBM AIX.

I tried setting different values (ranges from 60 to 1800) in my sqlnet.expire_time but that did not help resolve the problem. My understanding is setting expire_time probes the connection between the client and the server to make sure that connections are still in use. I was hoping that will prevent the firewall from timing out my connection.

Are there any other parameters that should be configured?

thanks.

Ivan

Is your PC infected? Get a FREE online computer virus scan from McAfee® Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Tue Jun 29 2004 - 10:28:30 CDT