oracle添加白/黑名单
主要命令:
tcp.excluded_nodes = (list of IP addresses) #注意此处ip第一个数字不能为0,如192.168.0.03数据库不会认为是192.168.0.3
tcp.invited_nodes = (list of IP addresses) #注意括号内的一定不能有跳行
重启listener生效(或者lsnrctl reload)
localhost-> lsnrctl start
LSNRCTL for Linux: Version 10.1.0.5.0 - Production on 06-MAY-2009 16:25:37
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.1.0.5.0 - Production
System parameter
file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to
/u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Error
listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.domain)(PORT=1524)))
TNS-12533: TNS:illegal ADDRESS
parameters
TNS-12560: TNS:protocol adapter error
TNS-00503: Illegal ADDRESS parameters
当tcp.excluded_nodes或者tcp.invited_nodes没有设置的情况下
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 19-FEB-2014 11:30:20
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting /u01/app/grid/asm/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.2.0 - Production
System parameter file is /u01/app/grid/asm/network/admin/listener.ora
Log messages written to /u01/app/grid/diag/tnslsnr/localhost/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
TNS-12560: TNS:protocol adapter error
TNS-00584: Valid node checking configuration error
Listener failed to start. See the error message(s) above...
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。