DB Monitor cannot connect to Oracle

[cqxiak]

Database monitoring is not working for oracle DB. once item configured, I can found the request to oracle via odbc just hanged at below step:
-----------------------------
[ODBC][15921][1410415995.302177][SQLConnect.c][3727]
Entry:
Connection = 0x11561e0
Server Name = [ORA_T][length = 5 (SQL_NTS)]
User Name = [][length = 0 (SQL_NTS)]
Authentication = [][length = 0 (SQL_NTS)]
UNICODE Using encoding ASCII 'UTF-8' and UNICODE 'UCS-2LE'
----------------------------

and connect to oracle via isql is working well. anyone have related experience on this? thanks very much

[syndeysider]

DBforBix

Although this doesn't answer your question directly, there is a workaround.

Check out : http://www.smartmarmot.com/product/dbforbix/

I switched to the above as I didn't want to pay the license fee for the Oracle DSN Driver and didn't want to pollute my Zabbix Infrastructure with the Oracle client + java etc.

DBforBIX works great and I've handed over the dboracle.query file to my DBA's who are in charge of creating items/triggers for the various Databases they have.

[cqxiak]

Thanks all. I have fixed this issue. maybe not the correct one, but it works.

this issue was found when using UnixODBC with version 2.3.2, but version 2.3.0 is working well.

[akbar415]

Thanks all. I have fixed this issue. maybe not the correct one, but it works.

this issue was found when using UnixODBC with version 2.3.2, but version 2.3.0 is working well.

How you configure your unixODBC to connect to oracle ?
I can make this by set the environment variable $TWO_TASK, but is there another way?