Re: How to access Oracle database through firewall?

Just a suggestion,

Instead of specifying the hostname of the server or it's IP address in the net8 configuration setup on the client, use the firewall IP address x.x.x.x.

Regards
Priyesh

www.mercurie.co.uk

"EL_Chicho" <jerrysenf_at_yahoo.co.uk> wrote in message news:3D028F04.3E1394E1_at_yahoo.co.uk...
> How to connect to the Oracle server which resides behind firewall and
> which is using non-routable local address e.g. 192.168.100.10?
>
> Situation:
> Oracle Listener and database server is on local IP address
> 192.168.100.10, client is on valid Internet address e.g. y.y.y.y and
> firewall is on IP address x.x.x.x. Firewall reroutes every packet from
> y.y.y.y. to Oracle server and vise verse (using IP-masquerade).
> When client connects to the Oracle server it actually connetcs to the
> firewall IP address on port 1521, firewall reorutes packets to the
> Oracle server and listener respondes to the client thorugh firewall.
> But when client is trying to connect to the database server opening
> another TCP/IP connection he tries to connect to the 192.168.100.10 IP
> address which is actuall address of server, but this address is
> non-routable!!!!
> I guess that Ora listener sends this address of Oracle server to the
> client when he tries to open link to the database because listener is
> only dispatcher for incoming client requests!
> How to configure Oracle Listener to be 'aware' that Oracle server has
> non-existing or non-valid IP address?
>
>
> Thanx
>
>
Received on Sun Jun 09 2002 - 12:29:23 CEST