Hello, guys!
Good day to you!
This post refers to the process of limiting the special IP address to visit an Oracle database. Please see below.
The steps to implement it are as per below.
1. Open the file $ORACLE_HOME/network/admin/sqlnet.ora.
2. Add the following content:
tcp.validnode_checking=yes
# the permit visiting IP address
tcp.invited_nodes=(ip1,ip2,......)
#the excluded visiting IP address
tcp.excluded_nodes=(ip1,ip2,......)
3. Save the sqlnet.ora, restart the listener and the modification will be active.
4. If somebody tries to connect to Oracle from the excluded IP, it will receive the error prompt:
ERROR:ORA-12537:TNS:connection shutdown.
Best wishes!
