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

사업자 정보 표시
(주)블루원 | 김홍태 | 서울특별시 용산구 원효로 4가 135 금홍 2빌딩 | 사업자 등록번호 : 106-86-76684 | TEL : 02-3272-7200 | Mail : support_ora@blueone.co.kr | 사이버몰의 이용약관 바로가기

+ Recent posts