Re: oracle scan log script

Ahh, now we're getting somewhere. Your problem isn't "how to write a script to scan the alert log." It is "how to get notified (in something resembling a timely manner when something goes wrong."

To write the script you'd need to be able to define "something 'odd'" and identify the character string that would identify "something 'odd'". And you'd want to be able to deal with avoiding reporting the same oddity occurance every time you ran the script.

Have you looked into OEM? It has a very good reporting capability for all sorts of things -- some of which show up in the alert log and some of which don't. That quite nicely addresses your real problem. It can e-mail and/or page (or send email to an address which is really a text pager). I started down the same road you are looking at, but abandond that in favor of OEM reporting and have been using that for some time now. Due to localized reasons, I'm not able to use the paging, but do receive e-mails when 'something odd' happens in my databases.

On 4 May 2004 17:40:46 -0700, tpreto7_at_sapo.pt (Teresa) wrote:

>Hello and Thank you
>
>I'm only looking for a general unix script that can scan the oracle
>alert.log file for any kind of oracle error's. For the output it
>would be an email whenever there is something 'odd' writte to the log.
>
>
>Ed Stevens <nospam_at_noway.nohow> wrote in message news:<i12f901298hp6tsb7h8h51sq5fel6ofrff_at_4ax.com>...
>> 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
>>
>> While my first reply does give you a one-line script that scans the
>> alert log, I should have asked for more info . .
>>
>> First off ... what operating system?
>>
>> Second, what is it you're scanning for? How do you anticipate using
>> this script? How do you plan on using the output?
>>
>> Most important -- what is the real problem you're trying to solve?
Received on Wed May 05 2004 - 07:18:31 CDT