Any good step by step guide/ URL for using oracle_db exporter from scratch

[Faizan Malik]

Os: linux

Oracle 19c

to use: oracle_db exporter

Need to know any pre-requisites and how to fulfill those

[Brian Candler]

Do you mean this one? https://github.com/iamseth/oracledb_exporter

There seems to be pretty good documentation there.  Perhaps you could explain more clearly the problem you're having.  Are you running the docker version?  Or are you trying to compile it from source?  What error message do you see?

[Faizan Malik]

Hi Brian,

I am just trying various exporters to see how everything works (i am learning prometheus). I used windows_exporter and node_exporter they are pretty straightforward.

I just cant understand where the oracle_db exporter should be run (on all the oracle servers or on the prometheus server).

Same with docker version, do i need to run the docker container on prometheus server or on all the oracle servers.

i just have 1 oracle 19c installed on a centos vm in my lab which i am planning to monitor, I understand oracle client needs to be installed which i have done

On Tue, Aug 31, 2021 at 12:19 AM Brian Candler <b.ca...@pobox.com> wrote:

Do you mean this one? https://github.com/iamseth/oracledb_exporter

There seems to be pretty good documentation there.  Perhaps you could explain more clearly the problem you're having.  Are you running the docker version?  Or are you trying to compile it from source?  What error message do you see?

--
You received this message because you are subscribed to the Google Groups "Prometheus Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to prometheus-use...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/bde84b45-8083-47ad-80bf-49df097d2604n%40googlegroups.com.

[Brian Candler]

If it's anything like any normal exporter, then you can install it wherever you like, as long as there is network connectivity.

You could install it on the prometheus server, and configure the exporter to make outbound connections to your Oracle database(s) from there.  However if you have firewalls which prevent this, or the TNS listener config doesn't allow it, then you could install the exporter on your database server.  Or you could install it in a third location, such as in its own docker container.

In all cases, the connections go:  prometheus --> exporter --> target.  The connection from prometheus to exporter is called a "scrape" and is HTTP(S); you can use curl to test it out.  The connection from exporter to target will be the Oracle database protocol (OCI).

You might want to get yourself familiar first with another exporter which works in this way, such as blackbox_exporter (because sorting out problems with Oracle OCI client libraries can be a pain).