Nagios Support Forum

Hello XI support

Oracle Query wizard ver. 1.3.2 / Oracle Serverspace wizard ver. 1.5.2 / Oracle Tablespace wizard 1.5.3 seem to have compatibility issues with client 11.2 (breaks its configurations)
we were told to use in Q4 2015 because there were known issues with 12.x

Did anything change about client 12.x support in XI - could it be used now?
Does Oracle wizard/client manual now up to date?

The documents were recently updated to account for some changes to the Oracle website. However, they still recommend 11.2 be used.

mcapra wrote:The documents were recently updated to account for some changes to the Oracle website. However, they still recommend 11.2 be used.

When we upgrade to version 5.3 our Oracle checks (based of 11.2) stop working. all of them. so we cannot use 11.2 same way as with 5.2.9.

What error message do you receive?

I think this other thread has the solution https://support.nagios.com/forum/viewto ... lit=oracle

Here's what likely needs be changed:

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$

Please let us know if this fixes the issue.

There is an internal feature request to not overwrite user checks. There is not currently an ETA on that feature request.

dwhitfield wrote:Here's what likely needs be changed:

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$

Please let us know if this fixes the issue.

There is an internal feature request to not overwrite user checks. There is not currently an ETA on that feature request.

This worked, thank you.
Did not realize 5.3.x would overwrite oracle commands back into defaults.

The feature request in question is 9765. My guess is it will be a big enough change that 5.4 will be the earliest it exists. As of right now, there is no time-table (public or private).

That all said, is it ok if we lock this thread?

dwhitfield wrote:The feature request in question is 9765. My guess is it will be a big enough change that 5.4 will be the earliest it exists. As of right now, there is no time-table (public or private).

That all said, is it ok if we lock this thread?

Yes please / thank you once again

You're welcome!