Shulou(Shulou.com)06/01 Report--

Oracle controls the connection of ip

Simply set allowed IP and prohibited IP

In 9i and beyond, modifying sqlnet.ora is actually the best and fastest way.

In the linux version of oracle, there is no sqlnet.ora file by default.

$cd $ORACLE_HOME/network/admin$ vi sqlnet.ora# adds the following part: tcp.validnode_checking=yes # allowed IP tcp.invited_nodes= (192.168.100.252192.168.100.253) # forbidden IP tcp.excluded_nodes= (192.168.100.222192.168.100.232)

Restart monitoring

$lsnrctl stop$ lsnrctl start

At this point, only clients with ip address 192.168.100.252 and ip address 192.168.100.253 can connect to the database, while clients with ip address 192.168.100.222 and ip address 192.168.100.232 cannot connect to the database. When other IP clients use PL/SQL to connect to the database, the following error is displayed:

Issues to pay attention to:

1. You need to set the parameter to YES in order to activate it.

2. It is recommended to set the IP that allows access, because the IP address may be modified at will, so it cannot serve its own purpose.

3. You need to restart the listener to take effect.

4. This method is only suitable for TCP protocol.

5. This configuration is suitable for versions above 9i. The file protocol.ora was used in versions prior to 9i.

6. Connecting to the database directly on the server is not affected.

7. This restriction is only for IP detection and is not supported for user name detection.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.