Re: any script to parse alert log ?!

And load 'em to CLOBs as well and use InterMedia Text to index them ;)

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, July 11, 2003 12:59 AM

> > Here is a good one:
> > create or replace directory bdump as
> > '/oracle/admin/o9i/bdump' / grant read on directory bdump to
> > public / create table alert_log_ext ( line varchar2(2000) )
> > organization external ( type oracle_loader default directory
> > bdump access parameters
> > (
> > records delimited by newline
> > nobadfile nologfile nodiscardfile
> > fields (line char(132)
> > )
> > )
> > location('alert_o9i.log') )
> > reject limit unlimited
> > /
> >
> > You can now write a PL/SQL or Java procedure to parse
> > alert_log_ext table if your heart so desires. There is only
> > one problem: this doesn't work if you don't have 9iR2.

> Or if the database isn't up..... 
> 
> I do like the idea though, could centralize all alert.logs and indeed
> listener.logs etc in one db. 
> 
> Niall 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Niall Litchfield
>   INET: niall.litchfield_at_dial.pipex.com
> 
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California        -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).