check_oracle_health
check_oracle_health
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 !!!!
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 !!!!
Re: check_oracle_health
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
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
Re: check_oracle_health
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
At the command line, try this,
Code: Select all
su - nagios
/usr/lib64/nagios/plugins/check_oracle_health --connect BBDD--user XXX --password XXX --mode process-usage --warning 90 --critical 95Did you run through the installation instructions as shown on Consol Labs' website?
https://labs.consol.de/nagios/check_ora ... stallation
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Be sure to check out our Knowledgebase for helpful articles and solutions!
Re: check_oracle_health
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:
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:
Re: check_oracle_health
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?
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Be sure to check out our Knowledgebase for helpful articles and solutions!
Re: check_oracle_health
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
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
-
scottwilkerson
- DevOps Engineer
- Posts: 19396
- Joined: Tue Nov 15, 2011 3:11 pm
- Location: Nagios Enterprises
- Contact:
Re: check_oracle_health
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
Code: Select all
--environment ORACLE_HOME=/u01/oracleRe: check_oracle_health
Perfect !!!! Worksscottwilkerson 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)
https://labs.consol.de/nagios/check_ora ... index.htmlCode: Select all
--environment ORACLE_HOME=/u01/oracle
I have added --environment ORACLE_HOME = / u01 / oracle
Thank you very much for the help
-
scottwilkerson
- DevOps Engineer
- Posts: 19396
- Joined: Tue Nov 15, 2011 3:11 pm
- Location: Nagios Enterprises
- Contact:
Re: check_oracle_health
Glad it is resolved!nagiosjam wrote:Perfect !!!! Worksscottwilkerson 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)
https://labs.consol.de/nagios/check_ora ... index.htmlCode: Select all
--environment ORACLE_HOME=/u01/oracle
I have added --environment ORACLE_HOME = / u01 / oracle
Thank you very much for the help
Locking thread