2022-01-05
oracle修改sqlnet.ora限制登入后,怎么再把限制登入的那个ip再让它能访问?
oracle修改sqlnet.ora限制登入后,怎么再把限制登入的那个ip再让它能访问?
我来答
添加附件
收藏
分享
问题补充
3条回答
默认
最新
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏
oracle修改sqlnet.ora限制登入后,怎么再把限制登入的那个ip再让它能访问?
看看sqlnet.ora,怎么修改的?
正常这样设置就行:
#To enable and disable valid node checking for incoming connections. If this parameter is set to yes, then incoming connections are allowed only if they originate from a node that conforms to list specified by TCP.INVITED_NODES or TCP.EXCLUDED_NODES parameters.
tcp.validnode_checking = yes
#To specify which clients are allowed access to the database.
tcp.invited_nodes = (192.168.0.*,192.168.10.*,192.168.20.*,192.168.30.*,192.168.40.*,10.201.39.*,10.201.29.*)
#To specify which clients are denied access to the database
tcp.excluded_nodes = (*)
评论
有用 0
墨值悬赏