Connecting to an Oracle Listener process thru a firewall

From: Mahesh Menon <mahesh_menon_at_caltiger.com>
Date: 14 Jul 2001 23:00:03 -0700
Message-ID: <5fcd4928.0107142200.4affd25c@posting.google.com>

Hi.

I am trying to connect to an Oracle Listener process thru a firewall. The Oracle Listener does not respond.

Here are the Firewall settings:

Oracle server address: XXX.XXX.XXX.XXX 1521 Firewall handoff settings: YYY.YYY.YYY.YYY 11521 (YYY.YYY.YYY.YYY is the firewall's adress).

In other words, anything the firewall receives on port 11521 is sent to the oracle server at port 1521. The Oracle Server doesn't seem to respond causing my Oracle client to time out.

Based on the limited debugging I have done, I am starting to believe this is because my client sends it's own IP address (while sending requests to the server). The server may be trying to respond to the oracle client directly without realizing that the request is coming thru a firewall.

And, of course, I have verified that the server is functioning normally. I am able to connect to it directly (without a firewall) without any problems.

Any help in this regard is appreciated.

Mahesh Received on Sun Jul 15 2001 - 01:00:03 CDT