Monitoring of Alert Logs.

I read an interesting article here about monitoring the alert logs that Oracle writes. They offer some suggestions to use scripts or monitoring tools but no real information or examples.
I checked how we do it at work and remembered that I had written a script some time ago that runs grep over the alert log looking for anything starting with ORA- (any oracle error starts with ORA-).
It then pipes all this to a html file that i can access from a server that is running apache. I simple check this web page every morning to see if there were any errors i need to be concerned about.

I had problems putting the script in the post as it contains html tags. If you’d like to see if, email me at mc@malcolmchalmers.com. Thanks.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s