Firewall Problem with Oracle 8.1.5 on Linux SQL *NET

From: Michael Poremski <michael_at_poremski.de>
Date: 2000/03/12
Message-ID: <qrjlcssn3firhe3jfg1oq5n502cc6ldu9a@4ax.com>#1/1

Dear Experts,

I have a really big problem to connect to a Oracle 8.1.5 DB that is installed after a Firewall. The Ports 1521 & 1526 are administrated by the firewall administrator. If I want connect to the Oracle DB then I get no connection.

If I check the LISTENER.LOG File on the Oracle Server (ALL Ports are opened on the Firewall!) then I can see that every connection used an dynamical (?) own Port (like 1061, 1134, 1184 ..)

I'm a Oracle novice, but I hope that some users want help me. How can I configure the Oracle DB that all comunication are going to one Port? Is it possible?

Which files must I configure and which values must I change? Sorry, I use Oracle 8.1.5 on Linux and the Client is a Windows NT computer. I use the Oracle 8 AND on an other computer an Oracle 7.3.x Client.

My TNSNAMES.ORA File:

oraedv.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (PROTOCOL = TCP)

          (Host = 192.168.200.2)

          (Port = 1521)

        )

    )
    (CONNECT_DATA = (SID = orcl)
    )
  )

Thanks for every advice. I have a really big problem with my boss, if I can't find a solution. Thanks!!!

Michael Received on Sun Mar 12 2000 - 00:00:00 CST