19.9 rac 环境,告警日志alert.log中发现每隔40分钟就有一个错误信息:
Emon ping encountered error 942
2021-04-13T10:23:52.371657+08:00
Emon ping encountered error 942
2021-04-13T11:03:50.459599+08:00
Emon ping encountered error 942
2021-04-13T11:43:48.548627+08:00
Emon ping encountered error 942
2021-04-13T12:23:46.638994+08:00
Emon ping encountered error 942
2021-04-13T13:03:43.726509+08:00
emon是一个后台进程。
mos关于此类问题建议以下方法收集信息:
相关语句应该是
-
select r.location_name, max(r.reg_id), r.con_id
-
from CDB_SUBSCR_DUR_REGISTRATIONS r left
-
outer join gv$subscr_registration_stats v
-
on r.reg_id = v.reg_id and r.con_id = v.con_id
-
where location_name like 'net8://(%' group by r.location_name, r.con_id having
-
min(current_timestamp-nvl(last_ntfn_sent_time, reg_time)) > :b1;
找不到 CDB_SUBSCR_DUR_REGISTRATIONS!
我找了另外一台测试环境
32067171;OJVM RELEASE UPDATE: 19.10.0.0.210119 (32067171)
32218454;Database Release Update : 19.10.0.0.210119 (32218454)
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
却发现存在此对象:
感觉是个bug。
阅读(1581) | 评论(0) | 转发(0) |