Page 1 of 1
NagiosXi 5.8.3 oracle DB connection issue
Posted: Wed Apr 07, 2021 6:12 am
by kminfrateam
Hi, we were running nagiosXi 5.6 and updated to 5.8.3. (running on centos 7). After the update all our oracle DB checks came in with the following critical warnings:
"Critical cannot connect to OURORACLEDB.local:port/ORADB. nosqlplus"
This was all working in the previous version but was setup by someone who no longer works with us and i have no clue were to start. Any assistance would be welcome. Thanks
Re: NagiosXi 5.8.3 oracle DB connection issue
Posted: Wed Apr 07, 2021 3:21 pm
by benjaminsmith
Hi,
Some changes were made to the Oracle Wizard starting in 5.6.1 and when you update to major or minor release, the upgrade script will force update all the extensions. Try to re-run the wizard against the server and let me know if it's able to connect. If not check the paths to make sure it's similar to what's show below.
If you are not using all of these, please refer to the next section (Configure Oracle Plugin Commands).
As of Nagios XI 5.6.1, the Oracle check_commands will no longer need to be modified directly. Instead, the
Oracle-related environment variables will be read from /usr/local/nagiosxi/etc/configwizards/oracle/oracle.
If the wizards installed correctly, the file's contents should look similar to this:.
LD_LIBRARY_PATH=/usr/lib/oracle/18.5/client64/lib
ORACLE_HOME=/usr/lib/oracle/18.5/client64[*]
More details in the guide below.
How To Install & Configure The Oracle Client & Plugins
If the issue persists, please PM a system profile for us to review.
To send us your system profile.
Login to the Nagios XI GUI using a web browser.
Click the "Admin" > "System Profile" Menu
Click the "Download Profile" button
--Benjamin