Messages ORA-0 and SMG-4120 / SMG-4121 in the Alert Log File
来源:互联网 发布:淘宝平台提成几个点 编辑:程序博客网 时间:2024/05/22 13:46
将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;
- Messages ORA-0 and SMG-4120 / SMG-4121 in the Alert Log File
- smg
- Active Session History (ASH) Performed An Emergency Flush Messages In The Alert Log
- "Abort command Issued" messages appear in /var/log/messages file
- ORA-00205: error in identifying control file, check alert log for more info
- ORA-00205: error in identifying control file, check alert log for more info
- ORA-00205: error in identifying control file, check alert log for more info
- 解决案例:ORA-00205: error in identifying control file, check alert log for more info
- 126.Identify the two situations in which you use the alert log file in your database to check the de
- SHX和SMG文件资料和修改
- CG35.smg主要修改流程和介绍
- SMG物流客户端和小媒资开发心得
- 启动oracle数据库报错ORA-00205: error in identifying control file, check alert log for more info
- ORACLE11g 实例启动报错 ORA-00205: error in identifying control file, check alert log for more info
- 127.Identify the two situations in which the alert log file is updated with details. (Choose two.)
- SMON: ABOUT TO RECOVER UNDO SEGMENT %s messages in alert log
- Finding alert.log file in 11g [ID 438148.1]
- file.alert - log alert to a file
- Adding Content to a Document
- 数据库设计几个小技巧
- 什么是僵尸进程?
- USACO--range
- linux网络编程UDP过程遇到的问题记录
- Messages ORA-0 and SMG-4120 / SMG-4121 in the Alert Log File
- 电子商务网站测试
- elastix iptables 安全设置
- kill oracle session
- VC2010加快速度
- Oracle的KILL锁表及清楚session方法
- 土生土长的博士也可做出一流成果:唐世明与science
- Aptana_Studio_Setup_2.0.5
- 机器视觉著名会议和期刊