Orabbix:"Another way to monitor Oracle reloaded"

[Keitamax]

mmm right... on 9i don't work this kind of query...
I don't have any more Oracle 9i here to make some test but i think that you can change your query so:

dbversion.Query=select * from v$version where banner like 'Oracle%'
dbversion.Period=720

I know that is "restrictive" but this should work right

OK, works fine now! All eventwait statistics actually work, my mistake sorry.
For DB Size and DB Files Size, I found that they were actually not in query.props.
Thank you!

[dalle]

OK, works fine now! All eventwait statistics actually work, my mistake sorry.
For DB Size and DB Files Size, I found that they were actually not in query.props.
Thank you!

DBSize and DB Fil Size are missing on distribution?
I'm going to check sorry

[Keitamax]

I added some items that could be useful (sga_java_pool_free,sga_java_pool_busy,sga_large_p ool_free,sga_large_pool_busy,sga_shared_pool_free, sga_shared_pool_busy)
feel free to have a look if you wish

[dalle]

you are right for dbsize and dbfilesize you should add on query.props


dbfilesize.Query=select to_char(sum(bytes/1024/1024), 'FM99999999999999990') retvalue from dba_data_files

dbsize.Query=SELECT to_char(sum( NVL(a.bytes/1024/1024 - NVL(f.bytes/1024/1024, 0), 0)), 'FM99999999999999990') retvalue \
FROM sys.dba_tablespaces d, \
(select tablespace_name, sum(bytes) bytes from dba_data_files group by tablespace_name) a, \
(select tablespace_name, sum(bytes) bytes from dba_free_space group by tablespace_name) f \
WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = f.tablespace_name(+) \
AND NOT (d.extent_management like 'LOCAL' AND d.contents like 'TEMPORARY')

[dalle]

I added some items that could be useful (sga_java_pool_free,sga_java_pool_busy,sga_large_p ool_free,sga_large_pool_busy,sga_shared_pool_free, sga_shared_pool_busy)
feel free to have a look if you wish

cool you have exactly understood how it work!
and thanks for queryes

[jiska]

Orabbix rereads query.props instead of sending items


2011-07-29 12:24:24,053 [main] INFO Orabbix - Starting Orabbix Version 1.2.0
(...)
2011-07-29 12:24:27,131 [main] DEBUG Orabbix - Loaded the properties from ./conf/query.props
2011-07-29 12:24:27,178 [main] DEBUG Orabbix - Loaded the properties from ./conf/query.props

-> It's reading the query.props twice, why?

2011-07-29 12:24:27,214 [pool-1-thread-1] DEBUG Orabbix - Starting dbJob on database my_db QueryList
2011-07-29 12:24:27,226 [pool-1-thread-1] DEBUG Orabbix - Actual query is dbsizeNextrun 2011/07/29 13:24:27 on database=my_db Period=60
2011-07-29 12:25:27,224 [main] DEBUG Orabbix - Waking up Goood Morning

-> main interrupts pool-1-thread-1 after the first query...

2011-07-29 12:25:27,260 [main] DEBUG Orabbix - Ready to run DBJob for dbname ->my_db
2011-07-29 12:25:27,261 [pool-1-thread-2] DEBUG Orabbix - Starting dbJob on database my_db QueryList
...
2011-07-29 12:25:31,392 [pool-1-thread-2] DEBUG Orabbix - Actual query is tbl_spaceNextrun 2011/07/29 12:29:27 on database=my_db Period=5
2011-07-29 12:26:27,260 [main] DEBUG Orabbix - Waking up Goood Morning

-> this time, main interrupts pool-1-thread-2 after 2/3 of the queries.

2011-07-29 12:26:27,292 [main] DEBUG Orabbix - Ready to run DBJob for dbname ->my_db
2011-07-29 12:26:27,293 [pool-1-thread-3] DEBUG Orabbix - Starting dbJob on database my_db QueryList
(...)
2011-07-29 12:26:28,767 [pool-1-thread-3] DEBUG Orabbix - Item retrieved 15 on database my_db
2011-07-29 12:26:28,767 [pool-1-thread-3] DEBUG Orabbix - dbname my_db sending item userconn value 20
2011-07-29 12:26:28,767 [pool-1-thread-3] DEBUG Orabbix - dbname my_db sending item waits_controfileio value 246562
2011-07-29 12:26:28,767 [pool-1-thread-3] DEBUG Orabbix - dbname my_db sending item waits_directpath_read value 2242
2011-07-29 12:26:28,767 [pool-1-thread-3] DEBUG Orabbix - dbname my_db sending item waits_file_io value 0
2011-07-29 12:26:28,767 [pool-1-thread-3] DEBUG Orabbix - dbname my_db sending item waits_latch value 246562
2011-07-29 12:26:28,767 [pool-1-thread-3] DEBUG Orabbix - dbname my_db sending item waits_logwrite value 67567
2011-07-29 12:26:28,767 [pool-1-thread-3] DEBUG Orabbix - dbname my_db sending item waits_multiblock_read value 25432
2011-07-29 12:26:28,767 [pool-1-thread-3] DEBUG Orabbix - dbname my_db sending item waits_singleblock_read value 253690
2011-07-29 12:26:28,767 [pool-1-thread-3] DEBUG Orabbix - dbname my_db sending item hitratio_trigger value 95.31772575250836120401337792642140468227
2011-07-29 12:26:28,767 [pool-1-thread-3] DEBUG Orabbix - dbname my_db sending item lio_block_changes value 43189618
2011-07-29 12:26:28,767 [pool-1-thread-3] DEBUG Orabbix - dbname my_db sending item lio_consistent_read value 10452752
2011-07-29 12:26:28,767 [pool-1-thread-3] DEBUG Orabbix - dbname my_db sending item waits_other value 2293482
2011-07-29 12:26:28,767 [pool-1-thread-3] DEBUG Orabbix - dbname my_db sending item waits_sqlnet value 213988
2011-07-29 12:26:28,767 [pool-1-thread-3] DEBUG Orabbix - dbname my_db sending item users_locked value none
2011-07-29 12:26:28,767 [pool-1-thread-3] DEBUG Orabbix - dbname my_db sending item uptime value 63521


