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 126.96.36.199, add the following entry:
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:
If this stops the listener from working, then the most likely cause is that the above values were not entered correctly.
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.