Problems configuring the oracle plugin in checkmk raw 1.6.0p9

[francis (francisco)]

Hello!
My version of checkmk is raw is 1.6.0p9 . I am trying to configure the oracle plugin mk_oracle following the documentation Monitoring Oracle databases efficiently but I cannot get information from the database in the checkmk. Sure there is something that I am not understanding and I am doing it wrong.I am getting the following error

ORA TEST1 Instance ERROR: ORA-12541: TNS: no listener SP2-0751: Unable to connect to Oracle. Exiting SQL * Plus

I cannot identify where I am failing in the configuration process.I have the following file created and user check_mk created in the database with the permissions it needs to be able to access the information

/ etc / check_mk
     drwxr-xr-x 2 root root 63 Oct 22 11:31 cache
     -rw-r - r-- 1 root root 40 Oct 22 08:48 encryption.cfg
     drwxr-xr-x 2 root root 6 Oct 22 11:31 log
    -rwxr-xr-x 1 root root 68 Oct 22 11:20 mk_oracle.cfg
    -rw-r - r-- 1 root root 0 Oct 22 11:31 mk_oracle.found
    -rwxr-xr-x 1 root root 217 Oct 22 08:51 sqlnet.ora
    -rwxr-xr-x 1 root root 660 Oct 22 08:52 tnsname.ora

/ usr / lib / check_mk_agent / plugins /
     -rwxr-xr-x 1 root root 108 817 Oct 22 11:01 mk_oracle

Am I missing a step?

Thank you!

[Rendanic (Thorsten Bruhns)]

Hi Francis,
Use the testmode to check the configuration:

export MK_CONFDIR=/etc/check_mk
/var/lib/check_mk_agent/plugins/mk_oracle -t

The test does a connection test and prints the connection details.
It looks like an issue with wrong listener port or your listener ignores localhost.

[francis (francisco)]

Hello .
I perform the check and I get the following error.

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_tablespaces>>>
<<<oracle_rman>>>
<<<oracle_jobs>>>
<<<oracle_ts_quotas>>>
<<<oracle_resumable>>>
<<<oracle_instance>>>
<<<oracle_processes>>>
<<<oracle_asm_diskgroup>>>

login----------------------------------------------------------------
    Operating System:       Linux
    ORACLE_HOME (oratab):   /oracle/product/11.2.0.4
    Logincheck to Instance: CACTUS
    Version:                11.2
Logindetails:
CACTUS|FAILURE|ERROR: ORA-12541: TNS:no listener   SP2-0751: Unable to connect to Oracle.  Exiting SQL*Plus
    SYNC_SECTIONS:          instance sessions logswitches undostat recovery_area processes recovery_status longactivesessions dataguard_stats performance locks
    ASYNC_SECTIONS:         tablespaces rman jobs ts_quotas resumable

[pn-rallen (Richard Allen)]

“no listener” - are you able to manually connect to the correct port on the oracle server from the check mk server, e.g. using telnet?

It looks like you might need to configure the listener Oracle client ORA-12541: TNS:no listener - Stack Overflow

[ricardof]

Hi,

If your filenames in /etc/check_mk is correct in your post, then you should change the file name from “tnsname.ora” to tnsnames.ora (plural). That’s the name oracle looks for.

@francis

-rwxr-xr-x 1 root root 660 Oct 22 08:52 tnsname.ora

/ricardo