Support for Nagios products and services
https://support.nagios.com/forum/
You could backup your "old" plugin (just in case), then download, and compile the latest version (3.2.1.1) on your nagios machine. Test it from the command line to make sure it works. You could run something like this:3.2.1 - 2019-10-10
add mode blocking-sessions (Thanks dbmasters.at for the sql)
Code: Select all
/usr/local/nagios/libexec/check_oracle_health --connect 'x.x.x.x:1521/yyyy' --username 'username' --password 'password' --mode sql --name="select count(*) from Gv\$"$"session where blocking_session is not NULL order by blocking_session" --warning 50 --critical 200Code: Select all
/usr/local/nagios/libexec/check_oracle_health --connect 'x.x.x.x:1521/yyyy' --username 'username' --password 'password' --mode sql --name="select count(*) from v\$session where blocking_session is not NULL order by blocking_session" --warning 50 --critical 200