Only this last 1/3 of the queries is sent to the zabbix server
The other values don't appear in zabbix: their values during thread-1 and thread-2 were correct, but they weren't sent.
Reducing the queries in query.props seems to solve my problem, but that's no option for me.

The complete log file can be found here for more information.

[483]

someone know how to change the zabbix_agentd.conf to monitor the oracle,how to open the orabbix

[483]

I’ve released my first release of orabbix.

Orabbix is a plug-in for zabbix, and more or less do the same work of check_ora BUT has this pros (compared with shell script):

* connection pool
* use log4j
* is completely in java

so pratically:

* you don’t need more to install an oracle client (simply download this package and install)
* you will neve see listener.log on oracle server that grown anc ocntinue to grown (because in check_ora for every query there is a new connection) here everything is solved with connection pooling
* you have a log wrote with log4j
* is wrote in java so can run on windows and linux machine without troubles

This is my first initial release so please give any feedback to me and in particular this is tested on redhat EL 5.3 and with java-1.6.0-openjdk.x86_64 prm package it’s tested also with java jre 1.6.0_10, actually work with Zabbix server 1.6.6.

This initial release is downloadable here:

https://sourceforge.net/projects/orabbix/

more info here:
http://www.smartmarmot.com/

how to write the zabbix_agentd.conf file to monitor the oracle

[Keitamax]

everything is explained here : http://www.smartmarmot.com/product/o...l-instruction/

[483]

how to write the zabbix_agentd.conf file to monitor the oracle

I have install orrabbix ,but i can't get message to monitor the oracle.how to use orabbix to monitor it.


2011-08-02 09:42:07,146 [pool-1-thread-22] INFO Orabbix - Done with dbJob on database orcl QueryList elapsed time 810 ms
2011-08-02 09:43:07,879 [pool-1-thread-23] INFO Orabbix - Done with dbJob on database orcl QueryList elapsed time 710 ms
2011-08-02 09:44:09,646 [pool-1-thread-24] INFO Orabbix - Done with dbJob on database orcl QueryList elapsed time 492 ms



the log message is above

[Santyaga]

tablespace

First of all, thanx dalle for orabbix.
I've made it work at last

I change tbl_space query:

was
       '- Perc->',trunc((d.tbs_size-nvl(s.free_space, 0))*100/d.tbs_maxsize) 
now
       '- Perc->',trunc((d.tbs_size-nvl(s.free_space, 0))*100/d.tbs_size)

Second question. Why DB File Size and DB Size measurement unit is KMB? May be G will be more correct?

Sorry for my english ;(

[ferri]

Hi everyone

First of all, thank you for this tool that I hope will work fine with me.

I have a problem, I followed the installation instructions on the smartmarmot web site. (creation of user zabbix, download, exctract, configure, start) but it doesn't work.

I installed Orabbix on my Zabbix server (Ubuntu Server)

Here is my config.props file


I didn't configure the query.props file because I don't understand how to do it and for what purpose.

And when I want to start the service, I have some errors:
- /etc/init.d/orabbix start ---> .: 10: Can't open /etc/rc.d/init.d/functions
- /opt/orabbix/run.sh ---> /opt/orabbix/run.sh: line 1: java : commande introuvable

Can someone help me?
Thanks for advance

[Santyaga]

I have a problem, I followed the installation instructions on the smartmarmot web site. (creation of user zabbix, download, exctract, configure, start) but it doesn't work.

I installed Orabbix on my Zabbix server (Ubuntu Server)

Here is my config.props file

I didn't configure the query.props file because I don't understand how to do it and for what purpose.

And when I want to start the service, I have some errors:
- /etc/init.d/orabbix start ---> .: 10: Can't open /etc/rc.d/init.d/functions
- /opt/orabbix/run.sh ---> /opt/orabbix/run.sh: line 1: java : commande introuvable

Can someone help me?
Thanks for advance

Seems java not installed on your server, or script can't find it.
First of all, in shell, run this command: ls /usr/lib/jvm/
If there nothing, you must install java.

Strongly recommend you clear domain, login and password data from your screen.

[ferri]

OK, thank you
I changed my picture but It's just for a test environment...

With this command line, I saw that there is no directory "jvm" in /usr/lib. I have to install java? How to do that in command line?

Thanks

[Santyaga]

sudo aptitude install sun-java6-jre