Nagios Support Forum

Posted: **Tue Oct 04, 2016 11:49 am**

Did an upgrade to 5.3.0, and the upgrade looked like it was successful, however, it looks like I have an issue with the Oracle client. Any ideas?

Thanks!

Code: Select all

/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib ORACLE_HOME=/usr/lib/oracle/11.2/client /usr/local/nagios/libexec/check_oracle_health --connect 'server.mydomain.local:1522/10GD' --username 'Support' --password 'support' --mode sql --name="select 1 from dual" --warning 1 --critical 1
CRITICAL - cannot connect to server.mydomain.local:1522/10GD. install_driver(Oracle) failed: Can't load '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libocci.so.11.1: cannot open shared object file: No such file or directory at /usr/lib64/perl5/DynaLoader.pm line 200.
 at (eval 19) line 3
Compilation failed in require at (eval 19) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at /usr/local/nagios/libexec/check_oracle_health line 4755

Posted: **Tue Oct 04, 2016 12:19 pm**

Figured it out. Looks like it changed / reverted the command paths to the default which I had to change a bit. So resetting it back resolved.

aka:

check_xi_oraclequery

/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib ORACLE_HOME=/usr/lib/oracle/11.2/client $USER1$/check_oracle_health $ARG1$
to
/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 $USER1$/check_oracle_health $ARG1$

check_xi_oracleserverspace

/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib ORACLE_HOME=/usr/lib/oracle/11.2/client $USER1$/check_oracle_health $ARG1$
to
/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 $USER1$/check_oracle_health $ARG1$

check_xi_oracletablespace

/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib ORACLE_HOME=/usr/lib/oracle/11.2/client $USER1$/check_oracle_health $ARG1$
to
/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib ORACLE_HOME=/usr/lib/oracle/11.2/client64 $USER1$/check_oracle_health $ARG1$

Posted: **Tue Oct 04, 2016 1:49 pm**

I was able to verify this behavior on my test XI box, and let our developers know.

I had:

Code: Select all

ORACLE_HOME=/usr/lib/oracle/12.1/client64
LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib

but after an upgrade to the latest, my commands changed to (on a 64-bit system):

Code: Select all

/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib ORACLE_HOME=/usr/lib/oracle/11.2/client $USER1$/check_oracle_health $ARG1$
/usr/bin/env LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client/lib ORACLE_HOME=/usr/lib/oracle/11.2/client $USER1$/check_oracle_health $ARG1$

The reason this is happening is that we update the "default" commands/dashlets/wizards/etc. on an upgrade. Personally, I think this is a bug but I will let them decide how this will be handled.

Posted: **Tue Oct 04, 2016 2:16 pm**

Ok great! Thanks for verifying. I also think that commands perhaps shouldn't be changed during upgrades. Just a bit surprising as I thought I had a bigger issue but turns out just those commands were changed.

Posted: **Tue Oct 04, 2016 2:49 pm**

It sounds like this issue has been resolved. I'm not sure if there is going to be a bug report, but if there is we can post the internal ID to this thread later.

That said, is it okay if we lock this thread? Thanks for choosing the Nagios forums!

Nagios Support Forum

Upgrade to 5.3.0

Upgrade to 5.3.0

Re: Upgrade to 5.3.0

Re: Upgrade to 5.3.0

Re: Upgrade to 5.3.0

Re: Upgrade to 5.3.0