TOP LEVEL CATEGORIES
EXPLORE
Description:
yaonp – yet another oracle nagios plugin
for a short overview a list of advantages and disadvantages for this plugin
advantages
– it works at least for my test enviroment consisting of Nagios XI (Linux, Ubuntu), Oracle 11g2 on Solaris 10 (Sparc) as it uses only basic functionality it should work with all Nagios releases – uses no additional perl modules – needs no other software components, except a standard oracle installation with available sqlplus – many tests, each for it self may be activates or deactivated. Following tests are currently implemented: # Dictionary Cache Miss Ratio # Library Cache Miss Ratio # DB Block Buffer Cache Miss Ratio # redo buffer allocation entries/retries ratio # Latch Miss Ratio # Disk Sort Ratio # Rollback Segment Waits # Dispatcher Workload # Count Sessions # Number of locked objects # Number of locks blocking other locks # Number of sessions blocked by other sessions longer than a minute # Tablespace Usage – no additional rights needed for nagios user – simple configuration, just some variables in the scripts have to be filled – written to be easy extensible, even by Oracle DBAs who don’t know much perl
disadvantages
– uses two scripts, not only one like many other plugins – even worse, one of the scripts has to be run from an privileged account as “SELECT”-right is needed on v$- and dba_-views – it is version 1.0, there may be some minor bugs and glitches, please report if you find one.
Current Version
Last Release Date
2012-06-02
Compatible With
Owner
Arvids Lemchens
License
GPL
Sorry for answering your question so late. But i had problems with my internet connection and was most time offline. Even now it is very slow and often disconnecting. But now back to topic. Here is a small, step by step, example how to extend yaonp: 1. on oracle host 1. open yaonp-collector.pl, go to the section where the checks are defined and copy/paste the last check, three lines. E.g. $NAME[12]='tbspcuse'; $ACTIVE[12]='yes'; $SQL[12]='SELECT 'tbspcuse'||'|'||ROUND(USED_PERCENT)||'|'||TABLESPACE_NAME||'|'||'|Tablespace Usage=%|' FROM dba_tablespace_usage_metrics;'; 2. modify this lines to your needs a. give the test a name. Eg. sessuti b. count the array index up by one c. edit the SQL-Statement to your needs and adjust the output fitting for yaonp-plugin.pl. E.g. select current_utilization from v$resource_limit where resource_name ='sessions'; will be 'SELECT 'sessuti'||'|'||current_utilization||'|'||'|'||'|Session Utilization=%|'FROM v$resource_limit WHERE resource_name ='sessions';'; the resulting lines should look like: $NAME[13]='sessuti'; $ACTIVE[13]='yes'; $SQL[13]='SELECT 'sessuti'||'|'||current_utilization||'|'||'|'||'|Session Utilization=%|'FROM v$resource_limit WHERE resource_name ='sessions';'; 3. test it ozone:~$ ./yaonp-collector.pl |grep sess numsessions|24|||Count Sessions=| numblcksess|0|||Number of sessions blocked by other sessions=| sessuti|31|||Session Utilization=%| looks good. 4. edit nrpe.cfg and insert the new check, e.g. command[ora_sessuti]=/usr/local/nagios/libexec/yaonp-plugin.pl sessuti -w 50% -c 75% 5. reload/restart nrpe. All done on oracle host. 2. on nagios host 1. edit checkcommands.cfg and insert the new command, e.g. define command { command_name ora_sessuti command_line $USER1$/check_nrpe -H $HOSTADDRESS$ -c ora_sessuti } 2. edit services.cfg, e.g. define service { service_description ora_sessuti check_command ora_sessuti! host_name ozone check_period 24x7 event_handler_enabled 0 max_check_attempts 3 check_interval 5 retry_interval 1 active_checks_enabled 1 passive_checks_enabled 0 notifications_enabled 1 check_freshness 0 freshness_threshold 86400 contact_groups admins } 3. reload/restart nagios/icinga on your nagios host 4. done
You must be logged in to submit a review.
Your review has been submitted and is pending approval.
To:
From:
Your recommendation has been sent.