Hi, I have written a couple of scripts which check various things. They are designed to run from a single server with oracle client installed (in our case the Xymon server). I have a oracle xymon user on each database with minimal permissions so that it can get the data it needs.
If you like what you see I can post the scripts and configs. :-)
This is what the pages show. In this case it's a database under Data Guard soapro is the service on both databases. soapro1 is currently the primary (ora_dbrole = green). soapro2 is currently the failover (ora_dbrole = clear). It will go yellow for 5 minutes on a change of roles.
SOA Production
info<http://xymon/xymon-cgi/hobbitcolumn.sh?info>
ora_backups<http://xymon/xymon-cgi/hobbitcolumn.sh?ora_backups>
ora_checks<http://xymon/xymon-cgi/hobbitcolumn.sh?ora_checks>
ora_dbrole<http://xymon/xymon-cgi/hobbitcolumn.sh?ora_dbrole>
ora_ping<http://xymon/xymon-cgi/hobbitcolumn.sh?ora_ping>
ora_size<http://xymon/xymon-cgi/hobbitcolumn.sh?ora_size>
ora_ts<http://xymon/xymon-cgi/hobbitcolumn.sh?ora_ts>
trends<http://xymon/xymon-cgi/hobbitcolumn.sh?trends>
soapro
[info:green:0.0.0.0]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=info>
[ora_backups:green:8d14h12m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_backups>
[ora_checks:green:20d02h41m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_checks>
[ora_dbrole:green:5d18h47m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_dbrole>
[ora_ping:green:20d02h40m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_ping>
[ora_size:green:20d02h41m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_size>
[ora_ts:green:20d02h38m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_ts>
[trends:green:]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=trends>
soapro1 (soapro)
[info:green:0.0.0.0]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro1&SERVICE=info>
[ora_dbrole:green:5d18h47m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro1&SERVICE=ora_dbrole>
[ora_ping:green:20d02h40m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro1&SERVICE=ora_ping>
[trends:green:]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro1&SERVICE=trends>
soapro2 (soapro)
[info:green:0.0.0.0]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro2&SERVICE=info>
[ora_dbrole:clear:5d18h47m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro2&SERVICE=ora_dbrole>
[ora_ping:green:20d02h40m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro2&SERVICE=ora_ping>
[trends:green:]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro2&SERVICE=trends>
attached are samples of what I produce :-)
From: xymon-bounces at xymon.com [mailto:xymon-bounces at xymon.com] On Behalf Of Carl Melgaard Sent: Monday, 9 May 2011 8:37 PM To: 'xymon at xymon.com' Subject: [Xymon] Experience: Monitoring Oracle via Xymon?
Hi,
Does anyone have any experience in monitoring Oracle via Xymon (tablespaces/instaces/listener/export/rman-backups) - any help would be welcomed.
Regards,
Carl Melgaard
This email (including all attachments) may contain personal information and is intended solely for the named addressee. It is confidential and may be subject to legal or other professional privilege and any confidentiality or privilege is not waived or lost because this email has been sent to you by mistake. This email is also subject to copyright. No part of it should be reproduced, adapted or communicated without the written consent of the copyright owner. Any personal Information in this email must be handled in accordance with the Privacy Act 1988 (Cth). If you have received it in error, please let Stanwell Corporation Limited know by reply email, delete it from your system and destroy any copies. Stanwell is not responsible for any changes made to a document other than those made by Stanwell. Stanwell accepts no liability for any damage caused by this email or its attachments due to viruses, interference, interception, corruption or unauthorised access. If you have any doubts about the authenticity of an email purportedly sent by us, please contact us immediately. If this is a commercial electronic message within the meaning of the Spam Act 2003 (Cth), you may indicate that you do not wish to receive any further commercial electronic messages from Stanwell by emailing mailto:privacy at stanwell.com...