RAC Create Oracle Whitelist

Due to business needs, you need to use whitelist to restrict the address of user login database, decide to use database whitelist function!

In general, but the instance database startup whitelist only needs to add the following to the Sqlnet.ora:

TCP. Validnode_checking=yes (IP throttling enabled),

TCP. invited_nodes= (192.168.1.103,IP2,IP3,..,.. Local IP..) --whitelist, must be local IP, otherwise monitoring will not get up,

Tcp. Excluded_nodes= (192.168.1.102)--blacklist

Because this environment is a RAC environment, the operation is slightly different.

1 There is no Sqlnet.ora file under the $oracle_home/network/admin directory under the ORACLE user, you must log into the Sqlnet.ora file under $oracle_home/network/admin with a GUID user, Add modifications.

2 When adding a whitelist, you must add a local IP, because it is a RAC environment, you must add all the true IP, private ip,vip,scan IP of the section into the whitelist.

3 can not be used as a standalone machine to use lsnrctl reload, need to use Srvctl stop listener-n node 1,srvctl start listener-n node 1, one node may be modified, and then modify the other node to prevent the impact of the business.