Nagios Support Forum

Good Morning.

I have check_oracle_health installed and when I execute a command from the console it responds to me ok.

/usr/lib64/nagios/plugins/check_oracle_health --connect BBDD--user XXX --password XXX --mode process-usage --warning 90 --critical 95

But on the nagios website I get an error and I am executing the same command
Please help

Thanks !!!!

Another test.

If I write the wrong password on the command line, it gives me a user error and password ... instead on the web if I enter the wrong password, instead of giving me the same password error error, I still get the CRITICAL error - cannot connect to BBDD. ORA-12154

Sorry for my bad English, I'm using the google translator

It looks like the nagios user may not have access to, or may not know where the tnsnames.ora file is.

At the command line, try this,
This will run the command as the nagios user. It will probably give us the same error.

Did you run through the installation instructions as shown on Consol Labs' website?
https://labs.consol.de/nagios/check_ora ... stallation

Using username "root".
Last login: Thu Oct 3 10:17:55 2019 from xxxx
[root@xxxx ~]# su - nagios
-bash-4.1$ /usr/lib64/nagios/plugins/check_oracle_health --connect bbdd --user xxxx --password xxxx --mode process-usage --warning 90 --critical 95
OK - 7.83% of process resources used | process_usage=7.83%;90;95


The problem is that with the user nagios I execute the command from the console and the result is ok, but on the web I get the error
CRITICAL - cannot connect to prsical. ORA-12154:

That is very strange. The only difference I can think of is that Apache gets involved. Can you check you /etc/group file to make sure that the nagios user is in the Apache group, and the Apache user is in the nagios group?

the nagios user and the apache user is in the apache group and in the nagios group.
It's the only check that doesn't work for me, the rest of the alerts work fine, and I have about 1,000
It may be failing because I have not installed the oracle client with the user nagios ?? oracle install client I installed it as root
Thank you

My guess is that is cannot fin your environment, you may need to add something like the following to the command (replacing the path to your actual ORACLE_HOME)
https://labs.consol.de/nagios/check_ora ... index.html

scottwilkerson wrote:My guess is that is cannot fin your environment, you may need to add something like the following to the command (replacing the path to your actual ORACLE_HOME)

Code: Select all

--environment ORACLE_HOME=/u01/oracle

https://labs.consol.de/nagios/check_ora ... index.html

Perfect !!!! Works
I have added --environment ORACLE_HOME = / u01 / oracle
Thank you very much for the help

nagiosjam wrote:

scottwilkerson wrote:My guess is that is cannot fin your environment, you may need to add something like the following to the command (replacing the path to your actual ORACLE_HOME)

Code: Select all

--environment ORACLE_HOME=/u01/oracle

https://labs.consol.de/nagios/check_ora ... index.html

Perfect !!!! Works
I have added --environment ORACLE_HOME = / u01 / oracle
Thank you very much for the help

Glad it is resolved!

Locking thread