Nagios Support Forum

Hi,
I have problems with oracle plugins like check_oracle_health or check_oracle instant and I think it is because of the perl settings. Through CLI they work for me but in the GUI no, can someone tell me if these variables are correct as much as for perl as Oracle?

[root@nagios ~]# printenv
XDG_SESSION_ID=782
HOSTNAME=nagios.example.com
TERM=xterm
SHELL=/bin/bash
HISTSIZE=1000
SSH_CLIENT=192.168.1.105 63982 22
PERL5LIB=/root/perl5/lib/perl5:
PERL_MB_OPT=--install_base /root/perl5
SSH_TTY=/dev/pts/1
USER=root
LD_LIBRARY_PATH=/usr/lib/oracle/18.5/client64/lib
LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arc=01;31:*.arj=01;31:*.taz=01;31:*.lha=01;31:*.lz4=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.tzo=01;31:*.t7z=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lrz=01;31:*.lz=01;31:*.lzo=01;31:*.xz=01;31:*.bz2=01;31:*.bz=01;31:*.tbz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.war=01;31:*.ear=01;31:*.sar=01;31:*.rar=01;31:*.alz=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.cab=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.webm=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xspf=01;36:
MAIL=/var/spool/mail/root
PATH=/root/perl5/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin
PWD=/root
LANG=es_ES.UTF-8
HISTCONTROL=ignoredups
SHLVL=1
HOME=/root
PERL_LOCAL_LIB_ROOT=:/root/perl5
LOGNAME=root
SSH_CONNECTION=192.168.1.105 63982 192.168.1.200 22
LESSOPEN=||/usr/bin/lesspipe.sh %s
XDG_RUNTIME_DIR=/run/user/0
ORACLE_HOME=/usr/lib/oracle/18.5/client64
PERL_MM_OPT=INSTALL_BASE=/root/perl5
_=/usr/bin/printenv


Thank you.

This is going to depend on your version and location of the Oracle client, however, in most cases nagios doesn't read your users environment variables, so you would prepend your command with something like This will depend on the plugin you use.

We are not the author of any Oracle plugins, I would suggest reaching out to the author of the plugin you are attempting to use.

You mean include something like that inside the command?

define command{
command_name check_oracle_health
command_line /usr/local/nagios/libexec/check_oracle_health –connect=xxxxx –username=xxxxx –password='xxxxxx' –-mode xxxxxx –warning=$ARG2$ –critical=$ARG3$ -enviroment ORACLE_HOME=/usr/lib/oracle/18.5/client64 /usr/local/nagios/libexec/ args
}

I was suggesting this
But again, we are not the plugin author so I'm not sure what their suggestions are.