how to scrap metrics from multiple oracle instance

[balayogeeswar]

I'm submitting a feature request

How i can configure multiple database to scrap metrics, e..g i have db host 1, db host2 how i can monitor using single host.

[lucian-vanghele]

@iamseth, @Yannig is this exporter abandoned ?

[iamseth]

I haven't been paying attention to this project for a long time because I no longer work with Oracle or even Prometheus for that matter. I only built this to solve a particular problem I was having years ago. If someone wants to become a maintainer, I can transfer the repo or provide merge access.

Regarding multiple databases, why not just run multiple instances of this exporter? It's light enough that you can throw a dozen instances on a host pretty easily. A docker compose file can easily provision N number of instances each on a different port. I believe this is the standard way to handle Prometheus exporters against multiple hosts.

[balayogeeswar]

currently we are running multiple instances with comes with additional run cost, current utilization while scrapping is very less so i was asking if we have capability to scrap multiple instances of db from single instance would be great like how outcold solutions can scrap N no of instances at a time: https://www.outcoldsolutions.com/docs/monitoring-openshift/v5/prometheus/

[lucian-vanghele]

I haven't been paying attention to this project for a long time because I no longer work with Oracle or even Prometheus for that matter. I only built this to solve a particular problem I was having years ago. If someone wants to become a maintainer, I can transfer the repo or provide merge access.

Regarding multiple databases, why not just run multiple instances of this exporter? It's light enough that you can throw a dozen instances on a host pretty easily. A docker compose file can easily provision N number of instances each on a different port. I believe this is the standard way to handle Prometheus exporters against multiple hosts.

Oh, that's a pity. I hope someone will be interested in taking ownership of this project.

Running multiple instances of the exporter is not always possible/feasible (various reasons: port restrictions, deployment pipelines etc). So having this feature in the exporter can actually be really helpful.
On the other hand this is not the only function that was broken: multi-host DSN is also not working currently.