Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Setting up a SQL*Net/Net8 Proxy?

Setting up a SQL*Net/Net8 Proxy?

From: Cstyle <toledodba25_at_hotmail.com>
Date: 11 Sep 2002 08:25:12 -0700
Message-ID: <21ea6d1e.0209110725.48482adf@posting.google.com>

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! Received on Wed Sep 11 2002 - 10:25:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US