Error when install & configure oracle client & plugins ...

[xpertech]

1. Download nagiosxi-5.4.13-64.ova and deploy vm

2. Download three rpm from Oracle and saved in NagiosXI /tmp/
oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm
oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm
oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm

3. Follow "How To Install & Configure The Oracle Client & Plugins" guide to install

there's an error at the end of installation, please refer attachment.

I remember it's rather easy to install without problem before, but this time got an error, I wonder if it's the different version caused? how to fix?

[xpertech]

After some fixing, the command line monitor testing was ok, but web monitor still error?! (refer attachment)

[xpertech]

I re-install NagiosXI and follow this document https://assets.nagios.com/downloads/nag ... 1529083912 , but change to download three 11.2 Oracle instant client, I use command line to monitor Oracle without problem, but still error in NagiosXI monitor?! please refer attachment.

[tgriep]

When the check_oracle_health plugin runs, it stores temporary data in the following folder.

Code: Select all

/var/tmp/check_oracle_health

Try deleting the files in that folder and see if the check runs in the GUI.
One thing to note, if you run the plugin as root, it will create the files in the above folder as the root uses so when the nagios process runs them as the nagios user, it cannot create the files and generates an error.

Also, make sure the command is defined correctly with the path to env and the Oracle environment.
Your commands should look similar to this.

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$

[xpertech]

When the check_oracle_health plugin runs, it stores temporary data in the following folder.

Code: Select all

/var/tmp/check_oracle_health

Try deleting the files in that folder and see if the check runs in the GUI.
One thing to note, if you run the plugin as root, it will create the files in the above folder as the root uses so when the nagios process runs them as the nagios user, it cannot create the files and generates an error.

Also, make sure the command is defined correctly with the path to env and the Oracle environment.
Your commands should look similar to this.

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$

The NagiosXI GUI only has an administrator account as nagiosadmin, didn't see a root account? and can not login as root account?

The default command in the Oracle Query GUI is ...
check_xi_oraclequery!--connect '192.168.1.110:1521/orcl' --username 'sys' --password 'Passw0rd' --mode sql --name="select count(*) from v\\$session where status = 'active'" --warning 50 --critical 200

should I change to ... ?! (seems not work)
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$ --connect '192.168.1.110:1521/orcl' --username 'sys' --password 'Passw0rd' --mode sql --name="select count(*) from v\\$session where status = 'active'" --warning 50 --critical 200

[xpertech]

After trouble shooting, it's ok now, so can lock this post, thanks!

[tgriep]

That is good to hear. I'll lock the post for you.