oracledb_exporter icon indicating copy to clipboard operation
oracledb_exporter copied to clipboard

"unknown URL option: as"

Open MikhailVolosevitch opened this issue 1 year ago • 1 comments

I'm submitting a ...

  • [x] bug report
  • [ ] feature request

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

MikhailVolosevitch avatar Dec 14 '23 08:12 MikhailVolosevitch

use sysdba, DATA_SOURCE_NAME add should be ?dba privilege=sysdba username: C##AABBCC export DATA_SOURCE_NAME="oracle://C%23%AABBCC:[email protected]:1521/orcl?dba privilege=sysdba"

daiguadaidai avatar Jan 19 '24 05:01 daiguadaidai