控制ip访问数据库的参数

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