标题: 监听状态显示为blocked [打印本页] 作者: 刘泽宇 时间: 2020-11-21 14:20 标题: 监听状态显示为blocked 在进行DG物理备库搭建时，发现备库的监听状态为blocked
部分信息为：
service "lisdb" has 2 instance(s).
instance "lisdb",status UNKNOWN,has 1 handler(s) for this service...
instance "lisdb",status BLOCKED,has 1 handler(s) for this service...
这也就引起无法通过主库连接备库的情况出现
仔细检查监听配置，没有发现错误，
再检查tnsnames.ora文件，发现是配置文件中有关备库的信息出错，指定的服务名与实际不符
将配置重新修改后，重启监听，这次正常了
service "lisdb" has 2 instance(s).
instance "lisdb",status UNKNOWN,has 1 handler(s) for this service...
instance "lisdb",status READY,has 1 handler(s) for this service...
service "lisdg" has 1 instance(s).
instance "lisdb",status READY,has 1 handler(s) for this service...
配置时一定要仔细，配置完成后也要多检查检查