Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Firewall Connection Issue (Timeout)
"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.
![]() |
![]() |