也许你的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。

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

隐藏
变装