Re: Setting up a SQL*Net/Net8 Proxy?

On 11 Sep 2002 08:25:12 -0700, toledodba25_at_hotmail.com (Cstyle) wrote:

>We put a firewall in place locally this morning, and now I can't
>connect to oracle from my desktop. I can ping the machine, but when I
>try to get in through SQL Plus or DBA Studio I get the error
>'ORA-12535: TNS:operation timed out'. The port in tnsnames.ora is
>open through the firewall. I've been reading on meta link how to
>trouble shoot the error with Note:119706.1. If you look at that note
>it contains the following tid bit on firewalls with windows:
>
>Note A
>2. If you are going through a Firewall, and your server platforms are
>NT,
> then you must ensure that the port being listened on is open as
>well as
> setting up a SQL*Net/Net8 Proxy, such as Net8 Connection Manager,
>if none
> is provided by the Firewall vendor.
> The reason is that, even though the port is open, the TCP layer
>will
> REDIRECT the port to another port.
> This is due to Winsock2 workings under Microsoft.
>
>OK, how do I set up a SQL*Net/Net8 Proxy? Any ideas? I'm looking
>around Oracle Net8 Assistant and I'm not seeing anything. Any help
>you could give would be great!

The best idea would the read the note you were referred to, note 68652.1
as that contains all possible solutions to firewall issues, and not only one.

A sqlnet proxy should be sold by the vendor providing the firewall.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Sep 11 2002 - 13:45:32 CDT