Re: Oracle 8i Error Messages

Hanne Iren Midttun <hannem_at_tihlde.org> wrote in message news:<Pine.LNX.4.21.0302050951020.18931-100000_at_colargol.tihlde.org>...
> Hi,
> I am monitoring the alert log for our databases. When the string
> "ORA" appears, an alarm i send by mail. The mail show the line the
> "ORA" string appers in eg:
> ORA-279 signalled during: ALTER DATABASE RECOVER automatic standby
> database...
>
> I was hoping to divide the error messages into 3 category
> - green (OK)
> - yellow (warning)
> - red (allert)
>
> The problem is that there seems to me that there are no sutch category in
> the error messages? eg ORA-00* - alert, ORA-01* - warning, ORA-03 - OK,
> and so on (the numbers are right out of my head :)
>
> I would be happy if somebody could cleryfy me on this.
>
> How are you monitoring your databases
>
> regards Hanne

I do not remember the breakdown but it seems that Oracle once listed the errors in one of their manuals as being for specific areas. The errors are grouped first by progam imp, exp, ora etc... and for the ora errors in error code ranges, such as 00900 - 00999 are basically sql syntax errors. Some of these ranges seem to have values that fall into all of your categories, but generally only serious errors are written to the alert log so you do not need to worry about the entire set of errors. You most practical approach might be to treat everything as serious until you see the message the first time and to classify them as you encounter them.

IMHO -- Mark D Powell -- Received on Wed Feb 05 2003 - 11:37:55 CST