December 6, 2010

Alert Log Monitoring script via ADRCI

Before I start to write about the blog series in my mind which will be the base to my first presentation again in my mind, I would like to share simple alert log monitoring with adrci.

At first I was completely against Diagnostics Dest idea but after a bit of searching and learning new tips tricks of adrci command like I think I am a big fan of diagnostics dest. Below is the script I wrote to monitor alert log hourly and with a daily summary. Script is self explanatory, the only thing it does is gets ADRCI homes put them in a bash array and grep the ORA-, TNS- errors for the last hour or last day. It is not rocket since and it is based on a simple command which can also be added to your profiles as an alias.

Thanks for your commens Jason I wish I would do for adrci and maybe in the future but my primary concern is plan stability🙂 I would do plan stability through upgrades and I hope I would give a little bit more info than Maria Calgan did at ukoug;)

if you don’t use the -term opton and run this from cron you will get a bunch of hung vi sessesions out there. standard functionality displays the show alert to a vi session (actually default editor) but show alert -term -p for example will just display to the terminal.