[TD-ORACLE] Oracle IP Access Control

 

 

1. Oracle IP Access Control

 

# sqlnet.ora Network Configuration File: /oracle/app/oracle/product/11.2/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE = /oracle
TCP.VALIDNODE.CHECKING = YES
TCP.INVITED_NODES =(192.168.56.11,192.168.56.1) <= allow IP list
TCP.EXCLUDED_NODES=(192.168.57.0)                 <= deny IP list 

 

 

I tried testing IP access control with ip arrange  but it is not work

 

Do not define TCP.EXCLUDE_NODES if you want to block the entire all except allow IP