This product is actually monitor all mine alertlog of production instances.
This is able to send a mail with the trapped error in attach.
It’s really useful to keep monitored every kind of log, now i just use with alert.log and now is monitoring something like 43 production instances.
To install this script add in /etc/fstab a line like this one:
//<SERVERNAME>.<DOMAIN>/c$/oracle/product/10.2.0/admin /mnt/oracle/<SERVERNAME> cifs domain=<DOMAIN>,user=<USERNAME>,pass=<PASSWORD>,ro
With this i suppose that oracle run on Windows server and the monitoring script on a linux machine. Otherwise if you run Oracle inside a Linux server you need mount locally the location that contain the alertlog file.
and run this script as:
/opt/oralog_analyzer/analyzer.sh <INSTANCENAME> <INSTANCENAME> /mnt/oracle/<SERVERNAME>/<INSTANCENAME>/bdump/alert_<INSTANCENAME>.log
Is fundamental that this script run with a fully qualified path because he get his own configuration parameter on cfg/global file that is included.
As you can see in this file you are going to find:
#GLOBAL CONFIGURATION FILE
#To send email SENDMAIL=[yes|no]
#Specify mail address
#To send to zabbix_server SENDZABBIX=[yes|no]
#full path for mutt
#Configure Zabbix Sender
#NOTIFY[HIGH|WARNING|INFO|AVERAGE]= [yes|no] to notify every level
#if you want receive anyway email for each level
in each file contained inside cfg you will find the error-list that is trapped by this script.
to run this script after configured email address
add a line like this one in crontab
# check log oracle
*/10 * * * * /opt/oralog_analyzer/analyze_log.sh
so every 10 minutes the script is executed
The project is downloadable here: