search

oracle / oracle-db-appdev-monitoring

Metrics exporter and samples for unified observability for data-centric app dev and microservices
http://developer.oracle.com/microservices
Other
78 stars 23 forks source link

how can I set the username and passwd in oracledb_exporter-1.5.0.linux-amd64 #143

Closed mayanshun closed 1 day ago

mayanshun commented 3 weeks ago

Now，as below [oracle@axxxxx ~]$ cd oracledb_exporter-1.5.0/ [oracle@xxxx oracledb_exporter-1.5.0]$ ls alert.log nohup.out oracledb_exporter [oracle@xxxxxx oracledb_exporter-1.5.0]$ tail nohup.out ts=2024-10-29T01:36:55.025Z caller=tls_config.go:313 level=info msg="Listening on" address=[::]:9161 ts=2024-10-29T01:36:55.025Z caller=tls_config.go:316 level=info msg="TLS is disabled." http2=false address=[::]:9161 ts=2024-10-29T01:37:10.040Z caller=alertlog.go:115 level=error msg="Error querying the alert logs" ts=2024-10-29T01:37:25.038Z caller=alertlog.go:115 level=error msg="Error querying the alert logs" ts=2024-10-29T01:37:40.028Z caller=alertlog.go:115 level=error msg="Error querying the alert logs" ts=2024-10-29T01:37:55.039Z caller=alertlog.go:31 level=info msg="Failed to query the alert log three consecutive times, so will not try any more" ts=2024-10-29T01:42:29.132Z caller=collector.go:287 level=error msg="Error pinging oracle" error="dpoPool_create user= extAuth=0: ORA-24415: Missing or null username." ts=2024-10-29T02:13:13.355Z caller=collector.go:287 level=error msg="Error pinging oracle" error="dpoPool_create user= extAuth=0: ORA-24415: Missing or null username." ts=2024-10-29T02:13:31.055Z caller=collector.go:287 level=error msg="Error pinging oracle" error="dpoPool_create user= extAuth=0: ORA-24415: Missing or null username." ts=2024-10-29T02:13:47.886Z caller=collector.go:287 level=error msg="Error pinging oracle" error="dpoPool_create user= extAuth=0: ORA-24415: Missing or null username."

[oracle@xxxxxx ~]$ netstat -tlnp | grep 9161 (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.) tcp 0 0 :::9161 :::* LISTEN 5634/./oracledb_exp [oracle@xxxxxx ~]$ cd oracledb_exporter-1.5.0/ [oracle@xxxxxx oracledb_exporter-1.5.0]$ ls -allh total 14M drwxr-xr-x 2 oracle oinstall 4.0K Oct 29 01:34 . drwx------ 14 oracle oinstall 4.0K Oct 29 02:13 .. -rw-r--r-- 1 oracle oinstall 0 Oct 29 01:34 alert.log -rw------- 1 oracle oinstall 16K Oct 29 02:13 nohup.out -rwxr-xr-x 1 oracle oinstall 14M Oct 29 01:34 oracledb_exporter [oracle@xxxxxxx oracledb_exporter-1.5.0]$ ps -ef | grep 5634 oracle 5634 1 0 01:36 ? 00:00:00 ./oracledb_exporter --log.destination=./alert.log oracle 56340 1 0 02:15 ? 00:00:00 oraclebosdb1 (LOCAL=NO) oracle 72632 71748 0 02:27 pts/6 00:00:00 grep 5634

markxnelson commented 3 weeks ago

Hi @mayanshun , I don't see the command you used to start the exporter, but have you checked the details of available parameters and variables here? https://github.com/oracle/oracle-db-appdev-monitoring?tab=readme-ov-file#standalone-binary

markxnelson commented 1 day ago

Closing this issue, assuming this fixed it for you. If you still have a problem, please feel free to reopen the issue. Thanks for you input!