search

iamseth / oracledb_exporter

Prometheus Oracle database exporter.
MIT License
476 stars 237 forks source link

"unknown URL option: as" #392

Open MikhailVolosevitch opened 8 months ago

MikhailVolosevitch commented 8 months ago

I'm submitting a ...

What is the current behavior?

I set DATA_SOURCE_NAME="oracle://dbsnmp:dbsnmp@localhost:1521/+ASM?as=sysasm" then run /usr/local/bin/oracledb_exporter --default.metrics "/etc/oracledb_exporter/default-asm-metrics.toml" --log.level "debug" --web.listen-address 0.0.0.0:9163

Error in output

ts=2023-12-14T08:27:39.708Z caller=collector.go:327 level=debug launchingconnection:="@localhost:1521/+ASM?as=sysasm" ts=2023-12-14T08:27:39.708Z caller=collector.go:333 level=debug setmaxidleconnectionsto=0 ts=2023-12-14T08:27:39.708Z caller=collector.go:335 level=debug setmaxopenconnectionsto=10 ts=2023-12-14T08:27:39.708Z caller=collector.go:337 level=debug successfullyconnectedto:="@localhost:1521/+ASM?as=sysasm" ts=2023-12-14T08:27:39.708Z caller=collector.go:262 level=error errorpingingoracle:="unknown URL option: as"

If the current behavior is a bug, please provide the steps to reproduce and if possible a minimal demo of the problem

What is the expected behavior?

Scrape from asm data witout errors

What is the motivation / use case for changing the behavior?

Please tell us about your environment:

Oracledb_exporter Version: X.Y.Z oracle database 11.2.0.3

daiguadaidai commented 7 months ago

use sysdba, DATA_SOURCE_NAME add should be ?dba privilege=sysdba username: C##AABBCC export DATA_SOURCE_NAME="oracle://C%23%AABBCC:xxx@127.0.0.1:1521/orcl?dba privilege=sysdba"