Messages ORA-0 and SMG-4120 / SMG-4121 in the Alert Log File

将oracle 10g升级的稳定版本后，alert.log日志出现了几行错误

ORA-0 encountered when generating server alert SMG-4120
ORA-0 encountered when generating server alert SMG-4121

 

是oracle的bug，http://metalink.oracle.com/

上可以搜到解决方法，如下：

Messages ORA-0 and SMG-4120 / SMG-4121 in the Alert Log File [ID 756994.1]  

Applies to: 
Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 10.2.0.4

Symptoms
The following messages appears in the alert log file :
ORA-0 encountered when generating server alert SMG-4120
ORA-0 encountered when generating server alert SMG-4121

Solution
Probably the SYS.ALERT_QUE is missing or corrupted,.

Recreate it as per the following note:
- How to recreate the SYS.ALERT_QUE
 The ALERT_QUE is used by the Grid Control and DB Control Management Agents to monitor server-generated alerts 

NOTE: By running the script below, the queue tables will be recreated and the messages in the queue will be lost 

Solution
SQL> connect / as sysdba

SQL>alter system enable restricted session;

To drop server alert schema.

SQL>@$ORACLE_HOME/rdbms/admin/catnoalr.sql

To re-create tables, sequence, type and queue for server alert

SQL>@$ORACLE_HOME/rdbms/admin/dbmsslrt.sql
SQL>@$ORACLE_HOME/rdbms/admin/catalrt.sql

To recompile the invalid objects

SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql

SQL> alter system disable restricted session; 
 

Note: This option may leave DBSNMP.MGMT_BSLN_INTERNAL invalid. To validate the same run catsnmp.sql
OR
SQL> connect / as sysdba

SQL>alter system enable restricted session;

To drop server alert schema.

SQL>@$ORACLE_HOME/rdbms/admin/catnoalr.sql

Rerun catproc.sql

SQL>@$ORACLE_HOME/rdbms/admin/catproc.sql

SQL> alter system disable restricted session;