Oracle agent runs fine but delivers no data

[khauser]

Hi,

I followed the documentation for oracle: https://docs.datadoghq.com/integrations/oracle/?tab=standalone using this ojdbc driver: https://download.oracle.com/otn-pub/otn_software/jdbc/ojdbc10-full.tar.gz with Oracle 19.3 on a vm (Oracle Linux 7) in Azure.

Datadog seems to run fine and with datadog-agent status i get

===============
Agent (v7.25.1)
===============

  Status date: 2021-02-04 15:06:21.558946 UTC
  Agent start: 2021-02-04 15:01:42.260203 UTC
  Pid: 19606
  Go Version: go1.14.12
  Python Version: 3.8.5
  Build arch: amd64
  Agent flavor: agent
  Check Runners: 4
  Log Level: info

  Paths
  =====
    Config File: /etc/datadog-agent/datadog.yaml
    conf.d: /etc/datadog-agent/conf.d
    checks.d: /etc/datadog-agent/checks.d

  Clocks
  ======
    NTP offset: -4.31ms
    System UTC time: 2021-02-04 15:06:21.558946 UTC

  Host Info
  =========
    bootTime: 2021-02-03 11:22:04.000000 UTC
    kernelArch: x86_64
    kernelVersion: 4.14.35-1902.10.7.el7uek.x86_64
    os: linux
    platform: oracle
    platformFamily: rhel
    platformVersion: 7.7
    procs: 399
    uptime: 27h39m40s
    virtualizationRole: host
    virtualizationSystem: kvm
...
oracle (3.1.0)
    --------------
      Instance ID: oracle:43a1f2ae9b1de3f2 [OK]
      Configuration Source: file:/etc/datadog-agent/conf.d/oracle.d/conf.yaml
      Total Runs: 19
      Metric Samples: Last Run: 0, Total: 0
      Events: Last Run: 0, Total: 0
      Service Checks: Last Run: 1, Total: 19
      Average Execution Time : 2ms
      Last Execution Date : 2021-02-04 15:06:14.000000 UTC
      Last Successful Execution Date : 2021-02-04 15:06:14.000000 UTC

But there are no "Metric Samples" as you can see and also datadog Oracle dashboard shows nothing.

I would expect to see metrics.

Thanks for help

[hithwen]

Hi @khauser, we're going to need more detailed information about your system to investigate what might be going on. Can you please contact support?

[khauser]

I found it in the datdog logs: No such file or directory: '/usr/lib/jvm'

So I installed JDK and all worked fine.