check_oracle_plugin throws error for table space checks

[mohan23]

I have came across issues with table spaces using check_oracle_health for few of the servers , Below is the error we are getting


(No output on stdout) stderr: bumm Can't call method "execute" on an undefined value at /usr/local/nagios/libexec/check_oracle_health line 6287.

Can't use an undefined value as an ARRAY reference at /usr/local/nagios/libexec/check_oracle_health line 6301.

All permissions are good from database end. Let me know what needs to be done to fix this

[cdienger]

This looks like the same message that was posted in https://support.nagios.com/forum/viewto ... 16&t=50882 and may be related to the problem that that thread was opened for. If you open a ticket we can take a closer look at both.

[mohan23]

Now the problem is that all table space checks are taking more than 3 mins to get the table space information. and Our DBA's are questioning us saying below comment

"Can you please explain us how is this query generated. I see the query is not efficient running on database"

currently we have latest version on check_oracle_health on our nagiosxi servers. Request immediate response.

Regards,
Mohan Gandhi

[cdienger]

Is this the plugin found at https://labs.consol.de/nagios/check_ora ... index.html ? If so, the source code is available at https://labs.consol.de/nagios/check_ora ... l#download.