Mk_oracle troubleshooting - does not seem to connect

Troubleshooting
,
1

Server: 2.4.0p12 on Alma Linux 9.6
Agents: Linux agents on Oracle Linux 8/9

This is the first time I’m trying to set up mk_oracle, and I can’t get it to work.
I’m following this documentation: Monitoring Oracle databases

The server is running, the agents themselves are fine but mk_oracle doesn’t work.

cat /etc/check_mk/mk_oracle.cfg
DBUSER='checkmk:checkmk' # (I have tried various variations of this, as per the template)

# /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>>>

Not really sure what to do with this… I can see no trace of the checkmk user logging in to the database.

2

Hi,

Since you are following the documentation I assume that you have created the db user with the proper rights?

Have you tried to run the plugin with logging?

First set the environmental varaiables
export MK_CONFDIR=“/etc/check_mk”
export MK_VARDIR=“/var/lib/check_mk_agent”

Then you run the oracle plugin with the logging option
/usr/lib/check_mk_agent/plugins/mk_oracle -l

This will log the output to /var/lib/check_mk_agent/log/mk_oracle.log

There you can look for possible errors

You might also want to set this config syntax, if you haven’t already. I usually use this and almost works every time.

DBUSER_=‘dbuser:password::hostname:port’

replace with you actual sid/dbname

/r