orabbix - "no data" problem - HELP!

[Andrzej]

Hello everyone,
I have problem with orabbix and I'm run out of ideas how to resolve it. My environment is:
- zabbix server (downloaded virtual appliance v2.0.5)
- oracle server 11r2 running on Scientific Linux 6.3 64bit with zabbix agent v2.0.5 installed from rpm - it works fine.
I configured config.props to connect to my oracle server - it also works fine:

(output from orabbix.log)

2013-04-15 13:55:43,760 [main] INFO Orabbix - Starting Orabbix Version 1.2.1
2013-04-15 13:55:43,785 [main] INFO Orabbix - Orabbix started with pid:7221
2013-04-15 13:55:43,785 [main] INFO Orabbix - PidFile -> ./logs/orabbix.pid
2013-04-15 13:55:43,974 [main] INFO Orabbix - DB Pool created: org.apache.commons.dbcp.datasources.SharedPoolData Source@2536e3
2013-04-15 13:55:43,974 [main] INFO Orabbix - URL=jdbcracle:thin:@10.100.1.24:1521:ORCL
2013-04-15 13:55:43,974 [main] INFO Orabbix - maxPoolSize=10
2013-04-15 13:55:43,974 [main] INFO Orabbix - maxIdleSize=1
2013-04-15 13:55:43,974 [main] INFO Orabbix - maxIdleTime=1800000ms
2013-04-15 13:55:43,974 [main] INFO Orabbix - poolTimeout=100
2013-04-15 13:55:43,974 [main] INFO Orabbix - timeBetweenEvictionRunsMillis=-1
2013-04-15 13:55:43,974 [main] INFO Orabbix - numTestsPerEvictionRun=3
2013-04-15 13:55:44,657 [main] INFO Orabbix - Connected as ZABBIX
2013-04-15 13:55:44,659 [main] INFO Orabbix - --------- on Database -> orcl
2013-04-15 13:55:44,720 [pool-1-thread-1] INFO Orabbix - Done with dbJob on database DB1 QueryList elapsed time 40 ms

My problem is that I can't get any data back from oracle server. When I test queries from query.props file directly into sqlplus or sqldeveloper everything is ok, but orabbix get ORA-01403 error. I checked it using wireshark sniffing packets on 1521 port on my oracle server. For example this is a part of a packet with request:

0000 03 5e 00 02 80 21 00 01 01 4b 01 01 0d 00 00 04 .^...!...K......
0010 ff ff ff ff 01 0a 04 7f ff ff ff 00 00 00 00 00 ................
0020 00 00 00 00 00 00 01 00 00 00 00 00 73 65 6c 65 ............sele
0030 63 74 20 63 6f 75 6e 74 28 2a 29 20 66 72 6f 6d ct count(*) from
0040 20 76 24 73 65 73 73 69 6f 6e 20 77 68 65 72 65 v$session where
0050 20 54 59 50 45 21 3d 27 42 41 43 4b 47 52 4f 55 TYPE!='BACKGROU
0060 4e 44 27 20 61 6e 64 20 73 74 61 74 75 73 3d 27 ND' and status='
0070 41 43 54 49 56 45 27 01 01 00 00 00 00 00 00 01 ACTIVE'.........
0080 01 00 00 00 00 00 ......

and this is a part of a packet with response:

0000 10 17 c9 4d ba d0 8a 76 f3 ff 41 7a af 31 d2 dc ...M...v..Az.1..
0010 65 83 78 71 04 0f 09 28 28 01 16 01 01 51 02 00 e.xq...((....Q..
0020 00 00 01 16 00 00 00 00 00 00 00 01 08 01 08 08 ................
0030 43 4f 55 4e 54 28 2a 29 00 00 00 00 01 07 07 78 COUNT(*).......x
0040 71 04 0f 0d 3b 2d 00 02 1f e8 01 02 01 02 00 06 q...;-..........
0050 22 01 01 00 01 0a 00 00 00 07 02 c1 04 08 01 06 "...............
0060 03 12 6c 35 00 01 02 00 00 00 00 00 00 04 01 1e ..l5............
0070 01 01 02 05 7b 00 00 01 02 01 15 03 00 00 00 00 ....{...........
0080 00 00 00 00 00 00 00 00 00 00 01 01 00 00 00 00 ................
0090 19 4f 52 41 2d 30 31 34 30 33 3a 20 6e 6f 20 64 .ORA-01403: no d
00a0 61 74 61 20 66 6f 75 6e 64 0a ata found.

As I mentioned I have no problem to execute this query being logged as a zabbix user into sqlplus:
SQL> select count(*) from v$session where TYPE!='BACKGROUND' and status='ACTIVE';

COUNT(*)
----------
1
What is wrong with orabbix...? Thanks in advance for any help.
Best Regards
Andrzej

P.S. firewalls and SELinux or other s...t are disabled on zabbix server and oracle server

[Narcomed]

Post is old but...

You can post more information with debug in log file.

log4j.properties

Change

# Set root logger level to DEBUG and its only appender to Orabbix.
log4j.rootLogger=INFO , Orabbix

for

# Set root logger level to DEBUG and its only appender to Orabbix.
log4j.rootLogger=DEBUG , Orabbix

and reload orabbix service and check in the orabbix.log for more information.