nagios check_oracle_health ERROR OCIEnvNlsCreate
2019-03-19本地可以执行，nagios服务器执行错误
1、/usr/local/nagios/libexec/check_nrpe -H ip -c check_tnsping
CRITICAL - cannot connect to DB140. ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var or PATH (Windows) and or NLS settings,
2、数据库日志：/var/tmp/oradiag_nagios/diag/clients/user_nagios/host_1131606029_80/alert
log.xml显示
<txt>Unable to find environment variable: ORACLE_HOME
3、解决方法，在nrpe.cfg设置check_oracle_health 参数--environment参数，指定ORACLE_HOME环境变量
例如/usr/local/nagios/libexec/check_oracle_health --connect=DB140 --mode=tnsping --environment ORACLE_HOME=/u02/oracle/11.2.0
分类：数据库 | 标签： |