Metricbeat: Sql Module: Oracle Driver: Sql Query Error :ERROR error opening connection: opening connection: sql: unknown driver "oracle" (forgotten import?)

Sunil18 · October 27, 2020, 5:52am

I have configured Metricbeat Oracle Module(For Default Metrices/Dashboard ) & I am using Sql Module for customized queries to fetch the data from Oracle DB.

Oracle Module is working perfectly but for Sql module I am getting below error.

metricbeat test modules sql
sql...
query...
error... ERROR error opening connection: opening connection: sql: unknown driver "oracle" (forgotten import?)

Mario_Castro · October 29, 2020, 2:42pm

Which version of Beats are you using? This issue was solved in this PR https://github.com/elastic/beats/pull/17378

As a workaround, you can try using the driver name godror

Sunil18 · October 30, 2020, 6:09am

Hello Mario,

Thanks for you reply..!!

I am using metricbeat version 7.7.1
metricbeat version
metricbeat version 7.7.1 (amd64), libbeat 7.7.1 [932b273e8940575e15f10390882be205bad29e1f built 2020-05-28 15:27:59.

By using godror driver I am able to fetch the data from oracle database.

Thanks a lot..!!

Mario_Castro · October 30, 2020, 10:29am

Hi @Sunil18

Yeah, if I recall correctly, this was fixed for 7.8 if you want to upgrade your Beats. I'm glad that I helped

Sunil18 · October 30, 2020, 11:13am

Hello Mario,

Yes, Sure I will upgrade it to the latest one.

thanks again

system · November 27, 2020, 1:13pm

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