Re: Oracle and Firewall

Hi Wanni,
It's sqlnet 2 actually, which uses two ports for a connection, the second port is negotiated between the client and the server, the numbers are more or less random. In Oracle 8 you have the option of sharing the port 1521 for two-way communications. In Oracle 7/sqlnet2 you could consider setting up protocol.ora on the server, which enables you to limit or extend the range of invited/excluded nodes and ports.

Hth,

Sybrand Bakker, Oracle DBA

Wanni wrote in message ...
>Hi Readers,
>
>We are facing a problem connecting oracle client to an oracle server
>behinda firewall. When we removed the Firewall and connect the client
>and server directly (through routers only). No problem at all.
>
>We also noticed that during the setup connection with the firewall, the
>listener.log from the server records a log entry for each client's
>connection.
>However, nothing seems to happen after that.
>
>Is this a problem with IBM Firewall or does this has to do with the
>Oracle Server version itself?
>
>More information:
>Oracle server version 7.3.3 for Windows NT
>Oracle client using SQLPLUS Win95 and Unix versions.
>IBM Firewall version 3.2
>
>
>Thanks for your replies!
>
>Regards,
>Wanni
Received on Thu Jun 24 1999 - 11:55:50 CDT