← Back to Journal

Nagios Oracle health plugin

Posted on 28 October 2011

This is more a memo than an article. A quick and dirty check_oracle_health plugin installation, with prerequires.

Developped by Gerhard Lausser, an active Shinken developper with Jean Gabès.

Like most of Nagios plugins, it’s in Perl language and it’s use DBD::Oracle module, and this module need an Oracle client.

Oracle Instant Client

You have to create a fucking Oracle account… Yes I know you think :

“What’s this great article ?! Proprietary software are just awesome!”.

Go to Oracle Instant Client Downloads Page. Get the Instant Client Package - Basic and sdk. Or use my personnal links above.

For the story, i have fucked my brain during three hours cause I have download the Instant Client Package - Basic Lite and try to work with a Western American charset database… And of course, Basic Lite does not support it.

Derp.

DBD::Oracle

Install pre-requires :

Get module sources.

DBD::Oracle module need path to Oracle Instant Client.

And compile it.

Tnsnames.ora

This file contain informations about your different databases.

This is and example of tnsnames.ora file :

check_oracle_health

To finish, we have to install the Nagios plugin.

That’s all !