level=error errorpingingoracle:="missing port in address"

[enbingzhou]

Please tell us about your environment:

Version:0.5.2
hello,Could you help me to analyze the error with why we have this error with 'level=error errorpingingoracle:="missing port in address"'?

[oracle@cluster01:/tmp/oracledb_exporter]$ sqlplus system/EDCwsx#[email protected]:1522/testdb

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 5 00:05:06 2025
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Last Successful login time: Wed Feb 05 2025 00:05:02 +08:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@cluster01:/tmp/oracledb_exporter]$ export DATA_SOURCE_NAME="system/EDCwsx#123@//172.27.244.2:1522/testdb"
[oracle@cluster01:/tmp/oracledb_exporter]$ ./oracledb_exporter
ts=2025-02-04T16:05:27.090Z caller=default_metrics.go:81 level=error therewasanissuewhileloadingspecifieddefaultmetricsfileat:default-metrics.toml,proceedingtorunwithdefaultmetrics.="open default-metrics.toml: no such file or directory"
ts=2025-02-04T16:05:27.090Z caller=collector.go:262 level=error errorpingingoracle:="missing port in address"
ts=2025-02-04T16:05:27.090Z caller=main.go:91 level=info msg="Starting oracledb_exporter" version="(version=, branch=, revision=88271108e9c355d949fa1282c0e340f9220a02f8)"
ts=2025-02-04T16:05:27.090Z caller=main.go:92 level=info msg="Build context" build="(go=go1.19.4, platform=linux/amd64, user=, date=, tags=unknown)"
ts=2025-02-04T16:05:27.090Z caller=main.go:93 level=info msg="Collect from: " metricPath=/metrics
ts=2025-02-04T16:05:27.090Z caller=tls_config.go:313 level=info msg="Listening on" address=[::]:9161
ts=2025-02-04T16:05:27.090Z caller=tls_config.go:316 level=info msg="TLS is disabled." http2=false address=[::]:9161
^C
[oracle@cluster01:/tmp/oracledb_exporter]$ ./oracledb_exporter --database.dsn="system/EDCwsx#123@//172.27.244.2:1522/testdb" --log.level=debug
ts=2025-02-04T16:05:55.464Z caller=default_metrics.go:81 level=error therewasanissuewhileloadingspecifieddefaultmetricsfileat:default-metrics.toml,proceedingtorunwithdefaultmetrics.="open default-metrics.toml: no such file or directory"
ts=2025-02-04T16:05:55.464Z caller=collector.go:327 level=debug launchingconnection:=@//172.27.244.2:1522/testdb
ts=2025-02-04T16:05:55.464Z caller=collector.go:333 level=debug setmaxidleconnectionsto=0
ts=2025-02-04T16:05:55.464Z caller=collector.go:335 level=debug setmaxopenconnectionsto=10
ts=2025-02-04T16:05:55.464Z caller=collector.go:337 level=debug successfullyconnectedto:=@//172.27.244.2:1522/testdb
ts=2025-02-04T16:05:55.464Z caller=collector.go:262 level=error errorpingingoracle:="missing port in address"
ts=2025-02-04T16:05:55.464Z caller=main.go:91 level=info msg="Starting oracledb_exporter" version="(version=, branch=, revision=88271108e9c355d949fa1282c0e340f9220a02f8)"
ts=2025-02-04T16:05:55.464Z caller=main.go:92 level=info msg="Build context" build="(go=go1.19.4, platform=linux/amd64, user=, date=, tags=unknown)"
ts=2025-02-04T16:05:55.464Z caller=main.go:93 level=info msg="Collect from: " metricPath=/metrics
ts=2025-02-04T16:05:55.465Z caller=tls_config.go:313 level=info msg="Listening on" address=[::]:9161
ts=2025-02-04T16:05:55.465Z caller=tls_config.go:316 level=info msg="TLS is disabled." http2=false address=[::]:9161
^C
[oracle@cluster01:/tmp/oracledb_exporter]$ ./oracledb_exporter --database.dsn="oracle://system/EDCwsx#[email protected]:1522/testdb" --log.level=debug
ts=2025-02-04T16:09:08.520Z caller=default_metrics.go:81 level=error therewasanissuewhileloadingspecifieddefaultmetricsfileat:default-metrics.toml,proceedingtorunwithdefaultmetrics.="open default-metrics.toml: no such file or directory"
ts=2025-02-04T16:09:08.520Z caller=collector.go:327 level=debug launchingconnection:=@172.27.244.2:1522/testdb
ts=2025-02-04T16:09:08.520Z caller=collector.go:333 level=debug setmaxidleconnectionsto=0
ts=2025-02-04T16:09:08.520Z caller=collector.go:335 level=debug setmaxopenconnectionsto=10
ts=2025-02-04T16:09:08.520Z caller=collector.go:337 level=debug successfullyconnectedto:=@172.27.244.2:1522/testdb
ts=2025-02-04T16:09:08.520Z caller=collector.go:262 level=error errorpingingoracle:="address system: missing port in address"
ts=2025-02-04T16:09:08.520Z caller=main.go:91 level=info msg="Starting oracledb_exporter" version="(version=, branch=, revision=88271108e9c355d949fa1282c0e340f9220a02f8)"
ts=2025-02-04T16:09:08.520Z caller=main.go:92 level=info msg="Build context" build="(go=go1.19.4, platform=linux/amd64, user=, date=, tags=unknown)"
ts=2025-02-04T16:09:08.520Z caller=main.go:93 level=info msg="Collect from: " metricPath=/metrics
ts=2025-02-04T16:09:08.521Z caller=tls_config.go:313 level=info msg="Listening on" address=[::]:9161
ts=2025-02-04T16:09:08.521Z caller=tls_config.go:316 level=info msg="TLS is disabled." http2=false address=[::]:9161

