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.