Welcome to ISAserver.org

Webserver in perimeter to oracle in LAN

Users viewing this topic: none

Logged in as: Guest

Printable Version

All Forums >> [ISA Server 2004 Firewall] >> Access Policies >> Webserver in perimeter to oracle in LAN

Page: [1]

Message

<< Older Topic Newer Topic >>

Webserver in perimeter to oracle in LAN - 24.Sep.2004 4:02:00 PM

cdouma

Posts: 11
Joined: 10.Jul.2003
From: The Netherlands
Status: offline

I am trying to get my website (perimeter) to connect to the oracle database in the Internal network. I know it uses port 1521 so I created an acces rule for this port. A TNSPing goes perfectly, but I cant open a sql connection. Are there other ports I missed?

Post #: 1

Featured Links*

RE: Webserver in perimeter to oracle in LAN - 26.Sep.2004 4:51:00 PM

tshinder

Posts: 47669
Joined: 10.Jan.2001
From: Texas
Status: online

Hi C,

Is this a name resolution issue?

Is the a route or NAT relationship between the Web server's Network and the SQL server's network?

Thanks!
Tom

(in reply to cdouma)

Post #: 2

RE: Webserver in perimeter to oracle in LAN - 27.Sep.2004 12:43:00 PM

cdouma

Posts: 11
Joined: 10.Jul.2003
From: The Netherlands
Status: offline

I have made a routing rule from the perimeter to the internal network.

(in reply to cdouma)

Post #: 3

RE: Webserver in perimeter to oracle in LAN - 27.Sep.2004 1:40:00 PM

cdouma

Posts: 11
Joined: 10.Jul.2003
From: The Netherlands
Status: offline

I edited the rule to set open all outbound traffic from the web server to the oracle database server. The website can now succesfull setup sqlnet traffic.

Since it works when I set it all open I don't think its a name resolution problem.

(in reply to cdouma)

Post #: 4

RE: Webserver in perimeter to oracle in LAN - 28.Jun.2005 7:32:00 AM

dogfartbig

Posts: 23
Joined: 21.Jun.2004
Status: offline

The thing is that Oracle Uses 1521 for a primary connection and secondary connection is made by dinamic allocation of port above 1024 by the Oracle Dispecher. So if You want a specific port You must configure Multitread Oracle server with fixed port that will be opened.

(in reply to cdouma)

Post #: 5