oracledb_exporter get error="dpoPool_create user= extAuth=0: ORA-24415: Missing or null username."

[zhituanchen]

Hi:
I using oracledb_exporter to start. Get error error="dpoPool_create user= extAuth=0: ORA-24415: Missing or null username.".The OS user is oracle
DB_USERNAME=oracledb_exporter
DB_PASSWORD=p2k6hiiRK
DB_CONNECT_STRING=emcc
/mysqlbackup/recovery/oracle/monitor/oracledb_exporter --default.metrics "/mysqlbackup/recovery/oracle/monitor/default-metrics.toml" --log.level=info --web.listen-address=0.0.0.0:9161 --log.destination="/var/log/alert.log"
ts=2024-07-02T02:42:45.343Z caller=main.go:72 level=info msg="FREE_INTERVAL end var is not present, will not periodically attempt to release memory"
ts=2024-07-02T02:42:45.343Z caller=main.go:79 level=info msg="RESTART_INTERVAL env var is not present, so will not restart myself periodically"
ts=2024-07-02T02:42:45.358Z caller=collector.go:391 level=info msg="Could not set CLIENT_INFO."
ts=2024-07-02T02:42:45.358Z caller=collector.go:396 level=info msg="dbtype err =dpoPool_create user= extAuth=0: ORA-24415: Missing or null username."
ts=2024-07-02T02:42:45.359Z caller=collector.go:402 level=info msg="got error checking my database role"
ts=2024-07-02T02:42:45.359Z caller=collector.go:404 level=info msg="Connected as SYSDBA? "
ts=2024-07-02T02:42:45.360Z caller=collector.go:283 level=error msg="Error pinging oracle" error="dpoPool_create user= extAuth=0: ORA-24415: Missing or null username."
ts=2024-07-02T02:42:45.360Z caller=main.go:107 level=info msg="Starting oracledb_exporter" version=1.3.0
ts=2024-07-02T02:42:45.360Z caller=main.go:108 level=info msg="Build context" build="(go=go1.22.4, platform=linux/amd64, user=, date=, tags=unknown)"
ts=2024-07-02T02:42:45.360Z caller=main.go:109 level=info msg="Collect from: " metricPath=/metrics
ts=2024-07-02T02:42:45.360Z caller=main.go:159 level=info msg="Exporting alert logs to /var/log/alert.log"
ts=2024-07-02T02:42:45.361Z caller=tls_config.go:313 level=info msg="Listening on" address=[::]:9161
ts=2024-07-02T02:42:45.361Z caller=tls_config.go:316 level=info msg="TLS is disabled." http2=false address=[::]:9161
ts=2024-07-02T02:42:50.357Z caller=collector.go:283 level=error msg="Error pinging oracle" error="dpoPool_create user= extAuth=0: ORA-24415: Missing or null username."
ts=2024-07-02T02:43:00.369Z caller=alertlog.go:103 level=error msg="Error querying the alert logs"
ts=2024-07-02T02:43:05.356Z caller=collector.go:283 level=error msg="Error pinging oracle" error="dpoPool_create user= extAuth=0: ORA-24415: Missing or null username."
ts=2024-07-02T02:43:15.368Z caller=alertlog.go:103 level=error msg="Error querying the alert logs"
ts=2024-07-02T02:43:20.357Z caller=collector.go:283 level=error msg="Error pinging oracle" error="dpoPool_create user= extAuth=0: ORA-24415: Missing or null username."

[votebmyla]

Looks like, oracledb_exporter is not able to connect to the database.
DB_CONNECT_STRING in my case in format 192.168.100.200:1521/service

[zhituanchen]

OK