今天一個測試數據庫出現了一點小問題
從告警日志信息來看給出如下錯誤提示
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
