Oracle monitoring

[thiagomz]

Trigger in zabora

Guys,

I am with a problem...

how to set up a trigger to zabora, more exactly to checkactive option...

my problem... When my database is up and running... zabora returns 1, look

[root@srvoracle ~]# /etc/zabbix/zabora checkactive
1

But, if I shutdown oracle database, checkactive returns ZBX_NOTSUPPORTED

root@srvoracle ~]# /etc/zabbix/zabora checkactive
ZBX_NOTSUPPORTED

I tried to set up a trigger like this...

{HOSTNAMEracle[checkactive].last(0)}=0

But it do not fire when I stop the database...

Thanks all...

[virtualet]

I hope this helps someone...

For those of you who may be having issues with zabora, i hope this post will help. I just got zabora working on my test oracle box, and it's a great feeling seeing those data points populate with information.

A couple of things:
1. After downloading and installing zabora (according to the instructions from the OP), I was unable to get zabora to run itself. I was getting a "./zabora: $PATH_TO_ORACLE is not an identifier" error. I was able to fix this by changing the #! /usr/bin/sh to #! /usr/bin/ksh at the top of the zabora script. This fixed the problem, as the way that the PATH variable was being exported was not working with my solaris installation

2. While the zabora script started working, the zabbix agent would spit back errors when trying to reference the oracle custom parameter:
dbtest01:~/> zabbix_agentd -t oracle[version]
oracle [m|ZBX_NOTSUPPORTED]

I realized that the zabbix user .profile did not have the path to zabbix_agentd. Once I made the adjustment (PATH=$PATH:/usr/local/sbin), the new oracle parameters started to get supported by the zabbix agent. I assume that I would have encountered this problem earlier if I had added any other custom parameters, but nonetheless, it's working now.

[dernwine]

The heartbreak of ZBX_NOTSUPPORTED...

I have Zabora installed and partially working. I have Zabora installed in "/opt/zabbix",
zabbix_agentd.conf in "/etc/zabbix" and zabbix_agentd in "/home/zabbix/zabbix/sbin".
I have the "/home/zabbix/zabbix/sbin" and "/opt/zabbix" directories in my PATH variable.

Using zabora commands works fine, for example:
$ zabora checkactive
1
$

However, if I attempt to issue commands via zabbix_agentd I get the dreaded and despicable
[m|ZBX_NOTSUPPORTED] response:

$ ./zabbix_agentd -c /etc/zabbix_agentd.conf -t oracle[version]
oracle [m|ZBX_NOTSUPPORTED]
$

The /tmp/zabbix_agentd.log files shows nothing for this error.

My /etc/zabbix/zabbix_agentd.conf file has the following line:
UserParameter=oracle[*],/opt/zabbix/zabora $1 $2

Any ideas?

[dernwine]

Update to "The heartbreak of ZBX_NOTSUPPORTED..."

Like several other Zabora posts, I continue to get the "NOTSUPPORTED" response when attempting to to run the command with agentd.

However, once I built the items referencing the Oracle parameters, (checkactive, indexffs, etc) Zabbix is getting populated with the appropriate data. Weird.

Has anyone figured out how to get tablespace sizes?

[niranjan]

Need help on the same.

how do I trigger, if the value is zbx_notsupported (while the item value is set to numeric)

regards
Niranjan

Guys,

I am with a problem...

how to set up a trigger to zabora, more exactly to checkactive option...

my problem... When my database is up and running... zabora returns 1, look

[root@srvoracle ~]# /etc/zabbix/zabora checkactive
1

But, if I shutdown oracle database, checkactive returns ZBX_NOTSUPPORTED

root@srvoracle ~]# /etc/zabbix/zabora checkactive
ZBX_NOTSUPPORTED

I tried to set up a trigger like this...

{HOSTNAMEracle[checkactive].last(0)}=0

But it do not fire when I stop the database...

Thanks all...

[thiagomz]

Need help on the same.

how do I trigger, if the value is zbx_notsupported (while the item value is set to numeric)

regards
Niranjan

If I restart my server... the zabora script return zbx_notsupported, as consequence .. my zabbix server disable all items .... and i have to activate all again....

niranjan... that's a good question... i would like to known too !

;-)

[rickymarino]

Zbx_notsupported

I solved that issue (ZBX_NOTSUPPORTED) by adding the zabbix user to the oracle groups: oinstall, dba, etc

[newbie01.oracle]

Hi,

Am having the same problem, added to oinstall and dba group, still giving the message below?

-bash-3.00$ ./zabbix_agentd -c /etc/zabbix/zabbix_agentd.conf -t oracle[version]
oracle [m|ZBX_NOTSUPPORTED]

Running zabora from the command line = OK

-bash-3.00$ /home/zabbix/zabora version
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
-bash-3.00$

Not sure what else to try. BTW, does anyone know what to do if I want to monitor several databases on the same server and different ORACLE_HOME?

[bignose]

New query

I added this to zabora

'flashrecoveryusage')
sql="select round(sum(percent_space_used)) from v\$flash_recovery_area_usage;"
;;

Might be something worth putting in the "official" release.

[bignose]

Good ole mbx not supported

Okay, so as the zabbix user I ran this

[zabbix@database1 ~]$ /usr/local/sbin/zabbix_agentd -c /etc/zabbix/zabbix_agentd.conf -t oracle[flashrecoveryusage]
oracle [m|ZBX_NOTSUPPORTED]

zabbix unix user is in dba,oinstall,oracle groups.

I am using a dedicated zabbix oracle-user.

The command works fine with the zabora command line utilty. see here:

[zabbix@database1 ~]$ /terida/opt/zabbix/zabora flashrecoveryusage
64

Thoughts?

[bignose]

Ah ha! From the agentd man page, this might solve alot of headaches for alot of people

BUGS
Note that -t and -p switches do not work with user parameters. Use zabbix_get instead.

[bignose]

Okay, 1 more question then I'm putting this down for the day

1: Do they have to be active agent checks? Is normal zabbix agent fine?

I ask because I am using zabbix proxy and i'm not sure if active checks work with the proxy or not.

[stevenfoo]

zabora ZBX_NOTSUPPORTED version 1.5

I have download version 1.2 and also 1.5

I have 2 oracle 10g server running on windows 2003 platform.

I tried to run both version in server A (zabora.nat checkactive SID)
without issue.

But for server B, I get ZBX_NOTSUPPORTED for version 1.5 and no result return for version 1.2.

Server B, I am able to sqlplus and do everything as normal except the script.
Both script are the same in both server A and B.

Anything I miss out? Please advice.

[denisss]

Hi,



I have a problem, Zabor works well in local, but on my server, zabbix said it is 'not supported'.



I have the following line in the conf Zabbix agent :
UserParameter=oracle[*],/home/administrateur/Zabora/zabora \$1 \$2

What's wrong? I really do not see ... Need help

Thanks

[denisss]

Accuracy: Zabora is on the same machine as my Zabbix's server. And this is how I set the item :