可以通过配置服务器端的sqlnet.ora文件来屏蔽ip地址。# This file is actually generated by netca. But if customers choose to # install "Software Only", this file wont exist and without the native # authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES = (NTS) # 启用ip检查 tcp.validnode_checking=yes #限制的ip地址列表,多个用','分割 tcp.excluded_nodes=(192.168.2.117)
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES = (NTS)
# 启用ip检查
tcp.validnode_checking=yes
#限制的ip地址列表,多个用','分割
tcp.excluded_nodes=(192.168.2.117)