Linux & port-forwarding Oracle connections

Hello everyone,

I'm having trouble configuring port-forwarding on a Red Hat 6.1 system to enable clients on the Internet to connect to an Oracle8 database on a Windows system.

I can successfully connect from the Linux box to the Windows Oracle database using Oracle SQL*Plus for Linux.

The Linux box already has a database and web server running, so I want to forward a different port number to the services behind the firewall.

I already have port forwarding successfully working to two web servers on the LAN behind the Linux firewall, using the following commands:

ipmasqadm portfw -a -P tcp -L 200.200.200.200 50080 -R 10.1.1.110 80 ipmasqadm portfw -a -P tcp -L 200.200.200.200 50081 -R 10.1.1.100 80

Given that the Windows listener port is 1521, I would have thought that the following command would have configured port-forwarding for the Oracle database:

ipmasqadm portfw -a -P tcp -L 200.200.200.200 51521 -R 10.1.1.100 1521

However, when I tried to connect from an external client, I get a "could not connect" error. The Oracle database is identified in the tnsnames.ora on the client file with Host=200.200.200.200 and Port=51521. It wasn't obvious from the error where the problem was (the Linux port forwarding or the Oracle listener).

Any ideas? Is there a web page somewhere that describes how to configure this kind of setup?

Thanks in advance for any assistance.

-- 
Keith Woolner   keith@woolner.com  http://www.woolner.com