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 !