For the sake of data security, there are some restrictions on the IP address of the Oracle database. Only a fixed IP address can access it.
modify $JAVA_HOME/NETWORK/ADMIN/sqlnet.ora File, if not, please create a new one
Add the following content (# means comment):
#Enable IP restriction function tcp.validnode_checking=yes #The list of IP addresses allowed to access the database. Multiple IP addresses are separated by commas tcp.invited_nodes=(192.168.1.110,192.168.2.*) #Access to the IP address list of the database is prohibited. Multiple IP addresses are separated by commas tcp.excluded_nodes=(192.168.1.111,192.168.3.*)
Then restart listening.
Note:
1. The first line must be written. It can be written on any platform, but it is only applicable to TCP/IP.
2. Either the second line or the third line is sufficient. If tcp.invited_nodes And tcp.excluded_nodes Both exist to tcp.invited_nodes Mainly.
3. Do not disable the IP address of the local server. Otherwise, listening cannot be started or stopped through lsnrctl, because the process listener will access the listener through the local IP address.
Reference article:
http://blog.itpub.net/29734436/viewspace-2135785/
https://www.linuxidc.com/Linux/2014-10/108650.htm