Oracle Filrewall. [message #475466] |
Wed, 15 September 2010 04:36 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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.
|
|
|
|
Re: Oracle Filrewall. [message #475475 is a reply to message #475467] |
Wed, 15 September 2010 04:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|
|
Re: Oracle Filrewall. [message #475514 is a reply to message #475495] |
Wed, 15 September 2010 07:05 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
Re: Oracle Filrewall. [message #475516 is a reply to message #475514] |
Wed, 15 September 2010 07:13 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 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.
|
|
|
Re: Oracle Filrewall. [message #475522 is a reply to message #475514] |
Wed, 15 September 2010 08:00 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
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
|
|
|