We have recently upgraded check_oracle_health plugin to latest version as per suggestion from nagios support and after couple of months of upgrading check_oracle_heath plugin to latest version we are again seeing nagios tends to open 600+ open sessions(from perl@nagioshost) causing database performance issue. Can some one help me to fix this issue. It's impacting production database server.
Regards,
Mohan
Nagios eating up database resources on end point machine
Re: Nagios eating up database resources on end point machine
Do the sessions build up over time or is it a sudden jump in sessions? Is this happening with a specific check or query? You may want to reach out to the DBA to see if there are any settings available on the DB that can close idle sessions.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Re: Nagios eating up database resources on end point machine
Sometimes these sessions buildup over time and sometimes it's a sudden Jump . Especially table space queries/checks from check_oracle_healh plugin using to poll/query endpoint database are causing this. I will reach out to DBA and will post you update on whether we have option of closing idle sessions or not. Even if they have option of this, if a session is hung/long running session this will make session open from nagios to database. Last time also there are hell lot of hung/long running sessions causing performance issues and DBA's manaully need to kill all those hung sessions and even after killing nagios is opening bulk open sessions immediately in a shorter span of time.
For the same server, im seeing below error from last one day for all table space checks.
(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.
For the same server, im seeing below error from last one day for all table space checks.
(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.
Re: Nagios eating up database resources on end point machine
Please open a ticket for this and we can take a closer look.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Re: Nagios eating up database resources on end point machine
https://support.nagios.com/tickets/tickets.php?id=3744
support ticket has been raised . let me know when we can have webex and troubleshoot this further.
support ticket has been raised . let me know when we can have webex and troubleshoot this further.
Re: Nagios eating up database resources on end point machine
Ticket received. Locking thread.
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.