Oracle 10 Gb limits the access of some IP addresses to the database. ORACLE can set both the blacklist and whitelist. The Blacklist must mean that all IP addresses in the whitelist are not allowed to access the database. All IP addresses in the whitelist are allowed to access the database, in principle, you can set only one blacklist and one whitelist. If both are enabled, the whitelist is valid and the blacklist is invalid. The specific setting method is in SQLNET. add the following three valid parameters to the ora file: TCP. VALIDNODE_CHECKING. This parameter must be set and the value must be YES. Otherwise, TCP is disabled. VALIDNODE_CHECKING = YES www.2cto.com. The address list must contain the address of the Local Machine. Otherwise, the listener may fail to start TCP. INVITED_NODES = (10.10.2.100, 10.10.2.101) blacklist Setting Parameter: TCP. the design concept of the EXCLUDED_NODES = (10.10.1.100) blacklist and whitelist is basically that the listening service uses the IP address method to determine whether to respond to all request database connections. If the blacklist is enabled, in addition, if the IP address of a machine changes, the connection may fail. After the configuration is complete, the listener should be restarted to take effect.