0.3.2 release Query

[manjukashyap]

ISSUE:

The older version of oracledb_exporter crashes frequently.

Workaround:

Tried to build [0.3.2] from source and unable to proceed further because of various packages dependencies

cannot find package "github.com/cespare/xxhash/v2 github.com/matttproud/golang_protobuf_extensions/pbutil google.golang.org/protobuf/encoding/prototext

etc

This is tedious to keep cloning each dependency manually. Could you please provide the latest packaged x86*64 tar file for 0.3.2 release . Any help on this is really appreciated.

Thanks, Kashyap.

[manjukashyap]

Hi,

Any assistance on this ask. This is really blocking us.

[manjukashyap]

@Yannig @iamseth : Can you please help on this?

[HansK-p]

It is fairly easy to:

• Clone the repo
• Checkout v.0.3.2
• build the Ubuntu docker image (make ubuntu-image)
• Start the docker image
• Copy the binary and default config from the running docker image

I had to abort my mission as I was to run on a machine that didn't support instantclient 19.x (libc dependency issue), but except for this blocker it seemed to work well.

[manjukashyap]

Thanks @HansK-p , I was able to perform the steps provided for 0.3.2, Yet i see the below error. The service crashes after a brief period of activity.

Mar 18 10:58:12 localdb systemd[1]: oracledb_exporter.service: main process exited, code=killed, status=11/SEGV Mar 18 10:58:12 localdb systemd[1]: Unit oracledb_exporter.service entered failed state. Mar 18 10:58:12 localdb systemd[1]: oracledb_exporter.service failed.

[manjukashyap]

An Update, Tried with 19.14 oracle client and i see only the below gauges, Used oracle linux image during for the docker image.

Help pls

@iamseth @Yannig @HansK-p

[HansK-p]

I can't help you a lot. What we are doing right now:

• We have built a custom version of the oracledb_exporter Docker image based on a PR (but it is in essence equal to the v0.3.2 release
• We run the Docker image in Kubernetes - one deployment for each database we monitor
• We have configured some very simple custom metrics as described in the Custom Metrics doc (https://github.com/iamseth/oracledb_exporter)

We give oracledb_exporter exactly the Oracle permissions needed. Check application/docker logs to find out what permissions are lacking for the user used to scrape the Oracle database (my guess would be that that user account is lacking permissions on the database).

I do not have the list of grants in front of me, but I'd assue those found in https://github.com/iamseth/oracledb_exporter/issues/216 should be a good starting point - if permissions is the problem.