Oracle monitoring

[den_crane]

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?

C:\blat>zabora.bat rcachehit

97.6203

C:\blat>zabora.bat version

Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production

C:\blat>ver

Microsoft Windows [Версия 5.2.3790]

http://www.zabbix.com/forum/showpost.php?p=22650&postcount=11

[max]

Hello,

What is your technique to monitor several Oracle instances on a single machine using templates ?

Bye.

[max]

I think I need to deeper my question.
I've got a Solaris server (on which I've deplaoyed Zabbix agent) which contains several Oracle instances (let's call them SID1, SID2, ...).
I've set an Oracle template based on the options of zabora (rcachehit, version, dbsize, checkactive...)
On the agent, I've added in my zabbix_agentd.conf the line :
UserParameter=oracle[*],/path/to/zabora \$1 \$2
so the agent can check the parameters of my current instance set in the environmment variable ORACLE_SID=SID1.

On the server side, in the php frontends, I've added the template Oracle to the host 'Solarais server'.

But the problem is here : how to monitor my others Oracle instances SID2, SID3... ?

Is it possible to add a parameter to my templates (the SID) so as to monitor all my instances for one server (one Zabbix agent) ?

[den_crane]

On the server side, in the php frontends, I've added the template Oracle to the host 'Solarais server'.
But the problem is here : how to monitor my others Oracle instances SID2, SID3... ?

add items direct to host
key: oracle[dsksortratio, sid2]
key: oracle[dsksortratio, sid3]

I don't know how obtain it using templates.

[max]

Hi !

I need some help with zabora...
When the monitored database is open and active (in fact, when all is ok...), the monitoring is fine and consumes few cpu load.
But when my database is down or listener is off for example, all the items returns (Not Supported) and I think the agent try excuting these item much more oftenly cause they doesn't work (maybe I'm wrong as I don't know how the Not Supported items are handled by Zabbix). As a result, the script consumes a lot more, and the load average is increasing of 2-3 points on that monitored host.

You, users of zabora, did you encounter the same issue as described ?

More generally, is there a way to disable the verification of item(s) when one other are down ? For the triggers, we can ignore a trigger when another one is activited (through the dependencies function) : maybe it's possible too with items ?

Bye.

[max]

No one knows ?
No one encounters that problem ?

[nebrassal]

Thankx but!!!

When tried all previous steps, they worked ok. But when I added the new host (Oracle server) to Zabbix monitored list, these new items appeared as "Not Supported by Zabbix agent" although I activated these items many times but nothing changed.
So kindly advise.

[bignose]

Have it about 98% working..

Hi all,

I am encountering the following error:

oracle@db0$ ./zabbix_agentd -c /etc/zabbix/zabbix_agentd.conf -t oracle[uptime]
oracle [m|ZBX_NOTSUPPORTED]

However, all previous tests from the setup-posting work. Zabora works from the command line:

oracle@db0$ ./zabora uptime
444119

As I did add the line


UserParameter=oracle[*],/opt/zabbix/zabora $1 $2

to /etc/zabbix/zabbix_agentd.conf

Then restarted the zabbix_agentd with svcadm, restarted with out error.

oracle@db0$ ./zabbix_agentd -c /etc/zabbix/zabbix_agentd.conf -p|grep -i oracle doesn't show me anything.. tho i'm new to this and am not sure if it should.

Anyways, any pointers?

This is on Solaris 10 x86 btw.

[dtricke]

Hi,

I have imported the Zabora .xml file, now I’m wondering if it comes by default with triggers? The reason I ask is because I only see items..


Thanks.
Tricke

[cassioseffrin]

Problem with results of zabora script

Hi all,

Recently I found zabora scripts. I'm using the linux Red Hat 9.

[oracle@morpheu zabbix]$ uname -a

******************************************

I set all parameters in oraenv, cont.sql and uncoment the "set -x " in zabora script to show the output results.

if I run sqlplus directly in shell, I get the follow result:


************************************************** ***************
[oracle@morpheu zabbix]$ sqlplus teste/teste

SQL*Plus: Release 9.2.0.5.0 - Production on Sat Jul 25 09:29:31 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Release 9.2.0.5.0 - Production
JServer Release 9.2.0.5.0 - Production

SQL> select banner from v$version where rownum=1;

BANNER
----------------------------------------------------------------
Oracle9i Release 9.2.0.5.0 - Production
************************************************** ***************


I think this is right, but when I execute zabora script even with set -x active, the result (version) aren't displayed.

Then my question is: Why when I run the zabora script the results is not displayed, what's wrong, is a Red Hat problem?

************************************************** ***************
[oracle@morpheu zabbix]$ ./zabora version ora9i
+ zaboraver=1.2
+ rval=0
+ '[' ora9i '!=' '' ']'
+ export ORACLE_SID=ora9i
+ ORACLE_SID=ora9i
+ sql=select banner from v$version where rownum=1;
+ '[' 'select banner from v$version where rownum=1;' '!=' '' ']'
+ echo 'select banner from v$version where rownum=1;'
+ sqlplus -s /nolog @/opt/zabbix/cont.sql
+ rval=1
+ exit 1
************************************************** ***************


Best Regards,

Cassio Seffrin

[cassioseffrin]

Re: Problem with results of zabora script

Hi again,

Today I can get the results with succeed.

I was omited the database string teste/teste@ora9 in cont.sql file.

To zabbix agent work fine was need to set the same userid and groupid of oracle user, this give permissions for zabbix user can run sql querys.

Cássio

[interesttolearn]

Hi Everybody,
i am a newbie to Zabbix and this zabora too.
i am basically a system admin and not much knowledge with oracle dba.
i need to monitor some of the oracle services through zabbix.
i hope this zabora is a very helpful tool for achieve this.
Is there any step by step guide to follow and install zabora ?

Guidance are very helpful.
Thanks in advance.

[stephand]

guide for zabora

Have a look at the Wiki:
http://www.zabbix.com/wiki/howto/mon.../orcale/oracle

More Questions:

Does it work with ZABBIX 1.8
Does it also work with Oracle 10 and/or 11?

[akabaker]

Oracle instant client

I want to monitor multiple oracle instances on different hosts. Does this script need to be present on each host to obtain functionality? Or is there a way to do this in a more 'central' manner? i.e., using the Oracle Instant Client?

thanks!

[thiagomz]

Guys,

Are there a way to get the size os all tablespaces, or i have to get one by one ... ?

I am trying to change the zabora to get tablespace related stuff.

tkz all

thiagomz