[Xymon] Experience: Monitoring Oracle via Xymon?

Tue May 10 10:39:10 CEST 2011

There was also bb-roracle, which I found on deadcat. It worked OK for me,
but that was many years ago. Not sure how it will shape up to the newer
versions of Oracle.
I also spotted a bb-moracle on the xymonton page. I haven't looked at it,
but it might be worth investigating.

Regards
     Vernon

On Tue, May 10, 2011 at 9:27 AM, FORD Alan <Alan.FORD at stanwell.com> wrote:

>  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
>
> [image: info:green:0.0.0.0]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=info>
>
> [image: ora_backups:green:8d14h12m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_backups>
>
> [image: ora_checks:green:20d02h41m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_checks>
>
> [image: ora_dbrole:green:5d18h47m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_dbrole>
>
> [image: ora_ping:green:20d02h40m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_ping>
>
> [image: ora_size:green:20d02h41m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_size>
>
> [image: ora_ts:green:20d02h38m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_ts>
>
> [image: trends:green:]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=trends>
>
>   soapro1 (soapro)
>
> [image: info:green:0.0.0.0]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro1&SERVICE=info>
>
> -
>
> -
>
> [image: ora_dbrole:green:5d18h47m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro1&SERVICE=ora_dbrole>
>
> [image: ora_ping:green:20d02h40m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro1&SERVICE=ora_ping>
>
> -
>
> -
>
> [image: trends:green:]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro1&SERVICE=trends>
>
>   soapro2 (soapro)
>
> [image: info:green:0.0.0.0]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro2&SERVICE=info>
>
> -
>
> -
>
> [image: ora_dbrole:clear:5d18h47m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro2&SERVICE=ora_dbrole>
>
> [image: ora_ping:green:20d02h40m]<http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro2&SERVICE=ora_ping>
>
> -
>
> -
>
> [image: 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...
> ________________________________________________________________________________
>
>
> _______________________________________________
> Xymon mailing list
> Xymon at xymon.com
> http://lists.xymon.com/mailman/listinfo/xymon
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20110510/2fd082c6/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/x-citrix-gif
Size: 118 bytes
Desc: not available
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20110510/2fd082c6/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.gif
Type: image/x-citrix-gif
Size: 884 bytes
Desc: not available
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20110510/2fd082c6/attachment-0001.bin>