Re: sqlnet and firewall

Hi Marc and Jim!

I have the same problem as you do. I activated tracing on the DB-Server and discovered that the firewall is forwarding the connection request from the internal network card with another PORT that I defined (1521). Please , let me know if you find out something more.

Dusan Recman
dusan_recman_at_europ-assistance.at

Mark A. Hepler schrieb in Nachricht <36CB9E12.5F935D6E_at_mediaone.net>...
>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 Fri Feb 19 1999 - 04:05:20 CST