|
今天一个测试数据库出现了一点小问题 从告警日志信息来看给出如下错误提示 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 |
