Exporter to monitor Oracle installed in AIX

[Nageswara Rao]

Hello All,

We could not find an exporter to monitor Oracle instance installed in AIX-7.2. Any help is much appreciated.

Thanks,

Nageswara Rao

[Christian Hoffmann]

Hi,

On 5/29/20 1:09 PM, Nageswara Rao wrote:
> We could not find an exporter to monitor Oracle instance installed in
> AIX-7.2. Any help is much appreciated.

My experience is that the resources regarding commercial UNIX support
such as AIX are rather sparse.

However, as you are talking about monitoring an application and not the
operating itself, you may have luck with existing resources.

You could try to run one of the existing oracle exporters on AIX:
https://github.com/iamseth/oracledb_exporter

Go is supported on AIX, but there does not seem to be support for cgo
yet. This may mean that the oracledb_exporter cannot be built as it
seems to load the oracle C library:
https://golang.org/doc/go1.12
https://github.com/mattn/go-oci8

It is usually recommended to run exporters as close to the monitored
subject as possible. However, in this case "as close as possible" might
mean: Run it on a linux box right next to the AIX oracle database. This
could work as the connection is most likely a standard TCP connection.

This has the downside of of being affected by disruptions between the
database and the exporter (e.g. network problems). However, this can
also be seen as a benefit (as compared with the blackbox_exporter): If
your database is used from the network, it makes sense to monitor it
from the network.

Hope this helps.

Christian