Check to use a oracle sql query

Service Monitoring
1

Hi all

I have to implement a check, which uses a sql query to get some values from a table in oracle. This value(s) should be returned as performance values and stored in influxdb.
Can anyone give me some hints, which existing check I could use? Until now, I only found the rather old check_sql_query (https://exchange.nagios.org/directory/Plugins/Databases/Oracle/check_sql_query/details). I need something like check_mysql_query for oracle databases.

Thanks for some hints
Matthias

2

You can have a look at check_oracle_health with the mode sql.

2 Likes
3

Thanks a lot, I will try this. I found the plugin already, but didn’t notice the sql mode.

Works!

Thanks a lot Dirk.