Orabbix:"Another way to monitor Oracle reloaded"

[Lurnux]

I have all of Orabbix graphs working but Memory Utilization is not getting data. From latest data only memory related value is Pool free mem. What am i missing here?

[thiagomz]

Hi guys, I am getting the following error when I have a database over 1TB.


Em Orabbix.log

2015-09-29 13:26:50,156 [pool-1-thread-1] DEBUG Orabbix - Actual query is dbsizeNextrun 2015/09/29 14:26:47 on database=MYORASERVER Period=60

2015-09-29 13:26:50,464 [pool-1-thread-1] DEBUG Orabbix - I'm going to return 2135736188928 for query dbsize on database=MYORASERVER

2015-09-29 13:26:51,118 [pool-1-thread-1] DEBUG Orabbix - dbname MYORASERVER sending item dbsize value 2135736188928

On Zabbix Server.log

1508:20150929:143104.690 error reason for "MYORASERVER:dbsize" changed: Type of received value [2135746674688.000000] is not suitable for value type [Numeric (float)]

On Last Data I have no values .. empty ...

Any Idea ?

Zabbix Server 2.4.5

[Lanc]

Hi All! I upgrade zabbix node1+node2 configuration to zabbix server(old node1) + zabbix proxy(old node2). All versions 2.0.9 up to 2.4.6.
Node2 hosts migrate to main zabbix server(old node1).
I have not data from orabbix installed on zabbix proxy through proxy. If I change zabbix server address in config.props from proxy IP to main server IP and change host property to "No Proxy" - All is working.
In orabbix log I have "received OK". "Allowed hosts" is empty.
What’s wrong?
Are there examples working configuration orabbix through zabbix proxy 2.4 version?

Thank you

[bpc-ruslan]

Orabbix missing data.

Hi.

Orabbix missing data sometime.

For example conf file has Query period 5 minutes.
Here is the query:

select count(1) from bpc_transaction_history where state = 'ECP_CONFIRM_CALL_FAIL' and date_time > sysdate - 5 / (24 * 60)

We got data at 31.05.2016 14:27:00, exact time is 14:27:47,101000

SQL> select count(1),trunc(date_time,'mi') from bpc_transaction_history where state = 'ECP_CONFIRM_CALL_FAIL' and date_time between to_date('31-05-2016 00:00:00','dd-mm-yyyy hh24:mi:ss') and to_date('01-06-2016 00:00:00','dd-mm-yyyy hh24:mi:ss') group by trunc(date_time,'mi');
 
  COUNT(1) TRUNC(DATE_TIME,'MI')
---------- ---------------------
         1 31.05.2016 14:27:00

But zabbix got 0 in return.

2016-05-31 14:32:58 0
2016-05-31 14:27:57 0
2016-05-31 14:22:57 0


Here is the log file.

	
2016-05-31 14:27:57,641 [pool-1-thread-123] INFO  Orabbix - Done with dbJob on database EPR QueryList elapsed time 8306 ms
2016-05-31 14:32:58,315 [pool-1-thread-66] INFO  Orabbix - Done with dbJob on database EPR QueryList elapsed time 8839 ms
2016-05-31 14:37:57,800 [pool-1-thread-159] INFO  Orabbix - Done with dbJob on database EPR QueryList elapsed time 8147 ms
2016-05-31 14:42:58,623 [pool-1-thread-169] INFO  Orabbix - Done with dbJob on database EPR QueryList elapsed time 8825 ms
2016-05-31 14:47:58,391 [pool-1-thread-2] INFO  Orabbix - Done with dbJob on database EPR QueryList elapsed time 8448 ms

What can cause this problem? I happens often

[vlucian]

2 issues with orabbix parameters in query.props

Hi all,
I'm trying to 'disable' a query by using customQueryItemName.ACTIVE=false and seems it doesn't work: that query is still triggered.

Another problem is with usage of RaceConditionQuery and RaceConditionValue, same, looks it doesn't work. I have a query:

EOD_IE.Query=select count(*) from...

and I tried to use:

