Page 1 of 1

UNKNOWN-check_oracle_health timed out after 60 seconds!!!

Posted: Wed Jan 16, 2019 4:00 am
by anhphuong
Hello everyone,

I am using the plugin for oracle from nagios XI and in a particular service I have problems.

The service with problems is tablespace-can-allocate-next, the rest works without problems.

The error is as follows:

[root@nagiosXI]# /usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 /usr/local/nagios/libexec/check_oracle_health --connect '192.168.2.10:1521/DDBB_SRV' --username 'nagios' --password 'oradbmon' --mode tablespace-can-allocate-next --warning 20 --critical 30
UNKNOWN - check_oracle_health timed out after 60 seconds

The nagios log shows the following:

Jun 20 17:53:11 nagiosXI nagios: SERVICE ALERT: bdrac1;Tablespace SYSTEM Can Allocate Next;UNKNOWN;HARD;5;UNKNOWN - check_oracle_health timed out after 60 seconds


Thank you

Re: UNKNOWN-check_oracle_health timed out after 60 seconds!!

Posted: Wed Jan 16, 2019 10:20 am
by mcapra
This particular style of issue pops up a lot:
https://support.nagios.com/forum/viewto ... 5&p=251254
https://support.nagios.com/forum/viewto ... 3&p=227255
https://support.nagios.com/forum/viewto ... 1&p=260941
https://support.nagios.com/forum/viewto ... 0&p=264313

That plugin simply takes a while to execute on "busy" databases. There are global Nagios level configuration changes like service_check_timeout that can be leveraged, but the general recommendation is to handle long-running checks passively.

Re: UNKNOWN-check_oracle_health timed out after 60 seconds!!

Posted: Thu Jan 17, 2019 5:02 pm
by lmiltchev
@anhphuong, let us know if @mcapra's suggestions helped.