Re: sqlnet and firewall

This could be the solution also for you: Enter on the ORACLE Server a new entry in the registry: In HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE add a new string named USE_SHARED_SOCKET with the value TRUE.

Dusan Recman
dusan_recman_at_europ-assistance.at

Dusan Recman schrieb in Nachricht
<7ajcup$3f6$1_at_fleetstreet.Austria.EU.net>...
>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 - 07:14:54 CST