• RSS
  • Twitter
  • FaceBook

Welcome to ISAserver.org

Forums | Register | Login | My Profile | Inbox | RSS RSS icon | My Subscription | My Forums | Address Book | Member List | Search | FAQ | Ticket List | Log Out

Accessing Oracle on my ISA Server

Users viewing this topic: none

Logged in as: Guest
  Printable Version
All Forums >> [ISA 2006 Firewall] >> Access Policies >> Accessing Oracle on my ISA Server Page: [1]
Login
Message << Older Topic   Newer Topic >>
Accessing Oracle on my ISA Server - 25.May2009 12:20:01 PM   
isa_rooky

 

Posts: 48
Joined: 22.May2009
Status: offline
Hi everybody,
I have Oracle 10g installed in the same server where I Have ISA Server 2006 SE and now I'm not able to connect to Oracle because the ISA firewall is blocking my connection to port 1521 which is the one Oracle uses to communicate. Is there a way to open that port on the ISA server so I can connect from my computer to my Oracle database through my internal network?
Post #: 1
RE: Accessing Oracle on my ISA Server - 25.May2009 2:06:01 PM   
paulo.oliveira

 

Posts: 3472
Joined: 3.Jan.2008
From: Amazon, Brazil
Status: offline
Hi,

this is definitly not best practice! You should not install any other service together with ISA firewall. IMHO, especially if it is a DB, because of the workload.

Install Oracle DB on another machine.

Regards,
Paulo Oliveira.

_____________________________

Microsoft Premier Field Engineer (PFE)
Blog: http://poliveirasilva.wordpress.com/
Twitter: https://twitter.com/poliveirasilva

(in reply to isa_rooky)
Post #: 2
RE: Accessing Oracle on my ISA Server - 25.May2009 2:08:51 PM   
isa_rooky

 

Posts: 48
Joined: 22.May2009
Status: offline
Hi Paulo and thanks for your reply.
The problem is that where I work the budget is pretty low and that's the only server I have where Oracle and Isa server can rum pretty well.

(in reply to paulo.oliveira)
Post #: 3
RE: Accessing Oracle on my ISA Server - 25.May2009 3:05:53 PM   
paulo.oliveira

 

Posts: 3472
Joined: 3.Jan.2008
From: Amazon, Brazil
Status: offline
Hi,

ok, thatīs up to you and your company to decide if it better to invest on a new server or take the risk and put those two services togheter.

Backing to your question, create an access rule like this:

Name: <whatever>
Action: Allow
From: Internal
To: Localhost
Condition: All users

Regards,
Paulo Oliveira.

_____________________________

Microsoft Premier Field Engineer (PFE)
Blog: http://poliveirasilva.wordpress.com/
Twitter: https://twitter.com/poliveirasilva

(in reply to isa_rooky)
Post #: 4
RE: Accessing Oracle on my ISA Server - 25.May2009 3:13:02 PM   
isa_rooky

 

Posts: 48
Joined: 22.May2009
Status: offline
Hi Paulo and thanks for your help.
Do I need to tell ISA Server what port am I using to connect to Oracle?

(in reply to isa_rooky)
Post #: 5
RE: Accessing Oracle on my ISA Server - 25.May2009 3:51:01 PM   
paulo.oliveira

 

Posts: 3472
Joined: 3.Jan.2008
From: Amazon, Brazil
Status: offline
Hi,

  my mistake...

Yes, you do.

Regards,
Paulo Oliveira.

_____________________________

Microsoft Premier Field Engineer (PFE)
Blog: http://poliveirasilva.wordpress.com/
Twitter: https://twitter.com/poliveirasilva

(in reply to isa_rooky)
Post #: 6
RE: Accessing Oracle on my ISA Server - 25.May2009 4:17:35 PM   
isa_rooky

 

Posts: 48
Joined: 22.May2009
Status: offline
Ok, thanks.

(in reply to paulo.oliveira)
Post #: 7
RE: Accessing Oracle on my ISA Server - 25.May2009 9:54:09 PM   
isa_rooky

 

Posts: 48
Joined: 22.May2009
Status: offline
Hi again Paulo,
I forgot to ask you which port should I add to allow the connection to Oracle when I create the access rule. Can you please help me on this?
Thanks!

