Metricbeat error for pulling oracle database metrics with an oracle client

We are using the following software stack:-
Server : RHEL6 (It has oracle client installed. I tried with both full client and thin client)
beat : metricbeat-7.9.3-x86_64
database : Oracle 19 (not installed locally. RHEL6 can reach this server already as the application connects and works normally)

WHAT WORKS : Metricbeat is able to send the RHEL server (linux) metrics to Kibana and I am able to visualize the content.

WHAT DOES NOT WORKS : When i enable the "sql.yml" from the "modules" folder; then we immediately get the below error. This does not happen for RHEL7 and hence I wanted to know if there is a workaround for RHEL6?

ERROR:-

2021-10-13T15:17:42.566+0200 INFO module/wrapper.go:266 Error fetching data for metricset sql.query: error opening connection: testing connection: ORA-01804: Error while trying to retrieve text for error ORA-01804**strong text**

This says its INFO but it actually is an Error as metrics from oracle database does not get fetched.

Kindly advise.

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