Re: Alert Log & SQL

The alert log is a flat file residing on the server. Since it is not a database table I don't think you could use use sql. If you have OEM monitoring all of these database you can have it report whenever there is a new entry in the alert log.

Regards,
Ruth
----- Original Message -----
From: "Mark Leith" <mark_at_cool-tools.co.uk> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, September 19, 2000 1:16 PM Subject: RE: Alert Log & SQL

> Thanks for the reply Ruth, but I need (would like anyway:) to do this
> through SQL if at all possible. The request is by a user of the tool in
> "Virtual" mode, who wants to know about any new entries to the alert log.
> They check this every morning on 39 databases across 20 servers manually,
> but once they have done that any new alerts after say 9:30am - after they
> have finished - will be missed until the next day..
>
> So if an error does occur on one of these systems, is there anyway via SQL
> for me to know?
>
>
> -----Original Message-----
> Gramolini
> Sent: 19 September 2000 16:36
> To: Multiple recipients of list ORACLE-L
>
>
> You can download a free package called AlertView from www.zephyrus.com
which
> will allow you to view messages that you select for viewing. It works
very
> well. It runs on a PC.
>
> HTH,
> Ruth
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, September 19, 2000 11:10 AM
>
>
> > Gurus,
> >
> > Is it possible to establish whether there has been any new entries, or
in
> > fact just read the Oracle alert log with SQL?
> >
> > The reason - We have a tool that can monitor the alert log when it has
an
> > agent which is local to the instance, and will in fact alert on any new
> > entries. If the tool does not have a local agent though, this function
> > becomes invalid.
> >
> > We can however set up a User Defined Collection to monitor this if we
can
> > return some value with SQL. Does Oracle store anywhere that it has
written
> > to the file? If so what does it store, and how can I query the database?
> >
> > All help appreciated..
> >
> > Mark Leith
> > =================
> > Cool Tools UK Ltd
> > +44 1905 330 281
> > mark_at_cool-tools.co.uk
> >
> >
>
> --
> Author: Ruth Gramolini
> INET: rgramolini_at_tax.state.vt.us
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Author: Mark Leith
> INET: mark_at_cool-tools.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Tue Sep 19 2000 - 12:52:13 CDT