将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;