MMNL进程与ORA-07445 ktsmg_get_threshold

« cursor_space_for_time参数在11.1.0.7中 | Blog首页 | 《深入浅出Oracle》更名《深入解析Oracle》 »

MMNL进程与ORA-07445 ktsmg_get_threshold

作者：eygle |【转载时请以超链接形式标明文章出处和作者信息及本声明】
链接：http://www.eygle.com/archives/2008/10/mmnl_07445_ktsmg_get_threshold.html

站内相关文章|Related Articles

Oracle10g新进程 MMON 和 MMNL

使用errorstack跟踪ORA-01438错误

ORA-01157 - Mount状态下的文件存在性校验

使用DATAPUMP导致ORA-00600 17020错误

Oracle如何维护SMON_SCN_TIME表？

今天一个测试数据库出现了一点小问题。

从告警日志信息来看，给出如下错误提示：

Sun Oct 15 11:07:40 2006
Errors in file /opt/oracle/admin/alexhell/bdump/eygle_mmnl_2031.trc:
ORA-07445: exception encountered: core dump [ktsmg_get_threshold()+819] [SIGFPE] [Integer divide by zero] [0x8CD532B] [] []
Sun Oct 15 11:12:59 2006
Restarting dead background process MMNL
MMNL started with pid=13, OS id=2043
MMNL absent for 3259 secs; Foregrounds taking over
MMNL absent for 3259 secs; Foregrounds taking over
MMNL absent for 3259 secs; Foregrounds taking over
Sun Oct 15 11:13:02 2006
Errors in file /opt/oracle/admin/alexhell/bdump/eygle_mmnl_2043.trc:
ORA-07445: exception encountered: core dump [ktsmg_get_threshold()+819] [SIGFPE] [Integer divide by zero] [0x8CD532B] [] []
Sun Oct 15 11:18:18 2006
Restarting dead background process MMNL
MMNL started with pid=13, OS id=2055
MMNL absent for 3580 secs; Foregrounds taking over
MMNL absent for 3580 secs; Foregrounds taking over
MMNL absent for 3580 secs; Foregrounds taking over

错误提示每5分钟出现一次，也就是说MMNL进程每5分钟尝试一次重新启动，然后失败。

进一步检查发现UNDO表空间处于脱机状态，将该表空间Online之后，问题消除。

SQL> select file_id, file_name, tablespace_name, online_status from dba_data_files;

FILE_ID FILE_NAME TABLESPACE_NAME ONLINE_
------- -------------------------------------------------- ------------------------------ -------
1 /opt/oracle/oradata/eygle/system01.dbf SYSTEM SYSTEM
2 /opt/oracle/oradata/eygle/undotbs01.dbf UNDOTBS1 OFFLINE
3 /opt/oracle/oradata/eygle/sysaux01.dbf SYSAUX ONLINE
4 /opt/oracle/oradata/eygle/users01.dbf USERS ONLINE
5 /opt/oracle/oradata/eygle/system02.dbf SYSTEM SYSTEM

SQL> alter database datafile 2 online;

Database altered.

SQL> select file_id, file_name, tablespace_name, online_status from dba_data_files;

FILE_ID FILE_NAME TABLESPACE_NAME ONLINE_
------- -------------------------------------------------- ------------------------------ -------
1 /opt/oracle/oradata/eygle/system01.dbf SYSTEM SYSTEM
2 /opt/oracle/oradata/eygle/undotbs01.dbf UNDOTBS1 ONLINE
3 /opt/oracle/oradata/eygle/sysaux01.dbf SYSAUX ONLINE
4 /opt/oracle/oradata/eygle/users01.dbf USERS ONLINE
5 /opt/oracle/oradata/eygle/system02.dbf SYSTEM SYSTEM

历史上的今天...
>> 2006-10-22文章:

就这样我们的年华开始老去

>> 2005-10-22文章:

奇妙之旅－纵横双龙山之一

By eygle on 2008-10-22 11:15 | Comments (1) | Posted to Case | Edit |

相关文章	随机文章
Oracle10g新进程 MMON 和 MMNL 使用errorstack跟踪ORA-01438错误 ORA-01157 - Mount状态下的文件存在性校验使用DATAPUMP导致ORA-00600 17020错误 Oracle如何维护SMON_SCN_TIME表？	SUN公司以及Mysql开源数据库的未来 Tools:OSW工具-Oracle的OS watcher Oracle9i基于视图(view)的约束声名参加EMC Forum 2005-加速信息生命周期管理大会成功升级Dopoda S1的ROM

搜索本站:

留言 (1)

这两个东东又是咱整在一起的

Posted by: tsingleed at October 22, 2008 5:34 PM

www.eygle.com

MMNL进程与ORA-07445 ktsmg_get_threshold

留言 (1)

发表留言: