Monitoring Oracle

General
1

Hello friends,

I have Checkmk Raw Edition 2.3.0p11, I have to monitor an oracle DB I am following this URL Monitoring Oracle databases. But I still don’t understand. I don’t know if I have to create a user in the Linux O.S. someone could help me.
I have an oracle 19c single restart. Any help would be appreciated.

Regards

2

As the documentation-link describes, you do not need/require to create a user on the OS-level, but on the Database-server level.
I think that is where your confusion started/misinterpreted what is expected to be configured.

  • Glowsome
3

Hello,

I am running but nothing is coming back. I created the user according to the page for both oracle and asm. I am running from root the command mk_oracle -t and nothing comes back.

[root@oraprepro7 plugins]# ./mk_oracle -t
<<<oracle_instance>>>
<<<oracle_processes>>>
<<<oracle_sessions>>>
<<<oracle_logswitches>>>
<<<oracle_jobs>>>
<<<oracle_rman>>>
<<<oracle_tablespaces>>>
<<<oracle_locks>>>
<<<oracle_instance>>>
<<<oracle_asm_diskgroup>>>
[root@oraprepro7 plugins]#  

I don't know what else could be wrong. I have the files

[root@oraprepro7 plugins]# ls -l
total 240
-rwxrwxr-x 1 root   root      48592 jun 17 13:36 mk_logwatch_2.py
-rwxrwxr-x 1 root   root      48293 jun 17 13:36 mk_logwatch.py
-rwxr-xr-x 1 oracle oinstall 138981 jun 17 12:42 mk_oracle
-rwxr-xr-x 1 root   root       6413 jun 17 12:42 mk_oracle_crs
[root@oraprepro7 plugins]# 

[root@oraprepro7 plugins]# cat /etc/check_mk/mk_oracle.cfg | grep -v '^#'

TNS_ADMIN='/u01/app/grid/product/19c/grid/network/admin'

DBUSER='MONITOR:LOQUESEA'


ASMUSER='MONITOR:loquesea:SYSASM'

SYNC_SECTIONS='instance processes sessions logswitches'
ASYNC_SECTIONS='jobs rman tablespaces locks'
SYNC_ASM_SECTIONS='instance'
ASYNC_ASM_SECTIONS='asm_diskgroup'

CACHE_MAXAGE=600

DEBUG=yes
LOG_FILE=/var/log/check_mk/mk_oracle.log

[root@oraprepro7 plugins]# ´´´

If you can help me on what I am doing wrong I would appreciate it.

Regards
4

Run:

./mk_oracle -t -l or ./mk_oracle -l

Then check the log file to see what mk_oracle outputs. Look for errors or warnings that might explain why Oracle monitoring isn’t working as expected.

5

Hi @LaSoe

the message is

[root@oraprepro7 plugins]# 
[root@oraprepro7 plugins]# ./mk_oracle -l
Logging to file: /var/lib/check_mk_agent/log/mk_oracle.log
./mk_oracle: línea 565: perl: no se encontró la orden
./mk_oracle: línea 565: perl: no se encontró la orden
<<<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>>>
./mk_oracle: línea 565: perl: no se encontró la orden
./mk_oracle: línea 565: perl: no se encontró la orden
./mk_oracle: línea 565: perl: no se encontró la orden
./mk_oracle: línea 565: perl: no se encontró la orden
 [2] [+ASM] [set_ora_env] TNS_ADMIN/sqlnet.ora: /network/admin/sqlnet.ora
./mk_oracle: línea 565: perl: no se encontró la orden
./mk_oracle: línea 565: perl: no se encontró la orden
./mk_oracle: línea 565: perl: no se encontró la orden
 [2] [PREPRO7] [set_ora_env] TNS_ADMIN/sqlnet.ora: /network/admin/sqlnet.ora
./mk_oracle: línea 565: perl: no se encontró la orden
./mk_oracle: línea 565: perl: no se encontró la orden
[root@oraprepro7 plugins]#´´´
6

install perl

[root@oraprepro7 plugins]# ./mk_oracle -l
Logging to file: /var/lib/check_mk_agent/log/mk_oracle.log
<<<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>>>
2025-06-23 10:59:46 [2] [+ASM] [set_ora_env] TNS_ADMIN/sqlnet.ora: /network/admin/sqlnet.ora
2025-06-23 10:59:46 [2] [PREPRO7] [set_ora_env] TNS_ADMIN/sqlnet.ora: /network/admin/sqlnet.ora

But I don’t see any errors

7

Try setting the DBUSER line in /etc/check_mk/mk_oracle.cfg completely with the user, host, port, sid etc:

DBUSER='<<db_username>>:<<db_password>>::<<hostname>>:<<port>>::'

Replace the db_username, hostname and port above with the relevant values.

As root on your db server:

export MK_CONFDIR=/etc/check_mk
export MK_VARDIR=/var/lib/check_mk_agent
/usr/lib/check_mk_agent/plugins/60/mk_oracle -l -d

The log file output in /var/lib/check_mk_agent/log/mk_oracle.log should give a good indication of whats going on.

Also - are you monitoring a non-CDB database or CDB + PDB’s?