Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Block access through listener by IP Range - Wildcard

483856Apr 12 2011 — edited Dec 21 2011

Hi,

I know you can block access to oracle database through listener using following configuration in sqlnet.ora

tcp.validnode_checking = yes
tcp.invited_nodes = (hostname1, hostname2)
tcp.excluded_nodes = (192.168.10.3)

but, is there a way to give IP-Range rather than giving individual address one-by-one.

for e.g

tcp.validnode_checking = yes
tcp.invited_nodes = (192.168.10.*,192.168.20.*)
tcp.excluded_nodes = (192.168.222.*,192.168.333.*)

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 18 2012

Added on Apr 12 2011

#database, #general-database-discussions, #oracle, #sql

3 comments

2,150 views