Server cannot see data collected by oracle plug in

Hallo

I installed oracle plugin on a database server following guide
https://checkmk.com/cms_monitoring_oracle.html

after that everything is ok when I chek from database server by running
check_mk_agent
or
/usr/lib/check_mk_agent/plugins/mk_oracle

but from checkmk gui, no way after discovery to get oracle database information
all services about CPU, Filesystem and so on are ok, but I can’t see any oracle service

I already tried to remove the host and create it again, but nothing change

Could someone help me understandin where I’m wrong ?

If you see the expected output locally then do the following from the monitoring system.
As site user “cmk -d hostname” now you should see the same output as your local check.
If not the problem lies on the server with the agent.

as site user
cmk -d hostname
gives me empty output for all hostname but windows machines

If you do this command on your monitoring server you must see the agent output.
If not, do you use a distributed monitoring?

A little bit of output would be good to say something about your problems. Without any information it is more like, find the needle in the haystack.

1 Like

Of course I can show output from oracle server host and from monitoring server (just one monitoring server)

*) On Oracle Server
[root@oracle ~]# check_mk_agent | head -20
<<<check_mk>>>
Version: 1.6.0p14
AgentOS: linux
Hostname: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
AgentDirectory: /etc/check_mk
DataDirectory: /var/lib/check_mk_agent
SpoolDirectory: /var/lib/check_mk_agent/spool
PluginsDirectory: /usr/lib/check_mk_agent/plugins
LocalDirectory: /usr/lib/check_mk_agent/local
<<>>
/dev/mapper/vg_oracle-lv_root ext4 51475068 2674012 46179616 6% /
tmpfs tmpfs 2996548 0 2996548 0% /dev/shm
/dev/sda1 ext4 487652 26029 436023 6% /boot
/dev/mapper/vg_oracle-lv_home ext4 47031232 29412596 15222888 66% /home
/dev/mapper/oradata-ora ext4 361112164 199912468 142849616 59% /opt
<<>>
[df_inodes_start]
/dev/mapper/vg_oracle-lv_root ext4 3276800 63735 3213065 2% /
tmpfs tmpfs 749137 1 749136 1% /dev/shm
/dev/sda1 ext4 128016 38 127978 1% /boot

[root@oracle ~]# check_mk_agent | tail
INSTANCENAME|EXFSYS|RLM$SCHDNEGACTION|SCHEDULED|0|28383|TRUE|16-SEP-20 11.24.19.000000 AM +02:00|-|SUCCEEDED
INSTANCENAME|SYS|PURGE_LOG|SCHEDULED|0|1144|TRUE|17-SEP-20 03.00.00.500000 AM EUROPE/VIENNA|DAILY_PURGE_SCHEDULE|SUCCEEDED
INSTANCENAME|SYS|AUTO_SPACE_ADVISOR_JOB|SCHEDULED|688|957|TRUE|01-JAN-70 12.00.00.000000 AM +02:00|MAINTENANCE_WINDOW_GROUP|SUCCEEDED
INSTANCENAME|EXFSYS|RLM$EVTCLEANUP|SCHEDULED|0|27254|TRUE|16-SEP-20 12.10.25.600000 PM +02:00|-|SUCCEEDED
INSTANCENAME|SYS|GATHER_STATS_JOB|SCHEDULED|196|957|TRUE|01-JAN-70 12.00.00.000000 AM +02:00|MAINTENANCE_WINDOW_GROUP|SUCCEEDED
INSTANCENAME|SYS|FGR$AUTOPURGE_JOB|DISABLED||0|FALSE|01-JAN-70 12.00.00.000000 AM +02:00|-|
<<<oracle_ts_quotas:sep(124)>>>
INSTANCENAME|||
<<<oracle_resumable:sep(124)>>>
INSTANCENAME|||||||||

*) On Monitoring Server
OMD[Username]:~$ cmk -d oraclehostname
OMD[Username]:~$

and when I go to checkmk server url and list services for oracle server I can see everything but oracle services

What do you get with “cmk -D oraclehostname”?
With your output you have not configured this host for agent access.

cmk -D oracledr

oraclehostname
Addresses: xxx.xxx.xxx.xxx
Tags: [address_family:ip-v4-only], [agent:no-agent], [criticality:prod], [ip-v4:ip-v4], [networking:lan], [piggyback:auto-piggyback], [site:sitename], [snmp:snmp], [snmp_ds:snmp-v2]
Labels:
Host groups: ORACLE
Contact groups: all, check-mk-notify
Agent mode: No agent
Type of agent:
SNMP (Community: ‘public’, Bulk walk: yes, Port: 161, Inline: no)
Process piggyback data from /omd/sites/Username/tmp/check_mk/piggyback/oraclehostname
Services:
checktype item params description groups


ucd_cpu_load None (5.0, 10.0) CPU load CPU
hr_cpu None {‘util’: (80.0, 90.0)} CPU utilization CPU
hr_fs / {‘trend_range’: 24, ‘show_levels’: ‘onmagic’, ‘inodes_levels’: (10.0, 5.0), ‘magic_normsize’: 20, ‘show_inodes’: ‘onlow’, ‘levels’: (80.0, 90.0), ‘show_reserved’: False, ‘levels_low’: (50.0, 60.0), ‘trend_perfdata’: True} Filesystem / FILESYSTEM
hr_fs /boot {‘trend_range’: 24, ‘show_levels’: ‘onmagic’, ‘inodes_levels’: (10.0, 5.0), ‘magic_normsize’: 20, ‘show_inodes’: ‘onlow’, ‘levels’: (80.0, 90.0), ‘show_reserved’: False, ‘levels_low’: (50.0, 60.0), ‘trend_perfdata’: True} Filesystem /boot FILESYSTEM
hr_fs /dev/shm {‘trend_range’: 24, ‘show_levels’: ‘onmagic’, ‘inodes_levels’: (10.0, 5.0), ‘magic_normsize’: 20, ‘show_inodes’: ‘onlow’, ‘levels’: (80.0, 90.0), ‘show_reserved’: False, ‘levels_low’: (50.0, 60.0), ‘trend_perfdata’: True} Filesystem /dev/shm FILESYSTEM
hr_fs /home {‘trend_range’: 24, ‘show_levels’: ‘onmagic’, ‘inodes_levels’: (10.0, 5.0), ‘magic_normsize’: 20, ‘show_inodes’: ‘onlow’, ‘levels’: (80.0, 90.0), ‘show_reserved’: False, ‘levels_low’: (50.0, 60.0), ‘trend_perfdata’: True} Filesystem /home FILESYSTEM
hr_fs /opt {‘trend_range’: 24, ‘show_levels’: ‘onmagic’, ‘inodes_levels’: (10.0, 5.0), ‘magic_normsize’: 20, ‘show_inodes’: ‘onlow’, ‘levels’: (80.0, 90.0), ‘show_reserved’: False, ‘levels_low’: (50.0, 60.0), ‘trend_perfdata’: True} Filesystem /opt FILESYSTEM
if64 2 {‘state’: [u’1’], ‘errors’: (0.01, 0.1), ‘speed’: 1000000000} Interface 2
hr_mem None (150.0, 200.0) Memory used
snmp_info None None SNMP Info
snmp_uptime None {}

Can you see the problem this is no agent host. You query this server with SNMP what is a generally bad idea.

1 Like