Hi,
I made some tests. Actually agent seems to run as root, where it has no access to Oracle. Executing plugin as oracle linux user output is as below:
[oracle:/usr/lib/check_mk_agent/plugins] ./mk_oracle -t
<<<oracle_instance>>>
<<<oracle_sessions>>>
<<<oracle_logswitches>>>
<<<oracle_undostat>>>
<<<oracle_recovery_area>>>
<<<oracle_processes>>>
<<<oracle_recovery_status>>>
<<<oracle_longactivesessions>>>
<<<oracle_dataguard_stats>>>
<<<oracle_performance>>>
<<<oracle_locks>>>
<<<oracle_systemparameter>>>
<<<oracle_tablespaces>>>
<<<oracle_rman>>>
<<<oracle_jobs>>>
<<<oracle_resumable>>>
<<<oracle_iostats>>>
<<<oracle_instance>>>
<<<oracle_processes>>>
<<<oracle_asm_diskgroup>>>
—login----------------------------------------------------------------
Operating System: Linux
ORACLE_HOME (GI): /u01/app/grid/product/19.0.0/grid_1
Logincheck to Instance: +ASM
Version: 19.0
Logindetails: /@localhost:1521/+ASM
Error Message: +ASM|FAILURE|ERROR: ORA-15000: command disallowed by current instance type SP2-0751: Unable to con
SYNC_SECTIONS: instance processes
ASYNC_SECTIONS: asm_diskgroup
—login----------------------------------------------------------------
Operating System: Linux
ORACLE_HOME (GI): /u01/app/oracle/product/19.0.0/db_1
Logincheck to Instance: INST001
Version: 19.0
Logindetails: /@INST001
Error Message: INST001|FAILURE|ERROR: ORA-01017: invalid username/password; logon denied SP2-0751: Unable to con
SYNC_SECTIONS: instance sessions logswitches undostat recovery_area processes recovery_status longactivesessions dataguard_stats performance locks systemparameter
ASYNC_SECTIONS: tablespaces rman jobs resumable iostats
I hope this helps to point to right direction.
Regards,
Olsi