To configure Oracle for a specific set of IP addresses, you can add the TCP.EXCLUDED_NODES and/or TCP.INCLUDED_NODES...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
parameters to your sqlnet.ora config file. For example, to exclude all IP address 18.104.22.168, 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.