Home » Categories » Multiple Categories

Nagios XI - Oracle Services Critical After Nagios XI Upgrade

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    

 

Explanation

During the upgrade, the customized commands are overwritten with the default commands included with the wizard.

 

Resolving The Problem

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


 

Final Thoughts

For any support related questions please visit the Nagios Support Forums at:

http://support.nagios.com/forum/

3 (2)
Article Rating (2 Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Nagios XI - How to Monitor an AKCP SensorProbe2 using SNMP
Viewed 698 times since Thu, Jan 28, 2016
Nagios XI - Monitoring A MySQL Server
Viewed 783 times since Wed, Jul 19, 2017
Nagios XI - Missing localhost Alerts
Viewed 1004 times since Sun, Nov 5, 2017
Nagios Log Server - Monitoring Using NCPA + Nagios XI
Viewed 32 times since Mon, Sep 16, 2019
Nagios XI - Issues with mod_gearman and Performance Data Newlines: "\n"
Viewed 450 times since Tue, Feb 2, 2016
Nagios XI - Empty Screen for Wizard, Component, Dashlet
Viewed 668 times since Wed, Jan 27, 2016
Nagios XI - Notification Problems
Viewed 2718 times since Tue, Jan 27, 2015
Nagios XI - Bandwidth Graphs Showing 0Mb/s in Non-English Systems
Viewed 930 times since Fri, Dec 19, 2014
Nagios XI - Adding Services To Pre-existing Switch or Router
Viewed 1036 times since Wed, Jan 27, 2016
Nagios XI - SQL Error [nagiosxi] : ERROR: syntax error
Viewed 727 times since Sun, Sep 10, 2017