Metricbeat Oracle Module

I have enabled the Oracle Metricbeat module to monitor my database. The configuration file looks like this:

- module: oracle
  metricsets: ["tablespace", "performance"]
  enabled: true
  period: 10s
  hosts: ["oracle://@demo_high"]

  username: "admin"
  password: "passwordhere"

The module test also works fine like this:

metricbeat test modules
oracle...
  tablespace...OK
    result:
    {
     "@timestamp": "2021-08-30T13:29:20.005Z",
     "event": {
      "dataset": "oracle.tablespace",
      "duration": 4324824461,
      "module": "oracle"
     },
     "metricset": {
      "name": "tablespace",
      "period": 10000
     },
     "oracle": {
      "tablespace": {
       "data_file": {
        "id": 4055,
        "name": "+DATA/EET1POD/C9432FCC417B9DFDE0531918000A07C5/DATAFILE/sysaux.6548.1080280321",
        "online_status": "ONLINE",
        "size": {
         "bytes": 3596550144,
         "free": {
          "bytes": 3590225920
         },
         "max": {
          "bytes": 35184372064256
         }
        },
        "status": "AVAILABLE"
       },
       "name": "SYSAUX",
       "space": {
        "free": {
         "bytes": 888930304
        },
        "used": {
         "bytes": 3596550144
        }
       }
      }
     },
     "service": {
      "address": "oracle://demo_high",
      "type": "oracle"
     }
    }

  performance...OK
    result:
    {
     "@timestamp": "2021-08-30T13:29:24.330Z",
     "event": {
      "dataset": "oracle.performance",
      "duration": 747441149,
      "module": "oracle"
     },
     "metricset": {
      "name": "performance",
      "period": 10000
     },
     "oracle": {
      "performance": {
       "cursors": {
        "cache_hit": {
         "pct": 0.9712419975536389
        },
        "opened": {
         "current": 7,
         "total": 3356005
        },
        "parse": {
         "real": 2905094,
         "total": 354399
        },
        "session": {
         "cache_hits": 3259493
        }
       },
       "io_reloads": 0.0004195381221348515,
       "lock_requests": 0.7445759764903614,
       "pin_requests": 0.8144706295948042
      }
     },
     "service": {
      "address": "oracle://demo_high",
      "type": "oracle"
     }
    }

However, within Kibana this is the error message that I see:


error creating connection to Oracle: error doing ping to database: params=oracle://admin:SECRET-ClNpfq1ZGTA=@demo_high?connectionClass=GODROR&enableEvents=0&heterogeneousPool=0&poolIncrement=1&poolMaxSessions=1000&poolMinSessions=1&poolSessionMaxLifetime=1h0m0s&poolSessionTimeout=5m0s&poolWaitTimeout=30s&prelim=0&standaloneConnection=0&sysasm=0&sysdba=0&sysoper=0&timezone= extAuth=0: ORA-12154: TNS:could not resolve the connect identifier specified

Since I am using database as service the database server does not respond to the ping, and also the metricbeat configuration is done on a remote server.
Is there a way, i can bypass the ping test or something to enable the flow of metrics straight in Kibana.

Hi! Do you see this error message in Kibana? I don't think Kibana should care at all in this case. @Mario_Castro Do you know more about this?

@Kaiyan_Sheng Yes, the message is straight from the Kibana Discover.

Uploaded the screen shot, from Kibana

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.