Limit a specific IP access database

xiaoxiao2021-03-05  19

Previously, there were documents that increase or modify the protocol.ora file. It truly role in 9i is SQLNET.ORA file, and we modify SQLNET.ORA is actually the best and fastest way.

Add below SQLNET.ORA ----------------------------- #### from Protocol.ora's properties ### #

TCP.validNode_Checking = YES

# 允 i i tv = (ip1, ip2 ...)

# I t t t = (ip1, ip2 ...)

After restarting the listener

It is necessary to pay attention to: 1. TCP.INVITED_NODES exists with tcp.excluded_nodes, which is 2, which must be licensed or do not disable the server's IP address, otherwise it will not be able to start or stop by LSNRCTL, because Process listener will pass the IP access listener of this unit, and the IP is disabled, but it does not affect the service start or shutdown. 3, after modification, you must restart listening to take effect, do not need to restart the database 4, any platform can, but only apply to TCP / IP protocols

转载请注明原文地址:https://www.9cbs.com/read-38867.html

New Post(0)