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.<br>I also spotted a bb-moracle on the xymonton page. I haven't looked at it, but it might be worth investigating.<br>
<br>Regards<br> Vernon<br><br><br><div class="gmail_quote">On Tue, May 10, 2011 at 9:27 AM, FORD Alan <span dir="ltr"><<a href="mailto:Alan.FORD@stanwell.com">Alan.FORD@stanwell.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-AU">
<div>
<p class="MsoNormal"><span style="font-size: 11pt; color: blue;">Hi,</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: blue;">I have written a couple of scripts which check various things.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: blue;">They are designed to run from a single server with oracle client installed (in our case the Xymon server).</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: blue;">I have a oracle xymon user on each database with minimal permissions so that it can get the data it needs.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: blue;"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: blue;">If you like what you see I can post the scripts and configs. :-)</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: blue;"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: blue;">This is what the pages show. In this case it's a database under Data Guard
<b>soapro</b> is the service on both databases.</span></p>
<p class="MsoNormal"><b><span style="font-size: 11pt; color: blue;">soapro1</span></b><span style="font-size: 11pt; color: blue;"> is currently the primary (ora_dbrole = green).</span></p>
<p class="MsoNormal"><b><span style="font-size: 11pt; color: blue;">soapro2</span></b><span style="font-size: 11pt; color: blue;"> is currently the failover (ora_dbrole = clear).</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: blue;">It will go yellow for 5 minutes on a change of roles.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: blue;"> </span></p>
<div align="center">
<table border="0" cellpadding="0">
<tbody>
<tr>
<td rowspan="2" style="padding: 1.5pt;">
<h3 style="text-align: center;" align="center"><u><span style="color: windowtext;">SOA Production</span></u><span style="color: windowtext;"></span></h3>
</td>
<td style="width: 33.75pt; padding: 1.5pt;" valign="bottom" width="45">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/hobbitcolumn.sh?info" target="_blank"><b><span style="font-size: 10pt; color: rgb(135, 169, 229);">info</span></b></a>
<span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="width: 33.75pt; padding: 1.5pt;" valign="bottom" width="45">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/hobbitcolumn.sh?ora_backups" target="_blank"><b><span style="font-size: 10pt; color: rgb(135, 169, 229);">ora_backups</span></b></a>
<span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="width: 33.75pt; padding: 1.5pt;" valign="bottom" width="45">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/hobbitcolumn.sh?ora_checks" target="_blank"><b><span style="font-size: 10pt; color: rgb(135, 169, 229);">ora_checks</span></b></a>
<span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="width: 33.75pt; padding: 1.5pt;" valign="bottom" width="45">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/hobbitcolumn.sh?ora_dbrole" target="_blank"><b><span style="font-size: 10pt; color: rgb(135, 169, 229);">ora_dbrole</span></b></a>
<span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="width: 33.75pt; padding: 1.5pt;" valign="bottom" width="45">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/hobbitcolumn.sh?ora_ping" target="_blank"><b><span style="font-size: 10pt; color: rgb(135, 169, 229);">ora_ping</span></b></a>
<span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="width: 33.75pt; padding: 1.5pt;" valign="bottom" width="45">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/hobbitcolumn.sh?ora_size" target="_blank"><b><span style="font-size: 10pt; color: rgb(135, 169, 229);">ora_size</span></b></a>
<span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="width: 33.75pt; padding: 1.5pt;" valign="bottom" width="45">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/hobbitcolumn.sh?ora_ts" target="_blank"><b><span style="font-size: 10pt; color: rgb(135, 169, 229);">ora_ts</span></b></a>
<span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="width: 33.75pt; padding: 1.5pt;" valign="bottom" width="45">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/hobbitcolumn.sh?trends" target="_blank"><b><span style="font-size: 10pt; color: rgb(135, 169, 229);">trends</span></b></a>
<span style="color: rgb(216, 216, 191);"></span></p>
</td>
</tr>
<tr>
<td colspan="8" style="padding: 1.5pt;">
<div class="MsoNormal" style="text-align: center;" align="center">
<hr width="100%" align="center" size="2">
</div>
</td>
</tr>
<tr>
<td style="padding: 1.5pt;" nowrap>
<p class="MsoNormal"><a name="12fd8fe8a477ac7c_soapro"> </a> <span style="font-size: 13.5pt;">
soapro</span> </p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=info" target="_blank"><span style="color: rgb(0, 255, 170); text-decoration: none;"><img src="cid:image001.gif@01CC0F05.3AF6AEC0" alt="info:green:0.0.0.0" width="16" border="0" height="16"></span></a><span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_backups" target="_blank"><span style="color: rgb(0, 255, 170); text-decoration: none;"><img src="cid:image001.gif@01CC0F05.3AF6AEC0" alt="ora_backups:green:8d14h12m" width="16" border="0" height="16"></span></a><span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_checks" target="_blank"><span style="color: rgb(0, 255, 170); text-decoration: none;"><img src="cid:image001.gif@01CC0F05.3AF6AEC0" alt="ora_checks:green:20d02h41m" width="16" border="0" height="16"></span></a><span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_dbrole" target="_blank"><span style="color: rgb(0, 255, 170); text-decoration: none;"><img src="cid:image001.gif@01CC0F05.3AF6AEC0" alt="ora_dbrole:green:5d18h47m" width="16" border="0" height="16"></span></a><span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_ping" target="_blank"><span style="color: rgb(0, 255, 170); text-decoration: none;"><img src="cid:image001.gif@01CC0F05.3AF6AEC0" alt="ora_ping:green:20d02h40m" width="16" border="0" height="16"></span></a><span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_size" target="_blank"><span style="color: rgb(0, 255, 170); text-decoration: none;"><img src="cid:image001.gif@01CC0F05.3AF6AEC0" alt="ora_size:green:20d02h41m" width="16" border="0" height="16"></span></a><span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=ora_ts" target="_blank"><span style="color: rgb(0, 255, 170); text-decoration: none;"><img src="cid:image001.gif@01CC0F05.3AF6AEC0" alt="ora_ts:green:20d02h38m" width="16" border="0" height="16"></span></a><span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro&SERVICE=trends" target="_blank"><span style="color: rgb(0, 255, 170); text-decoration: none;"><img src="cid:image001.gif@01CC0F05.3AF6AEC0" alt="trends:green:" width="16" border="0" height="16"></span></a><span style="color: rgb(216, 216, 191);"></span></p>
</td>
</tr>
<tr>
<td style="padding: 1.5pt;" nowrap>
<p class="MsoNormal"><a name="12fd8fe8a477ac7c_soapro1"> </a> <span style="font-size: 13.5pt;">
soapro1 (soapro)</span> </p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro1&SERVICE=info" target="_blank"><span style="color: rgb(0, 255, 170); text-decoration: none;"><img src="cid:image001.gif@01CC0F05.3AF6AEC0" alt="info:green:0.0.0.0" width="16" border="0" height="16"></span></a><span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center">-<span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center">-<span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro1&SERVICE=ora_dbrole" target="_blank"><span style="color: rgb(0, 255, 170); text-decoration: none;"><img src="cid:image001.gif@01CC0F05.3AF6AEC0" alt="ora_dbrole:green:5d18h47m" width="16" border="0" height="16"></span></a><span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro1&SERVICE=ora_ping" target="_blank"><span style="color: rgb(0, 255, 170); text-decoration: none;"><img src="cid:image001.gif@01CC0F05.3AF6AEC0" alt="ora_ping:green:20d02h40m" width="16" border="0" height="16"></span></a><span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center">-<span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center">-<span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro1&SERVICE=trends" target="_blank"><span style="color: rgb(0, 255, 170); text-decoration: none;"><img src="cid:image001.gif@01CC0F05.3AF6AEC0" alt="trends:green:" width="16" border="0" height="16"></span></a><span style="color: rgb(216, 216, 191);"></span></p>
</td>
</tr>
<tr>
<td style="padding: 1.5pt;" nowrap>
<p class="MsoNormal"><a name="12fd8fe8a477ac7c_soapro2"> </a> <span style="font-size: 13.5pt;">
soapro2 (soapro)</span> </p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro2&SERVICE=info" target="_blank"><span style="color: rgb(0, 255, 170); text-decoration: none;"><img src="cid:image001.gif@01CC0F05.3AF6AEC0" alt="info:green:0.0.0.0" width="16" border="0" height="16"></span></a><span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center">-<span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center">-<span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro2&SERVICE=ora_dbrole" target="_blank"><span style="color: rgb(0, 255, 170); text-decoration: none;"><img src="cid:image002.gif@01CC0F05.3AF6AEC0" alt="ora_dbrole:clear:5d18h47m" width="16" border="0" height="16"></span></a><span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro2&SERVICE=ora_ping" target="_blank"><span style="color: rgb(0, 255, 170); text-decoration: none;"><img src="cid:image001.gif@01CC0F05.3AF6AEC0" alt="ora_ping:green:20d02h40m" width="16" border="0" height="16"></span></a><span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center">-<span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center">-<span style="color: rgb(216, 216, 191);"></span></p>
</td>
<td style="padding: 1.5pt;">
<p class="MsoNormal" style="text-align: center;" align="center"><a href="http://xymon/xymon-cgi/bb-hostsvc.sh?HOST=soapro2&SERVICE=trends" target="_blank"><span style="color: rgb(0, 255, 170); text-decoration: none;"><img src="cid:image001.gif@01CC0F05.3AF6AEC0" alt="trends:green:" width="16" border="0" height="16"></span></a><span style="color: rgb(216, 216, 191);"></span></p>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal"><span style="font-size: 11pt; color: blue;"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: blue;"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: blue;">attached are samples of what I produce :-)</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: blue;"> </span></p>
<div>
<div style="border-width: 1pt medium medium; border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; padding: 3pt 0cm 0cm;">
<p class="MsoNormal"><b><span style="font-size: 10pt;" lang="EN-US">From:</span></b><span style="font-size: 10pt;" lang="EN-US"> <a href="mailto:xymon-bounces@xymon.com" target="_blank">xymon-bounces@xymon.com</a> [mailto:<a href="mailto:xymon-bounces@xymon.com" target="_blank">xymon-bounces@xymon.com</a>]
<b>On Behalf Of </b>Carl Melgaard<br>
<b>Sent:</b> Monday, 9 May 2011 8:37 PM<div class="im"><br>
<b>To:</b> '<a href="mailto:xymon@xymon.com" target="_blank">xymon@xymon.com</a>'<br>
<b>Subject:</b> [Xymon] Experience: Monitoring Oracle via Xymon?</div></span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><span style="font-size: 10pt;" lang="DA">Hi,</span></p><div><div></div><div class="h5">
<p class="MsoNormal"><span style="font-size: 10pt;" lang="DA"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt;" lang="EN-GB">Does anyone have any experience in monitoring Oracle via Xymon (tablespaces/instaces/listener/export/rman-backups) – any help would be welcomed.</span></p>
<p class="MsoNormal"><span style="font-size: 10pt;" lang="EN-GB"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt;" lang="EN-GB">Regards,</span></p>
<p class="MsoNormal"><span style="font-size: 10pt;" lang="EN-GB"> </span></p>
<p class="MsoNormal"><span style="font-size: 10pt;" lang="EN-GB">Carl Melgaard</span></p>
</div></div></div>
<pre>________________________________________________________________________________
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:<a href="mailto:privacy@stanwell.com." target="_blank">privacy@stanwell.com.</a>..
________________________________________________________________________________
</pre></div>
<br>_______________________________________________<br>
Xymon mailing list<br>
<a href="mailto:Xymon@xymon.com">Xymon@xymon.com</a><br>
<a href="http://lists.xymon.com/mailman/listinfo/xymon" target="_blank">http://lists.xymon.com/mailman/listinfo/xymon</a><br>
<br></blockquote></div><br>