Oracle Integeration with elastic-agent

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:


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:

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.

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

1 Like