Oracle(보안) DB IP 접근 제한 환경설정

내 컴퓨터 IP 확인(macOS)

ifconfig | grep inet
ifconfig | grep inet | grep -v 'inet6'
ipconfig getifaddr en0

sqlnet.ora 변경

vi sqlnet.ora 

# 192.160.*,192.161.*,192.162.*,192.163.* 접근 제어
# localhost,STRDB01,192.168.0.111,192.168.0.11, 192.168.0.84 접근 허용
TCP.VALIDNODE_CHECKING = YES
TCP.EXCLUDED_NODES= (192.160.*,192.161.*,192.162.*,192.163.* )
TCP.INVITED_NODES=(localhost,STRDB01,192.168.0.111,192.168.0.11,192.168.0.84)

INVITED_NODES에 해당하는 IP만 허용

vi sqlnet.ora 

# localhost,STRDB01,192.168.0.111,192.168.0.11, 192.168.0.84 접근만 허용
TCP.VALIDNODE_CHECKING = YES
TCP.INVITED_NODES=(localhost,STRDB01,192.168.0.111,192.168.0.11,192.168.0.84)

참고

https://www.youtube.com/watch?v=aktnGkzJWTE