RE: any script to parse alert log ?!

If you have more databases, there are synonyms, views and db-links. That is classic DBA patchwork. The funniest siutations arise when you have a circle of synonyms and db-links pointing to each other, just like perpetuum mobile. What is impossible in thermodynamics, is possible in oracle. It doesn't meant that it works, but can be done, much to the joy of us DBAs.

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:mgogala_at_oxhp.com

-----Original Message-----
Sent: Thursday, July 10, 2003 5:59 PM
To: Multiple recipients of list ORACLE-L

> 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: Gogala, Mladen
  INET: MGogala_at_oxhp.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).