[enbingzhou]

When I press F5 to flush my web ，Oracledb_exporter output "missing port in address"
log_detail:

=2025-02-04T16:15:43.738Z caller=collector.go:327 level=debug launchingconnection:=@//172.27.244.2:1522/testdb
ts=2025-02-04T16:15:43.738Z caller=collector.go:333 level=debug setmaxidleconnectionsto=0
ts=2025-02-04T16:15:43.738Z caller=collector.go:335 level=debug setmaxopenconnectionsto=10
ts=2025-02-04T16:15:43.738Z caller=collector.go:337 level=debug successfullyconnectedto:=@//172.27.244.2:1522/testdb
ts=2025-02-04T16:15:43.738Z caller=collector.go:262 level=error errorpingingoracle:="missing port in address"
ts=2025-02-04T16:15:43.738Z caller=main.go:91 level=info msg="Starting oracledb_exporter" version="(version=, branch=, revision=88271108e9c355d949fa1282c0e340f9220a02f8)"
ts=2025-02-04T16:15:43.738Z caller=main.go:92 level=info msg="Build context" build="(go=go1.19.4, platform=linux/amd64, user=, date=, tags=unknown)"
ts=2025-02-04T16:15:43.738Z caller=main.go:93 level=info msg="Collect from: " metricPath=/metrics
ts=2025-02-04T16:15:43.739Z caller=tls_config.go:313 level=info msg="Listening on" address=[::]:9161
ts=2025-02-04T16:15:43.739Z caller=tls_config.go:316 level=info msg="TLS is disabled." http2=false address=[::]:9161
ts=2025-02-04T16:15:52.493Z caller=collector.go:262 level=error errorpingingoracle:="missing port in address"
ts=2025-02-04T16:15:57.934Z caller=collector.go:262 level=error errorpingingoracle:="missing port in address"
ts=2025-02-04T16:15:58.460Z caller=collector.go:262 level=error errorpingingoracle:="missing port in address"
ts=2025-02-04T16:15:58.785Z caller=collector.go:262 level=error errorpingingoracle:="missing port in address"
ts=2025-02-04T16:15:59.030Z caller=collector.go:262 level=error errorpingingoracle:="missing port in address"
ts=2025-02-04T16:15:59.263Z caller=collector.go:262 level=error errorpingingoracle:="missing port in address"
ts=2025-02-04T16:15:59.500Z caller=collector.go:262 level=error errorpingingoracle:="missing port in address"
ts=2025-02-04T16:15:59.744Z caller=collector.go:262 level=error errorpingingoracle:="missing port in address"