| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Alert Log & SQL
What about using the UTL_FILE package to read the alert log?
Steve
> -----Original Message-----
> From: Mark Leith [mailto:mark_at_cool-tools.co.uk]
> Sent: Tuesday, September 19, 2000 1:16 PM
> To: Multiple recipients of list ORACLE-L
> 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 - 13:09:12 CDT
 |
 |