How to modify sqlnet.ora file to restrict database access?
I am currently trying to restrict access to my database through listing the IP addresses with permission. I read that I should modify my sqlnet.ora file. The problem is I do not have this file.
To configure Oracle for a specific set of IP addresses, you can add the TCP.EXCLUDED_NODES and/or TCP.INCLUDED_NODES parameters to your sqlnet.ora config file. For example, to exclude all IP address 1.2.3.4, add the following entry:
TCP.EXCLUDED_NODES=(1.2.3.4)
To include specific IP addresses, use the TCP.INCLUDED_NODES parameter. The list of included nodes takes precendence over the list of excluded nodes. For more information, please refer to the Oracle documentation.
After you have configured your excluded/included nodes, you also need to add the following:
TCP.VALIDNODE_CHECKING=yes
If this stops the listener from working, then the most likely cause is that the above values were not entered correctly.