Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Firewall
Port 1521 is used to get the initial connection. Oracle then chooses a
random open port and sends the client back the new address, making it
difficult if your traffic is coming through a firewall. Your resulting error
will be TNS-12203.
If it is on NT, add a registry setting under Oracle for
USE_SHARED_SOCKET=TRUE. This way, it will only use the port the listener is
on (i.e. 1521).
Check out Note 2064550.102 in MetaLink for some work-arounds to avoid
opening up your firewall. (Go to 'TECHNICAL LIBRARIES' and then choose the
'Firewalls' section).
John Alexander
www.SummitSoftwareDesign.com
St. Petersburg, FL
Oliver Huppert <oliver.huppert_at_pikon.com> wrote in message
news:9c0r1r$g4j$1_at_piesbach.saarnet.de...
> Hi *.*
>
> I've got a problem in using a firewall on a oracle server.
> The listener from this DB is on port 1521, but every time on connection to
> the DB
> the client gets 2 other ports from the server. So the firewall blocks the
> connection.
>
> Is there a way to say oracle wich ports it should use?
> So that I have a range of ports which I can tell the firewall.
> Because I donĀ“t want to free all ports to this server.
>
> nice regards
> Olli
>
>
>
>
Received on Wed Apr 25 2001 - 19:31:13 CDT