[v3.3.2.1] mode 'flash-recovery-area-usage' - Use of uninitialized value $has_flash in string eq at line 4599.

[log1-c]

Hi :)

After updating the script to v3.3.2.1 all flash-recovery-area-usage checks print Use of uninitialized value $has_flash in string eq at /usr/lib/nagios/plugins/check_oracle_health line 4599. before the actual check output.

No matter if the check would be OK (flash recovery area found) or critical (not found).

Changing line 4599 to

if ($has_flash and $has_flash eq "NO") {

gets rid of the message for both cases.

Seems to me that this script part is "nulling" the $has_flash variable

if ($self->version_is_minimum("10.x")) {
      $has_flash = $params{handle}->fetchrow_array(q{
          select FLASHBACK_ON from v$database;
      });
    }

As I have no clue about Oracle databases, I don't know if what I did makes sense.

Best regards
log1c

[Steampower]

Hi All,

although I have limited knowledge about perl, I know quite a bit about oracle databases... and sorry, this part makes no sense to me.

when I read the script correct the plugin will always return OK when flashback is disabled... unfortunately the flash recovery area can store more than flashback logs, so it might important to monitor the usage even if flashback is disabled...

cheers
Benjamin