Page 1 of 1

check_oracle_plugin throws error for table space checks

Posted: Tue Oct 30, 2018 1:02 am
by 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

Re: check_oracle_plugin throws error for table space checks

Posted: Tue Oct 30, 2018 12:34 pm
by 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.

Re: check_oracle_plugin throws error for table space checks

Posted: Tue Nov 13, 2018 9:43 am
by 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

Re: check_oracle_plugin throws error for table space checks

Posted: Tue Nov 13, 2018 12:45 pm
by cdienger