Nagios Support Forum

@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: 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.

Thanks [email protected]!

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) list-tablespace (the same error) Thank you ~

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