Home » RDBMS Server » Server Administration » Oracle Filrewall. (HP-UX 10g)
Oracle Filrewall. [message #475466] Wed, 15 September 2010 04:36 Go to next message
madhavamanohar
Messages: 58
Registered: February 2009
Member
HI Team,

How to eanble firewall for Oracle Datbases..?

Is it db specific..? or If I implement the firewall It will be applicable to all the databases in the server which are using same oracle home..?

Thanks
Mano.

Report message to a moderator

Re: Oracle Filrewall. [message #475467 is a reply to message #475466] Wed, 15 September 2010 04:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
There is no firewall inside Oracle.
Oracle does not care about firewall although you have to configure your firewall to open ports for Oracle.

Regards
Michel

Report message to a moderator

Re: Oracle Filrewall. [message #475475 is a reply to message #475467] Wed, 15 September 2010 04:47 Go to previous messageGo to next message
madhavamanohar
Messages: 58
Registered: February 2009
Member
Hi Michel,

Our reuirement is..we want to block some IP's for not to allow connections to the db.

Can this be implemented only on 1 database or will it be applicable on all the database in the oracle home?

Thanks
Manohar

Report message to a moderator

Re: Oracle Filrewall. [message #475493 is a reply to message #475475] Wed, 15 September 2010 05:33 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
I believe you can control that sort of thing via profiles, but there may be a more elegant way.

Report message to a moderator

Re: Oracle Filrewall. [message #475495 is a reply to message #475475] Wed, 15 September 2010 05:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Our reuirement is..we want to block some IP's for not to allow connections to the db.

Database Net Services Reference
Chapter 5 Profile Parameters (sqlnet.ora)
TCP.VALIDNODE_CHECKING
TCP.EXCLUDED_NODES

http://download.oracle.com/docs/cd/B19306_01/network.102/b14213/sqlnet.htm#sthref571

Regards
Michel

Report message to a moderator

Re: Oracle Filrewall. [message #475514 is a reply to message #475495] Wed, 15 September 2010 07:05 Go to previous messageGo to next message
jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai
Senior Member
Hi Manohar,

This can restrict access to specific IPs. But it will be applicable to all the databases in that specific Oracle Home.
Also the users who have login access to the database will not be able use the db from the restricted IPs.

Regards,
Antony

Report message to a moderator

Re: Oracle Filrewall. [message #475516 is a reply to message #475514] Wed, 15 September 2010 07:13 Go to previous messageGo to next message
John Watson
Messages: 8965
Registered: January 2010
Location: Global Village
Senior Member
If you have an Enterprise Edition license you can restrict access to particular services by using Connection Manager as a proxy server. It is much more sophisticated than doing it with the listener in sqlnet.ora.

Report message to a moderator

Re: Oracle Filrewall. [message #475522 is a reply to message #475514] Wed, 15 September 2010 08:00 Go to previous message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
If you want to keep the simplicity of sqlnet.ora then use several Oracle homes.
Otherwise you have to go to CMAN (Connection MANager) as John said.

Regards
Michel

Report message to a moderator

Previous Topic: ORA-01565: error in identifying file
Next Topic: error during installation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 23 23:49:09 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.