Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Connection through firewall

Eric Z
Occasional Advisor

Oracle Connection through firewall

Oracle server is inside firewall.
IIS server is ourside firewall(sort of), which is Oracle DB client.
For Oracle server, we know that we can set to let only one port out. But how can I set IIS port range for inbound traffic.

Or any one can "redirect" me to relevant articles.

Thanks in advance.
10 REPLIES
Craig Rants
Honored Contributor

Re: Oracle Connection through firewall

Boy, you are asking for a heap of trouble bring IIS into this forum. As for oracle, ports to look at are 1526 and 1521, you will have to consult the tnsnames.ora and listener.ora file to verify that.

GL,
C
"In theory, there is no difference between theory and practice. But, in practice, there is. " Jan L.A. van de Snepscheut
Bill Hassell
Honored Contributor

Re: Oracle Connection through firewall

I hope you don't mind that everyone on the Internet can read the information sent by your Oracle server (and perhaps send bogus transactions to trash your database). If this data is important and/or confidential, don't even try to enable this until you get a security expert to design a secure method for Oracle on the open Internet. This is a lot more complicated than getting IIS to communicate.


Bill Hassell, sysadmin
Jeff Schussele
Honored Contributor

Re: Oracle Connection through firewall

Hi Eric,

I agree w/Bill 100%.
There are dozens of known Oracle exploits out in the field. And Oracle is one of the toughest apps to "lock down". The first issue to tackle would be ports. The client initially connacts on a specific port (usually 1521) but then client/server negotiate a higher port for further comm. This would have to be strictly controlled. You would definitely need expert help in this area.
I, myself, would never attempt it.

The better solution would be to move the client system inside the FW so the issue would become moot.

Rgds,
Jeff
PERSEVERANCE -- Remember, whatever does not kill you only makes you stronger!
David Burgess
Esteemed Contributor

Re: Oracle Connection through firewall

Open port 1521. However Bill is right. How about you put the webserver behind the firewall and open up port 80 or 8080. What about using a proxy in there too?

HTH

Dave.
Alberto Minichiello
Occasional Visitor

Re: Oracle Connection through firewall

Hi all:

Oracle's SQL*Net is a rather tricky protocol but it can be managed keeping in mind the following:

SQL*Net (on Unix) uses only one port which by default is 1521 and is defined in your listener.ora file (for the rdbms server) and tnsnames.ora (for the client).

According to the info I got on SQL*Net (which you can get a hold of in Oracle's Metalink look for Notes 125021.1 and 66382.1) There are two exceptions on which SQL*net will negotiate the port number (once again in Unix):

a) Your RDBMS Server is configured with the Multithreaded Server option
b) you are using Oracle SSL

In case your installation is using MTS (MultiThreaded Server) you can specify on which port number each dispatcher will listen.

As for SSL the docs I mentioned are less clear on what to do, they say that the ports can be specified but give no examples. They also mention that an alternative (if you are using SQL*net version 8) would be to use a software package called Oracle Conection Manager which supposedly can do things like discriminate from which IP addresses will accept connections and will also show a fixed port number so the traffic can be rerouted via a packet filtering firewall.

On NT Oracle WILL negotiate the port number regardless of what options you are using , but it can be forced (after setting a registry key called USE_SHARED_SOCKET)

Some proxy based Firewalls (such as Gauntlet) include a proxy for SQL*net, however this is in itself a can of worms since of course there at least two different versions of the protocol that they must support and also there is the usual problem with such firewalls: Performance)

Hope this helps

Regards
Bonum Est
Andreas D. Skjervold
Honored Contributor

Re: Oracle Connection through firewall

Hi

Your firewall software must be Oracle compillant , ie must be able to resolve the port redirect that the listener does.

If your Firewall don't handle this you'll have to look into the Oracle Connection Manager to manage the ports in use.

mvh
Andreas
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!

Re: Oracle Connection through firewall

We use Raptor (now called Symantec Raptor) for such connections.
Eric Z
Occasional Advisor

Re: Oracle Connection through firewall

At last I joined a forum that I can get some useful answers. ;-).
Thanks, every one.

Make it clear:
1. IIS is not actually outside firewall. We have two layer firewalls, in the middle of which IIS Server is.
2. Oracle Server is inside the second layer firewall, which is completely shutdown for all traffics right now, even for the traffics from hosts inside first layer.
3. I am the DBA. We are think of open some ports for IIS Server. But before that we must be able to predict the port range that will go in. (I could be wrong. I think that once the door is open, how wide it is doesn't make much of difference. But it isn't my position to comment.)
4. As I said, there is no problem to predetermine the port on Oracle Server side.
5. The question is still that how we can limit the port range from the Oracle client side. Has anyone done that before? On NT and UNIX.

Thanks again.
Eric Z
Occasional Advisor

Re: Oracle Connection through firewall

No offense.

I signed the point according to usefulness of message to me. Not on the message itself. All the message are good. But not all of them helped me.
Eric Z
Occasional Advisor

Re: Oracle Connection through firewall

Thanks Andreas D.. I have already been looking into CMAN.