James,
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.
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.
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:
#bb-hosts page Unix Unix group-compress 192.168.222.111 fintest # oratns page Windows Windows group-compress 192.168.222.123 timecard # oratns 192.168.222.132 loaddata # oratns page Database Databases group-compress 192.168.222.111 fintest.financetest # noconn 192.168.222.123 timecard.timeentry # noconn 192.168.222.132 loaddata.loaddata # noconn
#bb-roracle.ids #type SID userid password tests log-as-host listener-name LOCAL financetest bbuser bbpasswd aBE fintest.financetestlsnr_fintest REMOTE timeentry bbuser bbpasswd aBEfijk timecard.timeentry REMOTE loaddata bbuser bbpasswd aBEfijk loaddata.loaddata
By the way, I'm the Herron mentioned in bb-roracle's revision history.
On 18 Jul 2007 14:49:08 -0000, James Wade wrote:
I'm looking at implementing an Oracle monitor in
Hobbit, and I thought I'd ask for a recommendation.
On deadcat, I've seen Roracle-2-21a.
How would this be implemented in Hobbit, I have
multiple database servers. Are we looking at a
client, or implementing a single script from the server
to monitor the database servers?
The problem I've seen is that if it's not a client, the
gui doesn't show up on the associated system.
Any pointers would be appreciated.
Thanks….James