Oracle monitoring

[stefano]

checking alert.log

This addon is very usefull. But I think must also be monitored the alert.log file for any ORA- error.

Stefano

[vikty]

Hi,

I have installed the oracle client.
How it works well

PS
Is there a version most recent??

[jonnjonzzn]

Thyank You

Another note of thank you. If I can figure out how to use the wiki I'm going to consolidate the information from this thread there with download links, etc. Basically, a zabora howto. Nobody has done this yet, correct?

[vikty]

Script Tunning

Hi,

do anyone know a web site (or anything) with a list of SQL query, to insert into zabora script?

I have written these simple queries:

'procnum')
        sql="select to_char(count(1)) from v\$process;" #process number
        ;;

'sessnum')
        sql="select to_char(count(1)) from v\$session;" #session number
        ;;

I like this tipe of monitoring, because is very customiseable

[skanx]

License ?

Hi,

first of all, thank you for sharing this very useful script !
I don't see any license information in the files. Do you plan to release it in a free license like the GPL ?
In the meantime, is it possible for me to redistribute it ?

I am writing an open source documentation about Oracle monitoring with Zabbix using snmp, but some of the values I want aren't available via snmp. I use Zabora to get these values, and since Zabora is only available on this forum, it would be easier for the reader if I could disribute Zabora alongside my doc and scripts, in a single package.
This documentation/howto should be available soon on this forum.

Thanks in advance,
Nicolas.

[den_crane]

Hi,first of all, thank you for sharing this very useful script !

Thank you.

I don't see any license information in the files.

I was lazy to form it.

Do you plan to release it in a free license like the GPL ?
In the meantime, is it possible for me to redistribute it ?

zabora is copyleft. You can redistribute it under GPL.

Sorry for my English.

[vikty]

Under GPL each modify, must I communicate any changement?? correct??

[den_crane]

Under GPL each modify, must I communicate any changement?? correct??

no. You must give open access for your modification to any who ask.

[skanx]

Thanks for your answer, den_crane,

the documentation and scripts are now available here: http://opensources.octant-fr.com/

[max]

Same problem as Vikty

Hi,

Config :
Server > Ubuntu 7.10 - Zabbix 1.4.4
Client > Red Hat Enterprise Linux AS release 4 (October Update 4) - Zabbix_Agent 1.4.2

Using zabora, I've got the same problem as vikti. I've solved permissions problems by putting the user zabbix in oinstall group. But I have a new problem, see below...

Here is the log file I have in the zabbix_agent.log of the monitored client :

  8978:20080109:061331 zabbix_agentd started. ZABBIX 1.4.2.
  8980:20080109:061331 zabbix_agentd collector started
  8981:20080109:061331 zabbix_agentd listener started
  8982:20080109:061331 zabbix_agentd listener started
  8984:20080109:061331 zabbix_agentd listener started
  8985:20080109:061331 zabbix_agentd active check started [10.68.89.109:10051]
+ zaboraver=1.5
+ rval=0
+ '[' '' '!=' '' ']'
+ case $1 in
+ sql='select to_char(count(*)-1, '\''FM99999999999999990'\'') retvalue from v$session where username is not null;'
+ '[' 'select to_char(count(*)-1, '\''FM99999999999999990'\'') retvalue from v$session where username is not null;' '!=' '' ']'
+ echo 'select to_char(count(*)-1, '\''FM99999999999999990'\'') retvalue from v$session where username is not null;'
+ /u02/oracle/product/10.2.0/bin/sqlplus -s /nolog @/u02/agent/zabora/cont.sql
[B]/u02/oracle/product/10.2.0/bin/sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory[/B]
+ rval=127
+ '[' 127 -ne 0 ']'
+ echo ZBX_NOTSUPPORTED
+ exit 127

Is anyone experiencing some problem using sqlplus within zabbix agent ?
Does anyone have a solution before I try installing the oracle client as vikty did ?

[valerio.crini]

I had similar problems when my oracle variables were wrong.
Try to modify oraenv (part of zabora package) and your zabbix user's .bashrc.

