Error message under Status Information

[jimhoffmann]

We have Oracle DB server that is showing a critical status for the Service, dev Tablespace Remaining Time. When we look at the Status Information is shows the following: (No output on stdout) stderr: Can't use an undefined value as an ARRAY reference at /usr/local/nagios/libexec/check_oracle_health line 3228.

What does this error means and how do we correct it?

We are currently using Nagios XI 2014R2.7

[tgriep]

Can you post the configuration for this check?
Can you run the check from the command line and post the output back here?
Is this an existing service check that started failing or is it a new configuration?

[jimhoffmann]

This is an existing check. Not sure if it ever worked or not but we just noticed it now.

I am fairly new to Linux so if you tell what command I need to run from the command line I can do that for you.

[tgriep]

Lets start with the configuration first.
In the Nagios XI GUI, click on Configure > Core Config Manager > Services.
Find the name of the service that is failing, click on the floppy icon and you should be able to see the configuration for it.
Copy that and paste it here in code wraps.

[jimhoffmann]

define service {
host_name testdb.sfmic.com
service_description dataw Tablespace Remaining Time
use xiwizard_oracletablespace_service
check_command check_xi_oracletablespace!--connect 'testdb.sfmic.com:1525/dataw' --username 'nagios' --password 'xxxxx' --mode tablespace-remaining-time --warning 10 --critical 20
max_check_attempts 5
check_interval 5
retry_interval 1
check_period xi_timeperiod_24x7
notification_interval 60
notification_period xi_timeperiod_24x7
contacts nagiosadmin
_xiwizard oracletablespace
register 1
}

[tgriep]

Here is a link to the developer of this plugin. Can you go and verify that the Preparation on the Database was done?
https://labs.consol.de/nagios/check_ora ... e-database

Another thing to try is to add the --tablespace <database> argument to your check. Replace <database> with the database you are trying to monitor.
Try that and let us know how it works out.