Oracle monitoring

[den_crane]

Thanks for that, but I've already done this:
...
What's wrong ?

Uncomment [#set -x] -> [set -x], try again [./zabora version] and show output.

[felipebare]

[root@oraserver zabbix]# ./zabora version
+ zaboraver=1.2
+ rval=0
+ '[' '' ']'
./zabora: line 10: : No such file or directory
+ case $1 in
+ sql='select banner from v$version where rownum=1;'
+ '[' 'select banner from v$version where rownum=1;' ']'
./zabora: line 238: : No such file or directory
+ rval=0
+ exit 0
[root@oraserver zabbix]#

Thanks.

Felipe.

[den_crane]

./zabora: line 10: : No such file or directory
./zabora: line 238: : No such file or directory

Oh. It's my error.
bash not support symbol <>, replace it !=

10: if [ "$2" != "" ]; then

238: if [ "$sql" != "" ]; then

[felipebare]

Thanks a lot for all the help, i got it work.

But I need to be logged in like oracle user, with root it do not work!
Suggestions ?

Best regards.

[den_crane]

Thanks a lot for all the help, i got it work.

But I need to be logged in like oracle user, with root it do not work!
Suggestions ?

Best regards.

I suggest create a special oracle user -- ZABBIX, for getting information from rdbms.

Look in the attached zabora.zip at the ( http://www.zabbix.com/forum/showpost...0&postcount=11 ) zabbix_user.txt -- script of the creation of this user.

[Coder]

Anybody known as monitored replications and fails jobs?

[SebD]

Hello,

Could you tell where can I download zabora please?

Thanks!

Sébastien

[felipebare]

Hi

The First post has a attached file:

http://www.zabbix.com/forum/attachment.php?attachmentid=593

Best Regards.

Felipe.

[gold_21]

import Items?

Is threre a way to import the items for Oracle using import/export utility?

[steria]

Monitoring serveral oracle instances

Hello,

Zabora works perfectly and is easy to integrate into zabbix agent.

However, what is the best way to monitor several oracle instances?
Is it obligatory to duplicate all items for each instance?

Thank you.

[valerio.crini]

Thanks to author

I write this small note to say thanks to zabora's author it was very time saving for me.
Valerio Crini

[mcgoveze]

Export Elements XML

Is threre a way to import the items for Oracle using import/export utility?

XML for import attached

[vikty]

Zabbix's authorization in Linux

Have anyone had any problem with the permissions on linux?

I have any problem with "sqlplus", because whene I used the script in zabbix-agent It don't work...

I have changed the permission for the zabbix user, but the problem continue...
I don't know...

Agent log

5637:20030104:190836 Run remote command [/etc/zabbix/zabora checkactive | tail -n2 | head -n1] Result [16] [ZBX_NOTSUPPORTED]
5637:20030104:190836 Sending back [ZBX_NOTSUPPORTED]
5639:20030104:190837 Processing request.
5639:20030104:190837 In check_security()
5639:20030104:190837 Requested [oracle.checkact]
/etc/zabbix/zabora: line 264: /opt/oracle/product/10.2.0/db_1/bin/sqlplus: Permission denied
5639:20030104:190837 Before
5639:20030104:190837 Run remote command [/etc/zabbix/zabora checkactive | tail -n2 | head -n1] Result [16] [ZBX_NOTSUPPORTED]

[ngoralski]

Hi

Have you tried to run /opt/oracle/product/10.2.0/db_1/bin/sqlplus only with the zabbix
user account ?

What does it return ?

[vikty]

I have tried, and It works with the shell

[zabbix@dbtest ~]$ zabbix_agentd -c /etc/zabbix/zabbix_agentd.conf -t oracle[version]
Oracle8i Enterprise Edition Release 8.1.7.3.0 - 64bit Production

because I have add zabbix in the group oinstall...

anyway now I am installing the oracle client, in this way any user (I configure only zabbix user...) can use sqlplus cmd...
Before I have tried to use the oracle's sqlplus...