Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Firewall Connection Issue (Timeout)

Re: Firewall Connection Issue (Timeout)

From: Ronald <devnull_at_ronr.nl>
Date: 8 Nov 2001 03:31:31 -0800
Message-ID: <67ce88e7.0111080331.544fd5d2@posting.google.com>


"Matt" <kadrovach_at_mediaone.net> wrote in message news:<YNpE7.33826$Gd6.788962_at_typhoon.mw.mediaone.net>...
> I am using an Oracle 8.1.6 instance on an AIX server that sits behind a
> firewall. It has "links" to other Oracle 8.1.6 databases on the other side
> of the firewall. The database on the secure side of the firewall is used for
> a WebSphere application server. It seems that the connection between the
> databases is terminated by the firewall (Cisco PIX), if it is not used for 1
> hour. From what my network administrator tells me, this is a normal
> operation by the firewall. The problem that this seems to create is: The
> Oracle database on the secure side of the firewall, does not know the
> connection has been terminated because it did not close it. So when the
> application server tries to use a table that is "linked", the action times
> out, because Oracle seems to be trying to use the terminated connection. Is
> there any way to correct this problem?

Hi Matt

just enable Dead Client Detection in the sqlnet.ora on the server side. This will on a regular basis check if the client (in you case an other database) is still there by sending a small package to the client.

Ronald.



http://ronr.nl/unix-dba
Ben je een ervaren dba en wil je dit wel eens ergens anders laten zien, mail me dan. Received on Thu Nov 08 2001 - 05:31:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US