Problem Description
After upgrading Nagios XI, Oracle based services start failing with errors similar to this:
The following error message is produced:
CRITICAL - cannot connect to fprnt. install_driver(Oracle) failed: Can't load '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libocci.so.12.1: cannot open shared object file: No such file or directory at /usr/lib64/perl5/DynaLoa
During the upgrade, the customized commands are overwritten with the default commands included with the wizard.
The old commands can be retrieved as they would have been kept in a backup.
If you did the upgrade via the XI web interface, the following file is created:
/store/backups/nagiosxi/autoupgrade_backup..tar.gz
Follow these steps in an SSH or console session on your Nagios XI host:
mkdir /tmp/restore/
cd /tmp/restore/
tar zxf /store/backups/nagiosxi/autoupgrade_backup..tar.gz -C /tmp/restore/
tar zxf /tmp/restore/autoupgrade_backup./nagios.tar.gz usr/local/nagios/etc/commands.cfg --strip-components 4
This last step will show you what the commands were defined as before the upgrade:
grep oracle /tmp/restore/commands.cfg
Using that information you will be able to go into CCM and update the commands accordingly following this original guide on page 2 and 3:
Documentation - How to Install & Configure the Oracle Client & Plugins
When you are done, delete the extracted files:
cd /tmp
rm -rf restore
For any support related questions please visit the Nagios Support Forums at:
http://support.nagios.com/forum/
Article ID: 209
Created On: Wed, Jan 27, 2016 at 10:09 PM
Last Updated On: Thu, Feb 18, 2016 at 12:45 AM
Authored by: tlea
Online URL: https://support.nagios.com/kb/article/nagios-xi-oracle-services-critical-after-nagios-xi-upgrade-209.html