Database not responding false positives about pyora HOT 17 CLOSED

Hi,

• What's other checks status? are they working fine?
• What's error code when you are running pyora (as Zabbix user not oracle)from command line (first execute env then execute pyora), then paste whole shell session output here (I'm mostly interested in LD_LIBRARY_PATH and ORACLE_HOME variables)
• take a look to zabbix_agentd.log file (it should be in /var/log/Zabbix)
• try to change your Zabbix agent UserParameter as below
  UserParameter=pyora[*],export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 && export LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/db_1/lib && /usr/local/scripts/pyora.py --username $1 --password $2 --address $3 --database $4 $5 $6 $7 $8

from pyora.

Hello,

• Other checks are working fine, no errors
• Output of env with zabbix user:

zabbix@server01:/root> env
LESSKEY=/etc/lesskey.bin
NNTPSERVER=news
INFODIR=/usr/local/info:/usr/share/info:/usr/info
MANPATH=/usr/local/man:/usr/local/share/man:/usr/share/man:/usr/X11R6/man:/opt/gnome/share/man
HOSTNAME=server01
GNOME2_PATH=/usr/local:/opt/gnome:/usr
XKEYSYMDB=/usr/X11R6/lib/X11/XKeysymDB
HOST=server01
SHELL=/bin/bash
TERM=xterm
PROFILEREAD=true
HISTSIZE=1000
MORE=-sl
GROFF_NO_SGR=yes
USER=zabbix
LS_COLORS=no=00:fi=00:di=01;34:ln=00;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=41;33;01:ex=00;32:.cmd=00;32:.exe=01;32:.com=01;32:.bat=01;32:.btm=01;32:.dll=01;32:.tar=00;31:.tbz=00;31:.tgz=00;31:.rpm=00;31:.deb=00;31:.arj=00;31:.taz=00;31:.lzh=00;31:.zip=00;31:.zoo=00;31:.z=00;31:.Z=00;31:.gz=00;31:.bz2=00;31:.tb2=00;31:.tz2=00;31:.tbz2=00;31:.avi=01;35:.bmp=01;35:.fli=01;35:.gif=01;35:.jpg=01;35:.jpeg=01;35:.mng=01;35:.mov=01;35:.mpg=01;35:.pcx=01;35:.pbm=01;35:.pgm=01;35:.png=01;35:.ppm=01;35:.tga=01;35:.tif=01;35:.xbm=01;35:.xpm=01;35:.dl=01;35:.gl=01;35:.wmv=01;35:.aiff=00;32:.au=00;32:.mid=00;32:.mp3=00;32:.ogg=00;32:.voc=00;32:*.wav=00;32:
XNLSPATH=/usr/X11R6/lib/X11/nls
ENV=/etc/bash.bashrc
HOSTTYPE=x86_64
FROM_HEADER=
PAGER=less
CSHEDIT=emacs
XDG_CONFIG_DIRS=/usr/local/etc/xdg/:/etc/xdg/:/etc/opt/gnome/xdg/
MINICOM=-c on
MAIL=/var/spool/mail/zabbix
PATH=/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/games:/opt/gnome/bin:/opt/kde3/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin
CPU=x86_64
INPUTRC=/etc/inputrc
PWD=/root
LANG=es_ES.UTF-8
PYTHONSTARTUP=/etc/pythonstart
TEXINPUTS=:/home/zabbix/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX
QT_SYSTEM_DIR=/usr/share/desktop-data
SHLVL=1
HOME=/home/zabbix
LESS_ADVANCED_PREPROCESSOR=no
OSTYPE=linux
LS_OPTIONS=-N --color=tty -T 0
XCURSOR_THEME=
GTK_PATH=/usr/local/lib/gtk-2.0:/opt/gnome/lib/gtk-2.0:/usr/lib/gtk-2.0
G_FILENAME_ENCODING=@Locale,UTF-8,ISO-8859-15,CP1252
LESS=-M -I
MACHTYPE=x86_64-suse-linux
LOGNAME=zabbix
GTK_PATH64=/usr/local/lib64/gtk-2.0:/opt/gnome/lib64/gtk-2.0:/usr/lib64/gtk-2.0
XDG_DATA_DIRS=/usr/local/share/:/usr/share/:/etc/opt/kde3/share/:/opt/kde3/share/:/opt/gnome/share/
ACLOCAL_FLAGS=-I /opt/gnome/share/aclocal
PKG_CONFIG_PATH=/opt/gnome/lib64/pkgconfig:/opt/gnome/share/pkgconfig
LESSOPEN=lessopen.sh %s
INFOPATH=/usr/local/info:/usr/share/info:/usr/info:/opt/gnome/share/info
LESSCLOSE=lessclose.sh %s %s
G_BROKEN_FILENAMES=1
COLORTERM=1
_=/usr/bin/env

• I checked zabbix_agent.log file but no errors

I cant change the UserParameter in zabbix_agent.conf file becouse I'm monitoring different oracle databases with different ORACLE_HOME.

I have to say that this problem does come up randomly, somethime it works and sometimes not.

from pyora.

Hello,

Can you try to increase the Debug level from zabbix-agent and check it for errors?

from pyora.

Ok... should it be the zabbix_agent.conf of the oracle or zabbix server?

from pyora.

Where you are running Pyora.

from pyora.

No errors at all...

from pyora.

Try to keep the Debug on until you get the error, so you can analyse it.

from pyora.

@jakobeissler , you are still getting the error??

from pyora.

Yes, I set DebugLevel=3 but I'm not getting any errors.

from pyora.

If you run it by hand what it returns?

from pyora.

When I execute the comman by hand it works as expected. As I was saying the
script appears to fail randomly a few times a day each day, triggering an
alert saying the databases are down. After a few minutes it starts working
again.

2016-09-21 13:46 GMT-03:00 Danilo Chilene [email protected]:

If you run it by hand what it returns?

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#10 (comment), or mute
the thread
https://github.com/notifications/unsubscribe-auth/AUOJ8iRZVHMqdWiuhaKL0-X_1xD5xXx-ks5qsV91gaJpZM4JrNJ1
.

Jakob Eissler
Ingeniero Civil en Computación e Informática
[email protected]

from pyora.

@jakobeissler ,

Maybe timeout between the server that you run the script and the database? I will close this issue since doesn't looks like related with Pyora, is that OK for you?

from pyora.

OK, I'll look into this the next few days and come back o you. Thanks a lot.

2016-09-28 9:46 GMT-03:00 Danilo Chilene [email protected]:

@jakobeissler https://github.com/jakobeissler ,

Maybe timeout between the server that you run the script and the database?
I will close this issue since doesn't looks like related with Pyora, is
that OK for you?

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#10 (comment), or mute
the thread
https://github.com/notifications/unsubscribe-auth/AUOJ8itXASXJVnxhf4Zy3pOHImYQVKqWks5qumGogaJpZM4JrNJ1
.

Jakob Eissler
Ingeniero Civil en Computación e Informática
[email protected]

from pyora.

@jakobeissler ,

Can we close this?

from pyora.

from pyora.

You tried it and worked?

from pyora.

from pyora.