Hi,
I am trying to collect metrics from an Oracle Database Query. I am getting the following error upon configuring the 'query' metricset from sql module.
2021-02-09T16:57:35.337Z INFO module/wrapper.go:266 Error fetching data for metricset
sql.query: error opening 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 for help
Following is my config.
- module: sql
metricsets:
- query
period: 5m
hosts: [ "oracle://${RO_USER}:${RO_PASSWORD}@${DB_HOST}:1531/${DB_NAME}?${DB_SCHEMA}=1" ]
driver: "oracle"
sql_query: "${METRICS_QUERY}"
sql_response_format: table
Are you shipping oracle driver in Metricbeat container image? If not, what would be the best solution to this problem?
Also the log should be an ERROR log rather than an INFO log.
Thank you.