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.