Upgrade to 5.3.0

[jcwuerfl]

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

[jcwuerfl]

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$

[lmiltchev]

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.

[jcwuerfl]

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.

[dwhitfield]

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!