Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help - Firewalls and Oracle 7.3.2
David Sisk wrote:
> Joe:
>
> There's a few different ways that you can do this. The problem you're
> having is this: When you first attempt to connect, the SQL*Net listener on
> the IP address and port that you've specified accepts the client's
> connection request. It then tells that client "I'll tell the database
> process to spawn a thread for you that's on this dynamically-assigned,
> currently unused port number". Then the client disconnects from the
> listener and reconnects to the database process on the port number that it
> was told about. When you put a firewall in the middle of this process, the
> port the client tries to reconnect to isn't available (because it was
> dynamically-assigned). The only way this would work is if you opened up all
> ports on the firewall, but then there's no point in having a firewall :=)
>
> In Oracle8 (specifically, the Net80 listener) you can make a registry
> setting to tell it to use .....??? I can't remember what it's
> called,...simultaneous connections or something like that. (Sorry.)
You're probably referring to the share_sockets thing when everyone is using the same port (most likely 1521). Received on Wed Jul 14 1999 - 21:05:49 CDT