The following are errors that can be trapped in the Oracle alert log file,
that I consider CRITICAL.
I was asked to provide such a list for NAGIOS monitoring tool.
Adapted from Metallica
Monitoring 10g Database Alert Log Errors in Enterprise Manager [ID 976982.1]
Alert Log Error Type | ORA- |
Archiver Hung | ORA-00257 ORA-16038 |
Data Block Corruption | ORA-01114 ORA-01157 ORA-01578 ORA-27048 |
Media Failure | ORA-01243 |
Invalid State | ORA-01502 ORA-20000 |
Extension Errors | ORA-01652 ORA-01653 ORA-01654 |
Generic Errors | ORA-00600 ORA-07445 ORA-04000..04999 |
ORA-0165x
unable to extend temp segment
unable to extend table
unable to extend index
Generic
internal error code ORA-00600
exception encountered ORA-07445
other errors ORA-04000..04999
