Issues with Default-metrics-toml queries - "no metrics found while parsing"

[kr2792]

Good day to you 👏

I've installed the oracledb_exporter version 0.3.0 as binary package. It's set up and shows some of the the metrics which prometheus then scrapes from.

There's some problems with a few queries in the default-metrics file.

• Error scraping for waittime map[value:Generic counter metric from v$waitclassmetric view in Oracle.] : No metrics found while parsing" source="main.go:266"

• Error scraping for size_user_segmentstop100 map[table_partition_bytes:Gauge metric with the size of the table partition in user segments.] : No metrics found while parsing" source="main.go:266"

• Error scraping for resource _ map[current_utilization:Generic counter metric from v$resource_limit view in Oracle (current value). limit_value:Generic counter metric from v$resource_limit view in Oracle (UNLIMITED: -1).] : No metrics found while parsing" source="main.go:266"

• Error scraping for waittime map[value:Generic counter metric from v$waitclassmetric view in Oracle.] : No metrics found while parsing" source="main.go:266"

• Error scraping for size_user_segmentstop100 map[cluster_bytes:Gauge metric with the size of the cluster in user segments.] : No metrics found while parsing" source="main.go:266

• Error scraping for size_user_segmentstop100 map[table_partition_bytes:Gauge metric with the size of the table partition in user segments.] : No metrics found while parsing" source="main.go:266"

• Error scraping for resource _ map[current_utilization:Generic counter metric from v$resource_limit view in Oracle (current value). limit_value:Generic counter metric from v$resource_limit view in Oracle (UNLIMITED: -1).] : No metrics found while parsing" source="main.go:266

• "Error scraping for size_user_segmentstop100 map[cluster_bytes:Gauge metric with the size of the cluster in user segments.] : No metrics found while parsing" source="main.go:266

• Error scraping for waittime map[value:Generic counter metric from v$waitclassmetric view in Oracle.] : No metrics found while parsing" source="main.go:266"

• Error scraping for size_user_segmentstop100 map[table_partition_bytes:Gauge metric with the size of the table partition in user segments.] : No metrics found while parsing" source="main.go:266

Is it a permissions issue at my hand or is something else?

Any help is appreciated. 👍

[Acsigen]

Please run your query with sqlplus(don't forget to add ; when doing it) and check if you get an error. I had this kind of issue when the label was not found because I had a typo in the query and no data was returned.