Re: sqlnet and firewall

Jim,
I've been experiencing the exact same symptoms as you have described. tnsping works, but when I try to connect via SQLPlus or ODBC I get an ORA-12203: TNS:unable to connect to destination. C. Day's reply to your message seems accurate. The server seems to be attempting to open another connection back to the client on another port. But I have not figured out how to restrict it to a single port that I can configure through the firewall. I'll let you know if I have any luck figuring this out. Would appriciate if you would do the same. Thanks, and good luck.

Mark Hepler

Jim Kennedy wrote:

> Anyone know how to access SQL net through a firewall?
> Scenario:
> Oracle on NT inside with an address say 10.10.10.2
> and a fire wall makes that address appear as 200.200.200.5 to the outside
> world. tnsping80 works fine, but not a connection.
> It looks like the reply on a connection redirects to another port and sends
> the address back (and the firewall does not catch the 10.10.10.2 and
> translate it to 200.200.200.5)
> Ip addresses have been changed to protect the innocent.
> Jim
Received on Wed Feb 17 1999 - 22:58:58 CST