Monitoring Oracle server space

[ets_user]

Hi,

We are trying to monitor our Oracle serverspace.

We did the configurations as per the document https://assets.nagios.com/downloads/nag ... ios-XI.pdf
and installed all the rpm's.

But when we try to add for monitoring we are getting the error as below for the services.

Kindly advise.

Except first two all others are having errors.

ora19 Connected Users Ok 2h 0m 13s 1/5 2020-06-16 00:30:42 OK - 0 connected users
ora19 Connection Time Ok 1h 57m 33s 1/5 2020-06-16 00:28:14 OK - 0.07 seconds to connect as issoam
ora19 Flash Recovery Area Usage Critical 18d 11h 34m 56s 5/5 2020-06-16 00:29:36 (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.
ora19 PGA In Memory Sort Ratio Critical 18d 11h 34m 43s 5/5 2020-06-16 00:29:38 CRITICAL - unable to get pga ratio
ora19 Redo I/O Traffic Critical 18d 11h 34m 28s 5/5 2020-06-16 00:29:53 CRITICAL - unable to get redo size
ora19 Retry Ratio Critical 18d 11h 34m 18s 5/5 2020-06-16 00:30:10 CRITICAL - unable to get retry ratio
ora19 Roll Block Contention Critical 18d 11h 34m 46s 5/5 2020-06-16 00:30:14 CRITICAL - unable to get rollback segments wait stats
ora19 Roll Extends Critical 18d 11h 39m 8s 5/5 2020-06-16 00:30:19 CRITICAL - unable to get rollback segments stats
ora19 Roll Header Contention Critical 18d 11h 39m 7s 5/5 2020-06-16 00:29:10 CRITICAL - unable to get rollback segments wait stats
ora19 Roll Hit Ratio Critical 18d 11h 38m 58s 5/5 2020-06-16 00:28:03 CRITICAL - unable to get rollback segments wait stats
ora19 Roll Wraps Critical 18d 11h 38m 51s 5/5 2020-06-16 00:28:17 CRITICAL - unable to get rollback segments stats
ora19 SGA Data Buffer Hit Ratio Critical 18d 11h 38m 42s 5/5 2020-06-16 00:28:23 CRITICAL - unable to get sga buffer cache
ora19 SGA Dictionary Cache Hit Ratio Critical 18d 11h 38m 34s 5/5 2020-06-16 00:28:31 CRITICAL - unable to get sga dc
ora19 SGA Latch Hit Ratio Critical 18d 11h 38m 26s 5/5 2020-06-16 00:28:34 (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.
ora19 SGA Library Cache Hit Ratio Critical 18d 11h 38m 17s 5/5 2020-06-16 00:29:02 CRITICAL - unable to get sga lc
ora19 SGA Shared Pool Free Critical 18d 11h 38m 9s 5/5 2020-06-16 00:29:19 CRITICAL - unable to get sga free
ora19 SGA Shared Pool Reload Ratio Critical 18d 11h 38m 0s 5/5 2020-06-16 00:29:19 CRITICAL - unable to get sga reloads
ora19 Soft Parse Ratio Critical 18d 11h 37m 53s 5/5 2020-06-16 00:28:25 CRITICAL - unable to get parser

[cdienger]

Check out:

https://labs.consol.de/nagios/check_ora ... e-database

It covers the permissions needed on the database for the checks to work.