eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

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

MMNL进程与ORA-07445 ktsmg_get_threshold

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

从告警日志信息来看,给出如下错误提示:
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


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

无觅

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

1 Comment

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


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com