Mark
How about a cron job that monitors for new entries in the alert log and then
inserts the text into the database? I do something like that currently, a job
crons every five minutes and looks for the existance of the alert log, then it
moves that file into a history directory. Something like this could be altered
to load that portion of the alert log into the database. Of course, this could
make for a big table of text, you would want to clean it out frequently. But,
if all this is for just an alert mechinism, why not just parse the portions of
the alert file with a shell script and send a page. It's realitively easy, I
already do that.
Tom Tyson
- Mark Leith <mark_at_cool-tools.co.uk> wrote:
> 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
> also send the HELP command for other information (like subscribing).
Do You Yahoo!?
Received on Tue Sep 19 2000 - 13:58:09 CDT
