Monitoring a table in Oracle Database using Zabbix

[bruno300]

Hi all!

I already installed zabbix and odbc drivers. I performed a test using isql command and I can connect in my Oracle database . Now I would like to create item and a trigger in Zabbix to be able to monitor a specifies tables that exists in this database.

The trigger I'll leave for later, but if I want to create an item that returns me the result of a query.
ex:
select count (*) from table;

How should I set the zabbix so it shows me the result of this query?
Is it possible ?

I tried some settings as attachment, but does not work.

tks
Bruno

[Colttt]

hmm i think that this must be working.. do you get any errors?

[glebs.ivanovskis]

As I know, it's important to set tons of Oracle specific environment variables (for zabbix user). Your item configuration looks fine.

[bruno300]

hmm i think that this must be working.. do you get any errors?

Hi Colttt!
I did not find logging error on zabbix.

[mark.chan]

What is the warning output from the Zabbix?

[bruno300]

Hi!
The problem was solved! I checked the error output in zabbix (in the web interface). So I installed the package below in linux:
mysql-connector-odbc

Tks a lot!

[mark.chan]

Hi,
Did you get error for this?

Received value [??oB] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]

As I saw you got this " SQLRowCount returns -1 " in the isql