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
