Re: NT 4.0 Oracle 7.3.3.0 SQLNet and Firewall

Allow me to take a stab at this one. World class SqlNet and TCP/IP experts can jump in at any time.

It is my understanding that you establish the initial connection via the Listener which passes it off to the database service which in turn fires up a private process for that specific connection. From that point forward, the SqlNet listener is out of the picture and all remaining conversations between the client and the database process would use a port above 2000 (kinda of dynamically assigned).

Of course, your network guys are going to be reluctant to open of ports above 2000 on the firewall. If the remote clients are employees telecomuting, you might explore the possibility of running a VPN. If the remote clients are customers, you might have to explore some type of 'application server' which can handle to communcations with the Oracle database.

Tom Kuczura wrote:

> Need Help,
>
> Can anyone enlighten me, ... Oracle 7.3.3.0 running on an NT 4.0
> server, this server sits inside a CheckPoint firewall, remote clients
> are connected by T1 line. Oracle SQL Net uses ports 1521 and 1526 'as
> designated in TSNAMES.ORA and LISTNER.ORA' in connecting to the server.
> I am having a problem with a THIRD port being used, which increments
> with the start of each session by the client outside the firewall. This
> firewall is maintained with strict VERY RULES.
>
> any help is appreciated
Received on Tue May 11 1999 - 23:48:04 CDT