Re: Oracle 8i Error Messages

You must be talking about the file $ORACLE_HOME/rdbms/mesg/oraus.msg It has some comments which indicate what range of errors are for which purpose.

Anurag

"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message news:2687bb95.0302050937.981574e_at_posting.google.com...
> 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 Thu Feb 06 2003 - 00:33:15 CST