At 10:24 AM 8/20/02 +0100, you wrote: >I have been tasked to widen the scope of mon to include the oracle >databases (on aix) the m$sql databases (on nt) and various other services. >I initially refused citing "jobsworth" area of responsibilities etc, and >got the reply - do it anyway!
Heh. Welcome to the "new new economy" :) >I am a bit stuck. I have read through the man pages, searched through the >mailing list and there doesn't seem to be a set much help on how to check >the database connections. To make it a bit more complicated, the NMS I am >using is an old sun ultra 5 with suse linux 7.1 on it. (so intel rpm's are >out) I don't really want to install Oracle on it (in order to get the perl >oracle module to work) or to get sqlnet or tnsping installed. OK, we like a challenge.... There are 2 ways to remotely monitor a database using mon: 1) Run a command locally on the DB server to verify its health, and check its output with something like one of the snmpvar monitors. Technically you could also send a mon trap from the remote host. 2) Run a command over the network, from the NMS, to check the health of a DB, and check its output. If you use oracle, this would be something like tnsping or perl DBI. Both of these would require installing some Oracle software on your NMS. I've done both and both work well. Method #2 is good because it allows you to centralize your configuration, while method #1 is good if you want your oracle DBA to maintain the test script(s) and not give them access to your NMS. >3. Another issue that has me a bit stumped, is if I want to monitor a >range of workstations - is this possible? Ideally an IP address with a >qualifying subnet mask. No, but it would be easy enough to write a bit of perl to autogenerate a valid mon hostgroup line. >4. Is there a list of services that can be called from within the mon.cfg? >I guess it must be somewhere but I haven't come across it yet... I'm not sure what you mean by this question... >5. Additionally has anyone got any tips on using the ntservice.monitor? I >have an eval copy of the empire SNMP s/w running on a test NT box, I can >use snmpwalk to get the response from the box, but can't get the >ntservice.monitor to communicate with it. If I try and run it >independantly on the command line, I get "no such file or directory" I wrote it, so I guess I would be a good person to ask about it. If you can't run it on the command line, and get that error msg, you probably don't have perl installed in the place where ntservice.monitor expects to find it. andrew
