oracle_health issue with illegal char using Select count(*)

[Interrex]

Hi.

I just did an upgrade of NagiosXI 5.5.7 --> 5.6.14 - No issues with the upgrade.

Only thing that I see that fails after the upgrade is oracle checks where I use select count(*)
Looks like it's the star or (*) that makes the issue for me.

I have tried a lot of different escape "variations" also tried to do the unicode based alternativ.
Same issue every time.

Have anyone else had the same issue ?
I belive the issue is whit the oracle_health plugin. so will try to upgrade it tomorrow.

Other Oracle checks works fine, Oracle_Home or env settings works as normal.

[cdienger]

What is the full command you are running an the output you are receiving? Are you able to run the check from the command line?

[Interrex]

Hi. I have solved the issue.

I had two different problems.

1. In my old query i had to use escape before ! = " \! "
This was not necessary anymore and worked when I removed the " \ "

2. Error when I was running queries:

install_driver(Oracle) failed: Can't load '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libclntsh.so.12.1: cannot open shared object file: No such file or directory at /usr/lib64/perl5/DynaLoader.pm line 190.
at (eval 13) line 3.
Compilation failed in require at (eval 13) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /usr/local/nagios/libexec/check_oracle_health line 6155.

I found this in your knowledgebase:
https://assets.nagios.com/downloads/nag ... ios-XI.pdf

And this section solved the problem:
Configure Oracle Environment (New)
This section can only be used if you are running all of the following software versions:
• Nagios XI 5.6.1 or later
• Oracle Query Wizard 1.3.5 or later
• Oracle Serverspace Wizard 1.5.5 or later
• Oracle Tablespace Wizard 1.5.6 or later
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:

When I updated /usr/local/nagiosxi/etc/configwizards/oracle/oracle with the correct path for my oracle client everything worked as normal again.

- Interrex

[scottwilkerson]

Hi. I have solved the issue.

I had two different problems.

1. In my old query i had to use escape before ! = " \! "
This was not necessary anymore and worked when I removed the " \ "

2. Error when I was running queries:

install_driver(Oracle) failed: Can't load '/usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libclntsh.so.12.1: cannot open shared object file: No such file or directory at /usr/lib64/perl5/DynaLoader.pm line 190.
at (eval 13) line 3.
Compilation failed in require at (eval 13) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /usr/local/nagios/libexec/check_oracle_health line 6155.

I found this in your knowledgebase:
https://assets.nagios.com/downloads/nag ... ios-XI.pdf

And this section solved the problem:
Configure Oracle Environment (New)
This section can only be used if you are running all of the following software versions:
• Nagios XI 5.6.1 or later
• Oracle Query Wizard 1.3.5 or later
• Oracle Serverspace Wizard 1.5.5 or later
• Oracle Tablespace Wizard 1.5.6 or later
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:

When I updated /usr/local/nagiosxi/etc/configwizards/oracle/oracle with the correct path for my oracle client everything worked as normal again.

- Interrex

Great!

Locking thread