(in reply to isa_rooky)
Post #: 8
RE: Accessing Oracle on my ISA Server - 25.May2009 10:09:50 PM   
SteveMoffat

 

Posts: 1130
Joined: 29.Jun.2001
From: Hamilton, Bermuda
Status: offline
LOL...remove ISA from that server & buy a linksys router / firewall....

Do you have any idea what you are doing?????  That is one big assed security nono!!!

_____________________________

Thanks
Steve

ISA 2006 Book! - http://tinyurl.com/2gpoo8
TMG Bible - http://tinyurl.com/ykv85hr
www.isaserver.bm

The built in ISA help is likely the most comprehensive help built into an application anywhere. USE it!!! Search it!!! RTFM

(in reply to isa_rooky)
Post #: 9
RE: Accessing Oracle on my ISA Server - 26.May2009 9:45:07 AM   
paulo.oliveira

 

Posts: 3472
Joined: 3.Jan.2008
From: Amazon, Brazil
Status: offline
Hi,

I donīt know what protocol Oracle uses, but I guess you identified before
quote:

...I have Oracle 10g installed in the same server where I Have ISA Server 2006 SE and now I'm not able to connect to Oracle because the ISA firewall is blocking my connection to port 1521...


Regards,
Paulo Oliveira.

_____________________________

Microsoft Premier Field Engineer (PFE)
Blog: http://poliveirasilva.wordpress.com/
Twitter: https://twitter.com/poliveirasilva

(in reply to isa_rooky)
Post #: 10
RE: Accessing Oracle on my ISA Server - 26.May2009 11:48:22 AM   
isa_rooky

 

Posts: 48
Joined: 22.May2009
Status: offline
Hi again Paulo,
Yes I know the Oracle port number, but what I want to ask you is: when you are setting up ISA server to access Oracle, there's an option when you need to asign a protocol that tells you: This rule applies to: 1) All outbound traffic. 2) Selected protocols and 3) All outbound traffic except selected.
Which one should I choose?

Thanks in advance!

(in reply to paulo.oliveira)
Post #: 11
RE: Accessing Oracle on my ISA Server - 26.May2009 12:10:36 PM   
SteveMoffat

 

Posts: 1130
Joined: 29.Jun.2001
From: Hamilton, Bermuda
Status: offline
Seriously dude, DO NOT install Oracle on your ISA Server....it's a firewall not a database server.....

_____________________________

Thanks
Steve

ISA 2006 Book! - http://tinyurl.com/2gpoo8
TMG Bible - http://tinyurl.com/ykv85hr
www.isaserver.bm

The built in ISA help is likely the most comprehensive help built into an application anywhere. USE it!!! Search it!!! RTFM

(in reply to isa_rooky)
Post #: 12
RE: Accessing Oracle on my ISA Server - 26.May2009 12:19:41 PM   
isa_rooky

 

Posts: 48
Joined: 22.May2009
Status: offline
Hi Steve,
I know what you mean, but there's nothing I can do about it because where I work the budget is pretty low. I'm trying to set a PC as server and buy some more ram to make it work with Oracle so by then, that's all I can do.

Thanks for your advice!

(in reply to SteveMoffat)
Post #: 13
RE: Accessing Oracle on my ISA Server - 26.May2009 12:22:52 PM   
SteveMoffat

 

Posts: 1130
Joined: 29.Jun.2001
From: Hamilton, Bermuda
Status: offline
Then buy a small firewall appliance....putting Oracle on your firewall is bad for security of your network.

With the money you save from not having to buy ISA you should get a decent Soniocwall or equivalent.

_____________________________

Thanks
Steve

ISA 2006 Book! - http://tinyurl.com/2gpoo8
TMG Bible - http://tinyurl.com/ykv85hr
www.isaserver.bm

The built in ISA help is likely the most comprehensive help built into an application anywhere. USE it!!! Search it!!! RTFM

(in reply to isa_rooky)
Post #: 14

Page:   [1] << Older Topic    Newer Topic >>
All Forums >> [ISA 2006 Firewall] >> Access Policies >> Accessing Oracle on my ISA Server Page: [1]
Jump to:

New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts