Re: Connecting to an Oracle Listener process thru a firewall

From: Alan <alanshein_at_erols.com>
Date: Tue, 17 Jul 2001 12:59:23 -0400
Message-ID: <9j1qso$3qg$1_at_bob.news.rcn.net>


Contact your firewall vendor for their sqlnet proxy. Almost all firewall vendors have this available.

"Mahesh Menon" <mahesh_menon_at_caltiger.com> wrote in message news:5fcd4928.0107142200.4affd25c_at_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 Tue Jul 17 2001 - 18:59:23 CEST

Original text of this message