Thank you, I was not aware of this.
The range of the errors was to fine-grained for us to use. (our monitoring
system can not sort in more than 10-40 patterns without beeing wery slow)
regards Hanne
--
Hanne Midttun
http://www.tihlde.org/~hannem
English is not my native tounge
On Thu, 6 Feb 2003, Anurag Varma wrote:
> 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 - 03:09:54 CST
