| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: firewall timeout sessions
This does not really solve your problem, but my observation is that jobs
that run for over half an hour without user interaction are most likely
batch jobs and overall it is likely that a better solution than overcoming
the disconnection time out is an engineering change that puts the batch
database job on the database server and gives you a way to check for whether
the job is complete so you can retrieve the results.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Ivan Chow
Sent: Tuesday, June 29, 2004 11:32 AM
To: oracle-l_at_freelists.org
Subject: firewall timeout sessions
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
 |
 |