checks/oracle_recovery_area

   1 #!/usr/bin/python
   2 # -*- encoding: utf-8; py-indent-offset: 4 -*-
   3 # +------------------------------------------------------------------+
   4 # |             ____ _               _        __  __ _  __           |
   5 # |            / ___| |__   ___  ___| | __   |  \/  | |/ /           |
   6 # |           | |   | '_ \ / _ \/ __| |/ /   | |\/| | ' /            |
   7 # |           | |___| | | |  __/ (__|   <    | |  | | . \            |
   8 # |            \____|_| |_|\___|\___|_|\_\___|_|  |_|_|\_\           |
   9 # |                                                                  |
  10 # | Copyright Mathias Kettner 2014             mk@mathias-kettner.de |
  11 # +------------------------------------------------------------------+
  12 #
  13 # This file is part of Check_MK.
  14 # The official homepage is at http://mathias-kettner.de/check_mk.
  15 #
  16 # check_mk is free software;  you can redistribute it and/or modify it
  17 # under the  terms of the  GNU General Public License  as published by
  18 # the Free Software Foundation in version 2.  check_mk is  distributed
  19 # in the hope that it will be useful, but WITHOUT ANY WARRANTY;  with-
  20 # out even the implied warranty of  MERCHANTABILITY  or  FITNESS FOR A
  21 # PARTICULAR PURPOSE. See the  GNU General Public License for more de-
  22 # tails. You should have  received  a copy of the  GNU  General Public
  23 # License along with GNU Make; see the file  COPYING.  If  not,  write
  24 # to the Free Software Foundation, Inc., 51 Franklin St,  Fifth Floor,
  25 # Boston, MA 02110-1301 USA.
  26
  27 # <<<oracle_recovery_area>>>
  28 # TUX12C 0 4800 19 0
  29
  30 # Columns:
  31 # ORACLE_SID used_pct size used reclaimable
  32
  33 factory_settings["oracle_recovery_area_defaults"] = {
  34     "levels": (70.0, 90.0),
  35 }
  36
  37
  38 def inventory_oracle_recovery_area(info):
  39     return [(line[0], {}) for line in info]
  40
  41
  42 def check_oracle_recovery_area(item, params, info):
  43     for line in info:
  44         if line[0] == item:
  45             size_mb, used_mb, reclaimable_mb = map(int, line[2:5])
  46             if size_mb == 0:
  47                 perc_used = 0
  48             else:
  49                 perc_used = float(used_mb - reclaimable_mb) / size_mb * 100
  50
  51             warn, crit = params["levels"]
  52             warn_mb = size_mb * warn / 100
  53             crit_mb = size_mb * crit / 100
  54
  55             if perc_used >= crit:
  56                 state = 2
  57             elif perc_used >= warn:
  58                 state = 1
  59             else:
  60                 state = 0
  61
  62             mb = 1024 * 1024
  63             return state, "%s out of %s used (%.1f%%, warn/crit at %s%%/%s%%), %s reclaimable" \
  64                 % (get_bytes_human_readable(used_mb*mb), get_bytes_human_readable(size_mb*mb), \
  65                    perc_used, warn, crit, get_bytes_human_readable(reclaimable_mb*mb)), \
  66                    [('used', used_mb, warn_mb, crit_mb, 0, size_mb), ('reclaimable', reclaimable_mb)]
  67
  68     # In case of missing information we assume that the login into
  69     # the database has failed and we simply skip this check. It won't
  70     # switch to UNKNOWN, but will get stale.
  71     raise MKCounterWrapped("Login into database failed")
  72
  73
  74 check_info['oracle_recovery_area'] = {
  75     "check_function": check_oracle_recovery_area,
  76     "inventory_function": inventory_oracle_recovery_area,
  77     "service_description": "ORA %s Recovery Area",
  78     "has_perfdata": True,
  79     "default_levels_variable": "oracle_recovery_area_defaults",
  80     "group": "oracle_recovery_area",
  81 }