Hello, I am using Oracle Linux 8.9 and have installed Oracle DB 19C.
I want to monitor the Oracle databases. 1) Usage of Tablespaces, 2) Usage of Archivelogs3) Number of sessions and processes, 4) Long-running queries, 5) SGA and PGA use, 6) Unusable indexes, 7) Deadlocks.
I tried configuring Prometheus and Grafana, as well as the node exporter and oracledb_exporter, but I can only see system logs, not database logs.
Can anyone assist with this?
also getting following error.
oracledb_exporter --default.metrics default-metrics.toml --log.level=debug
ts=2024-07-29T11:29:34.646Z caller=main.go:67 level=info msg=“FREE_INTERVAL end var is not present, will not periodically attempt to release memory”
ts=2024-07-29T11:29:34.646Z caller=main.go:74 level=info msg=“RESTART_INTERVAL env var is not present, so will not restart myself periodically”
ts=2024-07-29T11:29:34.646Z caller=collector.go:346 level=debug msg=“Launching connection to "
ts=2024-07-29T11:29:34.646Z caller=collector.go:351 level=debug msg=“connection properties: user= password=SECRET-*** connectString= configDir= connectionClass= enableEvents=0\nexternalAuth=0 heterogeneousPool=0 initOnNewConnection=0 libDir= noTimezoneCheck=0\npingInterval=0s poolIncrement=0 poolMaxSessions=0 poolMinSessions=0 poolSessionMaxLifetime=0s\npoolSessionTimeout=0s poolWaitTimeout=0s prelim=0 standaloneConnection=0 sysasm=0\nsysdba=0 sysoper=0 timezone=”
ts=2024-07-29T11:29:34.646Z caller=collector.go:358 level=debug msg=“disable go connection pooling, to allow use of oracle’s instead”
ts=2024-07-29T11:29:34.646Z caller=collector.go:362 level=debug msg=“Successfully configured connection to "
ts=2024-07-29T11:29:34.653Z caller=collector.go:263 level=debug msg=“error = dpoPool_create user= extAuth=0: ORA-24415: Missing or null username.”
ts=2024-07-29T11:29:34.654Z caller=collector.go:274 level=error msg=“Error pinging oracle” error=“dpoPool_create user= extAuth=0: ORA-24415: Missing or null username.”
ts=2024-07-29T11:29:34.654Z caller=main.go:101 level=info msg=“Starting oracledb_exporter” version=”(version=, branch=, revision=2536329eeb606209c0fcd0e9814ad985c761a4d4-modified)”
ts=2024-07-29T11:29:34.654Z caller=main.go:102 level=info msg=“Build context” build=“(go=go1.21.4, platform=linux/amd64, user=, date=, tags=unknown)”
ts=2024-07-29T11:29:34.654Z caller=main.go:103 level=info msg="Collect from: " metricPath=/metrics
ts=2024-07-29T11:29:34.654Z caller=tls_config.go:313 level=info msg=“Listening on” address=[::]:9161
ts=2024-07-29T11:29:34.654Z caller=tls_config.go:316 level=info msg=“TLS is disabled.” http2=false address=[::]:9161
ts=2024-07-29T11:29:43.866Z caller=collector.go:263 level=debug msg=“error = dpoPool_create user= extAuth=0: ORA-24415: Missing or null username.”
ts=2024-07-29T11:29:43.867Z caller=collector.go:274 level=error msg=“Error pinging oracle” error=“dpoPool_create user= extAuth=0: ORA-24415: Missing or null username.”