Plugin MK_oracle not showing information

[xmatrix83]

Hi to all,
i am trying to monitor an old oracle 10 server installed on centos5.
The normal agent checks work fine, now I was trying to configure the plugin for oracle but from check_mk doing the full discovery of the services it doesn’t show anything and launching the plugin on the server itself doesn’t seem to bring out any information.

[root@SRV-ORACLE ~]# cat /etc/check_mk/mk_oracle.cfg
# Syntax:
# DBUSER='USERNAME:PASSWORD'
DBUSER='checkmk:XXXXX'

[oracle@SRV-ORACLE ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 13 12:23:23 2022

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> connect checkmk/XXXXX
Connected.
SQL> exit

[root@SRV-ORACLE ~]# export MK_CONFDIR="/etc/check_mk"
[root@SRV-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>>>

[xmatrix83]

Oracle empty result

I try to run the code, and get this at the end [image] Try googling for it, found [Check_mk (english)] Monitoring free space in Oracle 11 Database which mention to remove the some line. [image] I remove this line at the /usr/lib/check_mk_agent/plugins/mk_oracle and now it work! Thanks

following this post i commented the lines and now the result is different.

[root@SRV-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 (oratab):   /oracle/product/10.2.0/db_1
    Logincheck to Instance: ORASII
    Version:                10.2
    Logindetails:           checkmk/XXXXXXX@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=ORASII)(SERVER=DEDICATED)(UR=A)))
    Error Message:          ORASII|FAILURE|ERROR: ORA-12541: TNS:no listener   SP2-0751: Unable to connect to Oracle.  Exiting S
    SYNC_SECTIONS:          instance sessions logswitches undostat recovery_area processes recovery_status longactivesessions dataguard_stats performance locks systemparameter
    ASYNC_SECTIONS:         tablespaces rman jobs resumable iostats
------------------------------------------------------------------------

[xmatrix83]

I solved it by myself.
The final piece of the puzzle was setting up the cfg this way

[root@SRV-ORACLE ~]# cat /etc/check_mk/mk_oracle.cfg
# Syntax:
# DBUSER='USERNAME:PASSWORD'
DBUSER='checkmk:XXXXX::192.168.0.252:1521'

[Rendanic (Thorsten Bruhns)]

Your database version is extremly old.
Hopefully you have no database links to newer database version:

You MUST patch 12.1.0.1 and 11.2.0.3 and older databases before June 2019

This is really a serious issue - do not ignore it!