Re: [ILUG-BOM] Restrict Access to Oracle

Create $ORACLE_HOME/NETWORK/ADMIN/PROTOCOL.ORA

and specify which IP addresses to allow and deny. For example, to allow 192.168.255.1 and deny 192.168.255.2 and 192.168.255.3, add the following lines:

tcp.validnode_checking = YES tcp.invited_nodes = (192.168.255.1) tcp.excluded_nodes = (192.168.255.2, 192.168.255.3)

On 20 Dec 2004 07:07:19 -0000, Sneh D my_linux@rediffmail.com wrote:

Hi all, I have Oracle Server Installed on RHEL on an IBM Server.I want to restrict access to oracle from specific machines on the network.I tried denying access to the SQLNET service by adding an entry into the /etc/hosts.deny file,but it isn't working.Now I don't know how to achieve this.I'll be greatful if anyone on the list helps me out ith this. Regards, SD.

-- http://mm.ilug-bom.org.in/mailman/listinfo/linuxers