Re: oracle scan log script

On Mon, 03 May 2004 09:22:53 -0500, Ed Stevens <nospam_at_noway.nohow> wrote:

>On 30 Apr 2004 19:50:13 -0700, tpreto7_at_sapo.pt (Teresa) wrote:
>
>>Hello
>>
>>Does any one have a general script that scans the oracle logs? I'm
>>looking for a script that can scan the alert.log etc
>>Thanks!
>>Teresa
>
>
>OS?
>
>On unix --
>
>cat alert.log | grep 'ORA-'
>
>
>On Win --
>
>find /I "ORA-" alert.log
>
>
>That's the guts of it. I leave redirect to an output log, changing
>the value being scanned for, etc. as an exercise for the student.

I have to disagree. That won't capture many, many warnings and messages, including 'Cannot allocate log, archival required'

--
Sybrand Bakker, Senior Oracle DBA