熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

MMNL進程與ORA-07445ktsmg

2013-11-13 15:54:02  來源: Oracle 

  今天一個測試數據庫出現了一點小問題

  從告警日志信息來看給出如下錯誤提示

  

  Sun Oct ::
Errors in file /opt/oracle/admin/alexhell/bdump/eygle_mmnl_trc:
ORA: exception encountered: core dump [ktsmg_get_threshold()+] [SIGFPE] [Integer divide by zero] [xCDB] [] []
Sun Oct ::
Restarting dead background process MMNL
MMNL started with pid= OS id=
MMNL absent for secs; Foregrounds taking over
MMNL absent for secs; Foregrounds taking over
MMNL absent for secs; Foregrounds taking over
Sun Oct ::
Errors in file /opt/oracle/admin/alexhell/bdump/eygle_mmnl_trc:
ORA: exception encountered: core dump [ktsmg_get_threshold()+] [SIGFPE] [Integer divide by zero] [xCDB] [] []
Sun Oct ::
Restarting dead background process MMNL
MMNL started with pid= OS id=
MMNL absent for secs; Foregrounds taking over
MMNL absent for secs; Foregrounds taking over
MMNL absent for secs; Foregrounds taking over

  錯誤提示每分鐘出現一次也就是說MMNL進程每分鐘嘗試一次重新啟動然後失敗

    進一步檢查發現UNDO表空間處於脫機狀態將該表空間Online之後問題消除

  

  SQL> select file_id file_name tablespace_name online_status from dba_data_files;

FILE_ID FILE_NAME                                          TABLESPACE_NAME                ONLINE_

      /opt/oracle/oradata/eygle/systemdbf            SYSTEM                        SYSTEM
      /opt/oracle/oradata/eygle/undotbsdbf            UNDOTBS                      OFFLINE
      /opt/oracle/oradata/eygle/sysauxdbf            SYSAUX                        ONLINE
      /opt/oracle/oradata/eygle/usersdbf              USERS                          ONLINE
      /opt/oracle/oradata/eygle/systemdbf            SYSTEM                        SYSTEM

SQL> alter database datafile online;

Database altered

SQL> select file_id file_name tablespace_name online_status from dba_data_files;

FILE_ID FILE_NAME                                          TABLESPACE_NAME                ONLINE_

      /opt/oracle/oradata/eygle/systemdbf            SYSTEM                        SYSTEM
      /opt/oracle/oradata/eygle/undotbsdbf            UNDOTBS                      ONLINE
      /opt/oracle/oradata/eygle/sysauxdbf            SYSAUX                        ONLINE
      /opt/oracle/oradata/eygle/usersdbf              USERS                          ONLINE
      /opt/oracle/oradata/eygle/systemdbf            SYSTEM                        SYSTEM



From:http://tw.wingwit.com/Article/program/Oracle/201311/17485.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.