sqlnet.ora中 使用这几个参数来对客户端访问进行控制(版本11gR2)
1)TCP.VALIDNODE_CHECKING
Purpose:
To enable and disable valid node checking for incoming connections.
If this parameter is set to yes, then incoming connections are allowed only if they originate from a node that conforms to list specified by TCP.INVITED_NODES or TCP.EXCLUDED_NODES parameters.
Values:
Default no , Values yes | no
2)TCP.INVITED_NODES
Purpose:
To specify which clients are allowed access to the database. This list takes precedence over the TCP.EXCLUDED_NODES parameter if both lists are present.
Syntax:
TCP.INVITED_NODES=(hostname | ip_address, hostname | ip_address, ...)
Usage Notes
This parameter is only valid when the TCP.VALIDNODE_CHECKING parameter is set to yes.
This parameter can use wildcards for IPv4 addresses and CIDR (Classless Inter-Domain Routing) notation for IPv4 and IPv6 addresses.
3)TCP.EXCLUDED_NODES
Purpose
To specify which clients are denied access to the database.
Syntax
TCP.EXCLUDED_NODES=(hostname | ip_address, hostname | ip_address, ...)
Usage Notes
This parameter is only valid when the TCP.VALIDNODE_CHECKING parameter is set to yes.
This parameter can use wildcards for IPv4 addresses and CIDR (Classless Inter-Domain Routing) notation for IPv4 and IPv6 addresses
官网链接:https://docs.oracle.com/cd/E11882_01/network.112/e10835/sqlnet.htm#NETRF201