vipinvgopal
asked on
Issue with check_oracle plugin nagios
Hi,
I have an issue with check_oracle plugin which is bundled along with nagios itself.I can connect to the oracle server
as root user using the plugin and getting correct response.
I am using CentOS6.4
--------------
$./check_oracle --tns staborcl
OK - reply time 0 msec from staborcl
--------------
But when trying to coonect using nrpe i am getting the error :
--------------
cannot determine oracle_home for sid staborcl
--------------
I tried defining ORACLE_HOME in /etc/profile and added SID for all users in oratab file.
my /etc/oratab
--------
staborcl:/u01/app/oracle/p roduct/10. 1.0/db_1:N
*:/u01/app/oracle/product/ 10.1.0/db_ 1:N
---------
But nothing worked. Is there a way to get rid of from this error.
I have an issue with check_oracle plugin which is bundled along with nagios itself.I can connect to the oracle server
as root user using the plugin and getting correct response.
I am using CentOS6.4
--------------
$./check_oracle --tns staborcl
OK - reply time 0 msec from staborcl
--------------
But when trying to coonect using nrpe i am getting the error :
--------------
cannot determine oracle_home for sid staborcl
--------------
I tried defining ORACLE_HOME in /etc/profile and added SID for all users in oratab file.
my /etc/oratab
--------
staborcl:/u01/app/oracle/p
*:/u01/app/oracle/product/
---------
But nothing worked. Is there a way to get rid of from this error.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the reply. ORACLE_HOME and ORACLE_SID is setup in root's bash_profile and root is able to execute command without issues. Actual
problem here is nagios user doesn't having shell access (/sbin/nologin). In which file I need to explicitly define these variables for nagios user.