ORA-1578 encountered when generating server alert SMG-4120/SMG-4121

也许你的Oracle数据库的Alert日志会和我一样遇到如题所示的报错，具体情况如下所示：

关于该问题，Oracle官方有文档做出了说明：
ORA-25207 Encountered When Generating Server Alert SMG-4120/SMG-4121 in the Alert log (文档 ID 1236903.1)

该问题发生在：
Oracle Database – Enterprise Edition – Version 10.2.0.4 to 11.2.0.2 [Release 10.2 to 11.2] Information in this document applies to any platform.

症状:
即文首Alert日志中的呈现。
官方解释，该告警说明DBA_QUEUES数据字典视图中没有启用enqueue/dequeue。
The status of ALERT_QUE shows that it is not enabled for enqueue/dequeue in the DBA_QUEUES data dictionary view.

Cause：
The ALERT_QUE is used by the Grid Control and DB Control Management Agents to monitor server-generated alerts. This has to be started in order for the alerts to work properly.

解决方法：
启用Alert Queue：

——————————————————————
Done。

感谢支持

赏