XI check_oracle_health plugin tablespace errors

[[email protected]]

@comeonyoyo

Should the --mode connection-time mode that Scott suggests to check work, please also check --mode list-tablespacese.

If the last one fails then double check preparation steps at https://labs.consol.de/nagios/check_ora ... e-database. Especially these:

Code: Select all

grant select on SYS.DBA_DATA_FILES to nagios;
grant select on SYS.DBA_FREE_SPACE to nagios;

I've seen situations where either SYS.DBA* or V$INSTANCE grants were missing resulting in the error you reported. By the way.. your output proves that SELECT version FROM v$instance runs OK. So you can focus on SYS.DBA_DATA_FILES and SYS.DBA_FREE_SPACE.

[scottwilkerson]

Thanks [email protected]!

[comeonyoyo]

here is the result of test, and I will check with the owner of the database

grant select on SYS.DBA_DATA_FILES to nagios;
grant select on SYS.DBA_FREE_SPACE to nagios;

connection-time (looks ok)

connection time.png

list-tablespace (the same error)

list tablespace.png

Thank you ~

[scottwilkerson]

Yes I would definitely check to verify the items mentioned above with the DB owner.