# Oracle Integeration with elastic-agent

**URL:** <https://discuss.elastic.co/t/oracle-integeration-with-elastic-agent/365384>\
**Category:** Elastic Agent\
**Created:** [August 22, 2024, 12:53pm UTC](https://discuss.elastic.co/t/oracle-integeration-with-elastic-agent/365384 "2024-08-22T12:53:59Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Zaryab\_Shaikh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zaryab_shaikh/32/136987_2.png) [@Zaryab\_Shaikh](https://discuss.elastic.co/u/Zaryab_Shaikh)\
**Post date:** [August 22, 2024, 12:53pm UTC](https://discuss.elastic.co/t/oracle-integeration-with-elastic-agent/365384/1 "2024-08-22T12:53:59Z")

</div>

Hello Community,

I am trying to enable Oracle integration through the Fleet section. I have an Oracle EBS setup with the following configuration:

- OS: Red Hat Enterprise Linux
- OS Version: 7.6
- DB: 19.11.0.0.0
- EBS: R12.2.9

My agent has successfully enrolled, but upon enabling the integration, I encounter an error prompting me to define a variable for the library name "libclntsh.so." I have already set the environment variable as follows:

```auto

export $LD_LIBRARY_PATH=/path/to/libclntsh.so

```

Additionally, since my Elastic Agent is running as a service in systemd, I edited the service configuration:

```auto
sudo systemctl edit --full elastic-agent.service
Environment="LD_LIBRARY_PATH=/path/to/libclntsh.so"
sudo systemctl restart elastic-agent.service

```

However, my agent still returns the following log in discovery section:

`Error fetching data for metricset sql.query: cannot open 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](https://see more) for help.`

Can anyone who has done this before help me out?

**Elasticsearch:** 8.15  
**Kibana:** 8.15  
**Elastic-Agent:** 8.15

Thanks.

---

<div class="post-metadata">

**Author:** ![Zaryab\_Shaikh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zaryab_shaikh/32/136987_2.png) [@Zaryab\_Shaikh](https://discuss.elastic.co/u/Zaryab_Shaikh)\
**Post date:** [September 5, 2024, 1:40pm UTC](https://discuss.elastic.co/t/oracle-integeration-with-elastic-agent/365384/2 "2024-09-05T13:40:20Z")

</div>

Issue resolved—it was related to the path. I needed to provide the path to the existing library directory, not the specific file.