Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Setting up a SQL*Net/Net8 Proxy?
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