[max]

Thanks for your answer valerio.crini

Something I forgot to said is that zabora works perfectly in the shell with the zabbix user...

Anyway, I've added ORACLE_HOME and LD_LIBRARY_PATH in .bash_profile.

Here is my oraenv :

export ORACLE_HOME=/u02/oracle/product/10.2.0
export ORACLE_SID=BUL
export PATH=$PATH:/usr/bin:/usr/sbin/:/u02/oracle/product/10.2.0/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
#export NLS_LANG=american_cis.cl8mswin1251

Note : Is NLS_LANG useful for the good working of the script ?

But I have the same error after restarting my agent...

[valerio.crini]

hints

Have zabora run successful as bash script or from zabbix_agent with -t option? When I have a problem first I use /usr/local/sbin/zabbix_agentd -t oracle[usercount] and if it fails as /usr/local/sbin/zabora usercount.

If from shell run successfully I ask you to compare your linux user with the user that is running your zabbix_agentd (you can see with top).
I had problem at running zabbix_agentd as root so I changed starting script in /etc/init.d to change user in 'zabbix'

su - zabbix -c /usr/local/sbin/zabbix_agentd

and it worked.

In my bash profile I added oracle environment in order to test queries without changing user when i had to start mysql.

Here is my oraenv :

export ORACLE_HOME=/u02/oracle/product/10.2.0
export ORACLE_SID=BUL
export PATH=$PATH:/usr/bin:/usr/sbin/:/u02/oracle/product/10.2.0/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
#export NLS_LANG=american_cis.cl8mswin1251

Note : Is NLS_LANG useful for the good working of the script ?

I am not a oracle Guru but in first post of this thread I found it so i adopted it ....

[max]

Some news...
It works !... but I'm not sure the reason why...

In fact, on the monitored server, the inclusion of the oraenv file didn't worked so I put the content of oraenv directly in the zabora script... and it worked. Weird.

Another thing I found weird : I've performed some tests with the zabbiix user on my zabbix server and on the monitored server... The script itself works but through zabbix_agentd, it doesn't...however the result are correctly sent to the server because the graphs are working ! See below :

(Ubuntu 7 : ZABBIX Server + Oracle XE)

zabbix@test-desktop:~$ /home/zabbix/zabora-1.2/zabora rcachehit
95.1736
zabbix@test-desktop:~$ /usr/sbin/zabbix_agentd -t oracle[rcachehit]
oracle[/home/zabbix/zabora-1.2/zabora zaboraver ]  [t| 95.1736]

(Redhat 4 : Oracle 10g)

[zabbix@dbavm ~]$ /u02/agent/zabora/zabora rcachehit
99.7996
[zabbix@dbavm ~]$ /usr/sbin/zabbix_agentd -t oracle[rcachehit]
oracle                                        [m|ZBX_NOTSUPPORTED]

Could someone explain this ?

[bee]

ZABORA and multiple OID value calculation

Hi All,
First of all, sorry if this quite silly question for someone out there but i insist to post it

I'm new comer of Oracle, and have oppurtunity to try it on one of my development machine with Windows 2003 Server platform.

My question, how do i use ZABORA on windows 2003?

Ussualy, i'm quite famililar with retrieving snmp value on zabbix to monitor most of network devices such as server, router etc.
But how do i retrieve "correct" Oracle snmp value for example Cache Hit Ratio.
In oracle documentation they publish as follow

Cache Hit Ratio - This ratio measures the effectiveness of the buffer cache. The normally acceptable range is 70 - 85%. 
(oraDbSysConsistentGets + oraDbSysBlockGets - oraDbSysPhysReads) / 
(oraDbSysConsistentGets + oraDbSysBlockGets)

In my understanding on what Oracle documentation said, we need to do simple arithmatic calculation on several Oracle OID to get Cache Hit ratio. am i right?
If yes, how do i perform it on zabbix?as my understanding, zabbix cannot do multiple OID arithmatic calculation.

Thanks,
BEE