Oracle Redirect Packet

I am attempting to connect using SQLPlus from either Linux or NT at home to an Oracle database (8.0.4) at work that is behind a firewall. The firewall listens to an ip of say 204.71.200.74 and forwards any traffic for this ip to an internal ip address of 10.1.1.1. I have logging turned on under Linux and when I do a simple sqlplus user/password_at_mywork I get ora-12203: TNS:unable to connect to destination. In the trace file, I use trcasst to view the output and I can see the redirect packet that I receive contains the internal ip address, not the external ip address. Here is a snippet:

....snip....

<--- Received 71 bytes - Redirect packet

        Redirect data length: 61
(ADDRESS=(PROTOCOL=tcp)(DEV=648)(HOST=10.1.1.1)(PORT=3843))
....snip....

So when SQLPlus tries to connect to the newly assigned port, it fails due to the ip address of 10.1.1.1. I do have OAS 4 running on the same box at work and I can connect to the applications on that with via web browser no problem, but there's no redirect packets containing the internal ip address going on there.

I'd like to do one of the following:

1. Get Oracle to send a redirect packet with the outside ip address of the firewall.
2. Set up my Linux box or NT box to translate the 10.1.1.1 ip address to 204.71.200.74.

I know SQLNet at home is fine I can connect to a different box at work that is on the outside of the firewall. Just the fact that I get the redirect packet from the box behind the firewall should tell me that it's set up properly or atleast aiming at the correct box.

At home, I use my Linux box w/ cable modem as my firewall and NT Server s just where I'm developing. I have Oracle 8.0.5 on Linux (just utilities that came with it anyway - no db) and 8.0.4 on NT (client only - no db). I attempt some of this from my Linux box just to make sure my own firewall and forwarding is fine.

Thanks for any help!

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 16 1999 - 08:51:01 CDT