James,<br><br>I use bb-roracle (current v 2.20) with Hobbit. It runs on six of my HP-UX-based servers. Two of these servers monitor databases on remote servers. In most cases, these remote servers are Windows boxes but one or two monitored databases reside on Linux hosts that I was too lazy to get
bb-roracle.sh to run directly on.<br><br>I originally implemented bb-roracle with all database stats reporting back to the host that ran bb-roracle. So, all databases monitored by XXX appeared on the XXX.oradb page in Hobbit. If you had 10 monitored database instances, that
XXX.oradb page would be really large.<br><br>I recently moved to an individual pages per database. This makes alerting via SMS/cell phone text message much cleaner. Here's what the pertinent sections of bb-hosts and
bb-roracle.ids look like:<br><br><span style="font-family: courier new,monospace;">#bb-hosts<br>page Unix Unix<br>group-compress<br><a href="http://192.168.222.111" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
192.168.222.111</a> fintest # oratns<br>page Windows Windows
<br>group-compress<br></span><span style="font-family: courier new,monospace;"><a href="http://192.168.222.123" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">192.168.222.123</a> timecard # oratns
<br>
<a href="http://192.168.222.132" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">192.168.222.132</a> loaddata # oratns<br>
</span><span style="font-family: courier new,monospace;">page Database Databases<br>group-compress<br style="font-family: courier new,monospace;"></span><span style="font-family: courier new,monospace;"><a href="http://192.168.222.111" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
192.168.222.111</a> fintest.financetest # noconn</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"><a href="http://192.168.222.123" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
192.168.222.123</a> timecard.timeentry
# noconn<br><a href="http://192.168.222.132" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">192.168.222.132</a> loaddata.loaddata # noconn<br></span><br><br><span style="font-family: courier new,monospace;">
#bb-roracle.ids</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">#type SID userid password tests log-as-host listener-name</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">
LOCAL financetest bbuser bbpasswd aBE fintest.financetest lsnr_fintest<br>REMOTE timeentry bbuser bbpasswd aBEfijk timecard.timeentry<br>REMOTE loaddata </span><span style="font-family: courier new,monospace;">
bbuser bbpasswd </span><span style="font-family: courier new,monospace;">aBEfijk loaddata.loaddata<br style="font-family: courier new,monospace;"></span><br style="font-family: courier new,monospace;"><br>By the way, I'm the Herron mentioned in bb-roracle's revision history.
<br><br><div><span class="gmail_quote">On 18 Jul 2007 14:49:08 -0000, <b class="gmail_sendername"><span style="font-weight: bold;">James Wade </span></b></span><span class="gmail_quote">wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div style="direction: ltr;"><br></div><div link="blue" vlink="purple" lang="EN-US"><div><p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">I'm looking at implementing an Oracle monitor in
</span>
</font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Hobbit, and I thought I'd ask for a recommendation.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">On deadcat, I've seen Roracle-2-21a.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">How would this be implemented in Hobbit, I have</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">multiple database servers. Are we looking at a</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">client, or implementing a single script from the server</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">to monitor the database servers?</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">The problem I've seen is that if it's not a
client, the</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">gui doesn't show up on the associated system.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Any pointers would be appreciated.</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Thanks….James</span></font></p></div></div></blockquote></div><br>