# Oracle Driver on Metricbeat Pod

**URL:** <https://discuss.elastic.co/t/oracle-driver-on-metricbeat-pod/263786>\
**Category:** Beats\
**Created:** [February 9, 2021, 5:25pm UTC](https://discuss.elastic.co/t/oracle-driver-on-metricbeat-pod/263786 "2021-02-09T17:25:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ssurenr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ssurenr/32/72641_2.png) [@ssurenr](https://discuss.elastic.co/u/ssurenr)\
**Post date:** [February 9, 2021, 5:25pm UTC](https://discuss.elastic.co/t/oracle-driver-on-metricbeat-pod/263786/1 "2021-02-09T17:25:46Z")

</div>

Hi,  
I am trying to collect metrics from an Oracle Database Query. I am getting the following error upon configuring the 'query' metricset from sql module.

```
 2021-02-09T16:57:35.337Z INFO module/wrapper.go:266 Error fetching data for metricset 
sql.query: error opening connection: testing connection: ORA-00000: DPI-1047: Cannot locate a 64-bit
Oracle Client library: "libclntsh.so: cannot open shared object file: No such file or directory". See 
https://oracle.github.io/odpi/doc/installation.html#linux for help

```

Following is my config.

```auto
        - module: sql
          metricsets:
            - query
          period: 5m
          hosts: ["oracle://${RO_USER}:${RO_PASSWORD}@${DB_HOST}:1531/${DB_NAME}?${DB_SCHEMA}=1"]
          driver: "oracle"
          sql_query: "${METRICS_QUERY}"
          sql_response_format: table

```

Are you shipping oracle driver in Metricbeat container image? If not, what would be the best solution to this problem?

Also the log should be an ERROR log rather than an INFO log.

Thank you.

---

<div class="post-metadata">

**Author:** ![charith-elastic](https://avatars.discourse-cdn.com/v4/letter/c/3ec8ea/32.png) [@charith-elastic](https://discuss.elastic.co/u/charith-elastic)\
**Post date:** [February 10, 2021, 9:56am UTC](https://discuss.elastic.co/t/oracle-driver-on-metricbeat-pod/263786/2 "2021-02-10T09:56:59Z")

</div>

I am moving this thread to the Beats forum where you are more likely to find help on this topic.

---

<div class="post-metadata">

**Author:** ![ssurenr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ssurenr/32/72641_2.png) [@ssurenr](https://discuss.elastic.co/u/ssurenr)\
**Post date:** [February 10, 2021, 2:08pm UTC](https://discuss.elastic.co/t/oracle-driver-on-metricbeat-pod/263786/3 "2021-02-10T14:08:15Z")

</div>

Hi @charith-elastic Thanks for looking. I am using a Metricbeat CRD in kubernetes. The problem is that the metricbeat container not having proper driver library for connecting to Oracle instance. Do you think it is appropriate for Beats channel rather than ECK?

---

<div class="post-metadata">

**Author:** ![charith-elastic](https://avatars.discourse-cdn.com/v4/letter/c/3ec8ea/32.png) [@charith-elastic](https://discuss.elastic.co/u/charith-elastic)\
**Post date:** [February 10, 2021, 3:40pm UTC](https://discuss.elastic.co/t/oracle-driver-on-metricbeat-pod/263786/4 "2021-02-10T15:40:21Z")

</div>

It is not specific to ECK because ECK simply uses the official container images for Beats. I very much doubt that a third-party library like the Oracle driver will be included with the container images and want to see how Beats experts would handle that case on any containerised deployment. You also mentioned a possible mis-categorisation of the log message -- which is something for the Beats team to evaluate as well.

---

<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:** [March 10, 2021, 5:40pm UTC](https://discuss.elastic.co/t/oracle-driver-on-metricbeat-pod/263786/5 "2021-03-10T17:40:39Z")

</div>

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