Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a public facing application server that accesses an Oracle database that resides behind a firewall.

Some of the processes that are executed through the application server can run for over an hour. This causes the firewall to disconnect the session without any error messages being generated. This causes the process to appear hung.

I've set the KeepAliveInterval to 1 second and KeepAliveTime to two hours in the registry.

I've set the enable=broken option in my tnsnames.ora file

The listener has the sqlnet expire time set to two minutes, so it's sending keepalives from that end as well.

The problem is, it doesn't seem to be working. On a different machine, I at least got a message that the firewall had disconnected the app-server (that's when I discovered the enable=broken requirement)

How do I make sure that the keep-alives are being sent?

share|improve this question

1 Answer 1

Why does the firewall disconnect the session? Is the firewall set to close connections that have been active too long? Or to close connections that have been inactive too long? If the firewall is set to disallow connections that persist for more than an hour, there probably isn't anything you can do in the network configuration-- you would need to change the configuration of the firewall.

From an architecture standpoint, do you really need to run hour-long processes from your application server? Normally, it would make more sense for the application server to make a request that causes a database process to run asynchronously (i.e. spawn a job using DBMS_SCHEDULER or DBMS_JOB) and then have the application server monitor the progress of the job. That way, you don't have a connection that is open continuously for an hour. And you can give the user some sort of progress indicator (particularly if the job is instrumented using, say, DBMS_APPLICATION_INFO).

share|improve this answer
    
We have some end-of-month jobs that run triggered by the user, instead of on a schedule. These jobs return their output in the form of a report. We've also had some data fix jobs that we've run from the servers, that have had this same disconnect issue. –  Brad Bruce Nov 13 '12 at 13:32
    
@BradBruce - Why is it necessary for either of those to be done synchronously, though? Why not have the client spawn the job, wait for the job to complete, and then display the report or retrieve whatever output you need? If rearchitecting the application isn't an option, any idea about the questions in the first paragraph? Is the firewall configured to disallow connections that are open too long? Or only those that are idle too long? –  Justin Cave Nov 13 '12 at 14:21

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.