Oracle Database Behind Firewall (proxy server)- Cannot Connect
I cannot access Oracle database behind a proxy server, using SQLPlus or JDBC client. Is it a known problem or is there a workaround ??
The detail story is as follows:
I have Oracle 8.1.7 database installed behind a firewall. Its IP address is 192.168.1.2. The external address of this database is say 44.55.66.77
When the client (outside the firewall) tries to access the database using SQLPlus with IP address 44.55.66.77. It was able to hit the database. But the database kindof of gives the address of 192.168.1.2 to the client. So when the client wants to access the database eventually, it uses the address of 192.168.1.2, which of course cannot access the database. Any clue how to fix this problem??
Any help is really appreciated