EOD_IE.RaceConditionQuery=SELECT case when (to_char(sysdate,'dd-mm-yy') not in (SELECT holidaydate .... then 'TRUE' else 'FALSE' end from dual

and then:

EOD_IE.RaceConditionValue=TRUE
So the EOD_IE query should run as long as RaceConditionQuery return TRUE. If I run RaceConditionQuery in sqldeveloper it's working properly returning TRUE or FALSE (it's mainly based on execution time) but I keep seeing data in "Latest data" for the EOD_IE query even if it's suppose to be stopped (when RaceConditionQuery is returning FALSE).

Any ideas?
Thanks

[vlucian]

It looks like there is a bug in that version (1.2.3) .
in configurator.java
Query q = new Query(query, _queryName, noDataFound, whenNotAlive, raceCondQuery, raceCondValue, period, active, trim, space, excludeColumns, raceExcludeColumns);

and query is defined in query.java like


public Query(String _query, String _name, String _nodata, String _rccondq, String _rccondval, String _whennotalive, int _period, Boolean _active, Boolean _trim, Boolean _space, List<Integer> _excludeColumns, List<Integer> _raceExcludeColumns)

so the whenNotAlive parameter is in the wrong position. Solved after recompiling.

[zielart]

I've prepared latest working howto on this site - works with oracle 12c and zabbix 3.4 https://zielart.blogspot.com/2018/09...ase-using.html

[yokesh]

Hello,
I have installed orabbix 1.2.3 to monitor Oracle 12.1 and i am using zabbix5.
i am getting the below details on orabbix.log file

2020-07-30 10:39:38,971 [pool-1-thread-3] DEBUG Orabbix - dbname orcl121 sending item waits_multiblock_read value 5261
2020-07-30 10:39:38,971 [pool-1-thread-3] DEBUG Orabbix - dbname orcl121 sending item waits_singleblock_read value 5143436
2020-07-30 10:39:38,971 [pool-1-thread-3] DEBUG Orabbix - dbname orcl121 sending item hitratio_trigger value 99.74508355594555118044640923252933760601
2020-07-30 10:39:38,971 [pool-1-thread-3] DEBUG Orabbix - dbname orcl121 sending item lio_block_changes value 128556344
2020-07-30 10:39:38,971 [pool-1-thread-3] DEBUG Orabbix - dbname orcl121 sending item lio_consistent_read value 2535723157
2020-07-30 10:39:38,971 [pool-1-thread-3] DEBUG Orabbix - dbname orcl121 sending item waits_other value 101904381
2020-07-30 10:39:38,971 [pool-1-thread-3] DEBUG Orabbix - dbname orcl121 sending item waits_sqlnet value 10057787
2020-07-30 10:39:38,971 [pool-1-thread-3] DEBUG Orabbix - dbname orcl121 sending item users_locked value none
2020-07-30 10:39:38,971 [pool-1-thread-3] DEBUG Orabbix - dbname orcl121 sending item uptime value 6772117

post this i am getting the below error on orabbix.log file.

2020-07-30 10:39:38,973 [pool-1-thread-3] WARN Orabbix - received unexpected response '' for key 'alive'
2020-07-30 10:39:38,973 [pool-1-thread-3] DEBUG Orabbix - sending <req><host>b3JjbDEyMQ==</host><key>T3JhYmJpeC5WZXJzaW9u</key><data>T3JhYmJpeCBWZXJzaW9uIDEuMi4zIA==</data></req>
2020-07-30 10:39:38,974 [pool-1-thread-3] DEBUG Orabbix - received
2020-07-30 10:39:38,974 [pool-1-thread-3] WARN Orabbix - received unexpected response '' for key 'Orabbix.Version'
2020-07-30 10:39:38,974 [pool-1-thread-3] DEBUG Orabbix - sending <req><host>b3JjbDEyMQ==</host><key>ZGF0ZXRpbWU=</key><data>MDctMzAtMjAyMCAxMDo0MToxNw==</data></req>
2020-07-30 10:39:38,974 [pool-1-thread-3] DEBUG Orabbix - received
2020-07-30 10:39:38,975 [pool-1-thread-3] WARN Orabbix - received unexpected response '' for key 'datetime'

can you kindly help ?

[gofree]

might be a necrobumb but it seems that dbforbix is not atvivelly developped and not working with ZBX5 , ZBX4 due the zabbix protocol changes or any other reason?

[zaicnupagadi]

might be a necrobumb but it seems that dbforbix is not atvivelly developped and not working with ZBX5 , ZBX4 due the zabbix protocol changes or any other reason?

gofree Since my last conversation with Andrea Dalle Vacche he is not upgrading the product, but at the same time he told that the source code is on SourceForge - so feel free to improve/extend it

[gofree]

I was just curious because I've seen it recently somewhere and I guessed its "dead end" - thanks for clarification