oracle11g Setting IP Access restrictions

For data security reasons, there are some restrictions on the IP of the Oracle database that can only be accessed by a fixed IP.

Modify the $java_home/network/admin/sqlnet.ora file

Add the following (red indicates comments):

#开启ip限制功能
Tcp.validnode_checking=yes
#允许访问数据库的IP地址列表, multiple IP addresses are separated using commas
Tcp.invited_nodes= (192.168.1.110)
#禁止访问数据库的IP地址列表, multiple IP addresses are separated using commas
Tcp.excluded_nodes= (192.168.1.111)

Then restart the monitor.

Note:

1, the first line must write, any platform can be, but only applicable to TCP/IP.

2, the second row and the third line can write a line, if Tcp.invited_nodes and Tcp.excluded_nodes are present, to Tcp.invited_nodes-based.

3, do not prohibit the server native IP address, otherwise through LSNRCTL will not be able to start or stop listening, because the process listener through the local IP access listener.

oracle11g Setting IP Access restrictions