# Metricbeat Oracle Module

**URL:** <https://discuss.elastic.co/t/metricbeat-oracle-module/282822>\
**Category:** Beats\
**Tags:** beats-module, metricbeat\
**Created:** [August 30, 2021, 1:44pm UTC](https://discuss.elastic.co/t/metricbeat-oracle-module/282822 "2021-08-30T13:44:01Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![nafey1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nafey1/32/93890_2.png) [@nafey1](https://discuss.elastic.co/u/nafey1)\
**Post date:** [August 30, 2021, 1:44pm UTC](https://discuss.elastic.co/t/metricbeat-oracle-module/282822/1 "2021-08-30T13:44:01Z")

</div>

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

```auto
- 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:

```auto
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:

```auto

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.

---

<div class="post-metadata">

**Author:** ![Kaiyan\_Sheng](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kaiyan_sheng/32/38247_2.png) [@Kaiyan\_Sheng](https://discuss.elastic.co/u/Kaiyan_Sheng)\
**Post date:** [August 30, 2021, 8:13pm UTC](https://discuss.elastic.co/t/metricbeat-oracle-module/282822/2 "2021-08-30T20:13:23Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![nafey1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nafey1/32/93890_2.png) [@nafey1](https://discuss.elastic.co/u/nafey1)\
**Post date:** [August 30, 2021, 8:43pm UTC](https://discuss.elastic.co/t/metricbeat-oracle-module/282822/3 "2021-08-30T20:43:07Z")

</div>

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

 ![Screen Shot 2021-08-30 at 4.42.22 PM](https://us1.discourse-cdn.com/elastic/original/3X/6/6/660b2be2488dc3ad945fd30d2cfcc53622eba91c.png)

Uploaded the screen shot, from Kibana

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [September 27, 2021, 10:44pm UTC](https://discuss.elastic.co/t/metricbeat-oracle-module/282822/4 "2021-09-27T22:44:05Z")

</div>

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