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 firstname.lastname@example.org. Thanks.