I'm having problem accessing an Oracle database that I have recently placed behind a Netgear RT314 Router. I forwared port 1521 to the server which has a static IP and am able to remotely TNSPING the database through the router's IP. The problem comes when using higher level tools like SQL*Plus and Forms/Reports.
I'm running NT 4.0 on both the client and server machines and connecting via the Internet. I have no problem connecting without the router in place. When checking the port network communications while attempting to connect with SQL*Plus I found that the server ACK's with it's own IP not the IP of the router. Is there something wrong with the NAT configuration?
Also, I had to shut down ZoneAlarm since it blocks incoming traffic from the client IP which is not a static IP and so could not be registered as safe. Any way around this?
One more qusetion. Is there any way to access the router's SYSLOG's? That might make the network traffic patterns a little easier to diagnose.