Orabbix:"Another way to monitor Oracle reloaded"

[dalle]

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/

[dalle]

Orabbix 0.2 released

In this release there are some correction, i’ve removed some dead code, and in particular added this new item:

* a new query to inspect user locked as LOCKED(TIMED) and EXPIRED(GRACE)

so you can receive a mail if someone lock an user on database.

I consider this item foundamental to keep monitored users on production databases.

I’ve correct the bug that hang orabbix if you have wrong connection parameter.

An last but not the least i’ve added a new parameter on query.props <QUERY_NAME>.NoDataFound= where you can spacify a value that will be used when no data are founded so you can grep this value on trigger.

Download the new version here:

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

http://www.smartmarmot.com/

[dalle]

Orabbix 0.3 released

In this new release :

1. fixed trouble with connection, now if a database is unavailable will be removed and on next loop the daemon try again to get connection and execute query etc..
2. added dynamics configuration features, if you add a database this will be used on next loop.
3. added a new parameter ZabbixDaemon.MaxThreadNumber on config.props

There is only a constraint with thid dynamics configuration the parameter ZabbixDaemon.MaxThreadNumber need be >= of the number of your databases.

this new release is available for donwload here:

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

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

[dalle]

Orabbix 0.4 Released

I’m using this on production servers on RedHat EL 5.3 , with zabbix server 1.6.6, if someone can try on zabbix server 1.8.1 i’ll be happy to receive a feedback.

On this release:

* Modified the version query now return :

- DB_NAME = <dbname> – INSTANCE_NAME = <instancename>

- SERVERNAME = <server.example.com> – SERVERADDRESS = <192.168.0.1>
CATALOG Oracle Database Catalog Views 10.2.0.4.0 VALID
CATJAVA Oracle Database Java Packages 10.2.0.4.0 VALID
CATPROC Oracle Database Packages and Types 10.2.0.4.0 VALID
EXF Oracle Expression Filter 10.2.0.4.0 VALID
JAVAVM JServer JAVA Virtual Machine 10.2.0.4.0 VALID
ORDIM Oracle interMedia 10.2.0.4.0 VALID
OWM Oracle Workspace Manager 10.2.0.4.3 VALID
RUL Oracle Rules Manager 10.2.0.4.0 VALID
XDB Oracle XML Database 10.2.0.4.0 VALID
XML Oracle XDK 10.2.0.4.0 VALID

as you can see i’ve added this information: DB_NAME INSTANCE_NAME SERVERNAME SERVERADDRESS. DB_NAME and INSTANCE_NAME can be different just in case of RAC or DATAGUARD configuration.

* Modified how retrieve the values from resultset now is supported an output with more column and more rows

* Database are removed dynamically this mean that you can add and remove database without restart the daemon.
* Founded a little bug on connection to database, there was a connection that was idle and never used now is fixed.

New release available at:

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

more info here:

http://www.smartmarmot.com/

[dalle]

Orabbix 0.5 released

I've released a new version of Orabbix.
actual improvements are:
1) Added retry on ZabbixSend items and values (max 10 times) , increased socket timeout to 30 sec.
2) Now exception are managed better and is less verbose i've revisited all loglevel to clean the software
Actually this daemon keep monitored 43 Oracle instances on mine production environment, with success

see ya
more info available:

http://rootzone.wordpress.com/

downloadable here:

http://www.smartmarmot.com/

[dalle]

Orabbix 0.6 Released

What's new on this release 0.6:

1. Added an item to monitor Data Guard Error, and the relative trigger.
2. Changed parameter in config.properties from ZabbixDaemon to OrabbixDaemon because are cause of a lot of confusion.
3. Wrote a better documentation

Now the documentation is more or less complete!

download the new release here:

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

More info here:

http://www.smartmarmot.com/

nice day

[untergeek]

I'm having problems with 0.6

Starting Orabbix service:

java.lang.NullPointerException
at java.io.File.<init>(File.java:222)
at com.orabbix.Configurator.<init>(Configurator.java:47)
at main.main(main.java:65)

The orabbix.log file only contained the following:

2010-04-14 13:31:37,652 [main] INFO Orabbix - Starting Orabbix Version 0.6


My config.props looks like this:

ZabbixServer.Address=10.150.0.20
ZabbixServer.Port=10051

#frequency of item's refresh
OrabbixDaemon.Sleep=300
#MaxThreadNumber should be >= than the number of your databases
OrabbixDaemon.MaxThreadNumber=100

#put here your databases in a comma separated list
DatabaseList=CZAB11DB

#Configuration of Connection pool
#Maximum number of active connection inside pool
DatabaseList.MaxActive=10
#The maximum number of milliseconds that the pool will wait 
#(when there are no available connections) for a connection to be returned 

#before throwing an exception, or <= 0 to wait indefinitely. 
DatabaseList.MaxWait=100
DatabaseList.MaxIdle=1

#define here your connection string for each database
CZAB11DB.Url=jdbc:oracle:thin:@czab11db.incert.REDACTED.com:1560:CZAB11DB
CZAB11DB.User=zabbix_dbuser
CZAB11DB.Password=REDACTED

#Query Parameter Files 
OracleQUeryListFile=/opt/orabbix/conf/query.props

[untergeek]

It's amazing what you find when you paste something.

That last line had an erroneous capital U:

OracleQUeryListFile=/opt/orabbix/conf/query.props

I corrected it to:

OracleQueryListFile=/opt/orabbix/conf/query.props

It worked after that.

[untergeek]

Your template is completely empty

<?xml version="1.0"?>
<zabbix_export version="1.0" date="08.04.10" time="18.32">
        <hosts>
                <host name="Template_Oracle">
                        <useip>0</useip>
                        <dns></dns>
                        <ip>0.0.0.0</ip>
                        <port>10050</port>
                        <status>3</status>
                        <groups>
                                <group>Templates</group>
                        </groups>
                </host>
        </hosts>
</zabbix_export>

Do you have an actual export of these items?

[blueunderground]

Orabbix Version 0.6 - XML-Template is empty

Hi Andrea,

thanks for the nice tool ;-)

My Systems...

Oracle-Clientssystem:
RHEL4 Update4
Java version 1.6.0_19
ORACLE RDBMS 10.2.0.3.0
Orabbix Version 0.6

Zabbix-System:
Debian 6
Zabbix Server 1.8.2
Mysql-server 5.1.41

I start orrabbix with your start-script, I guess it looks fine :-). You can see in the logfile.

2010-04-15 09:10:58,130 [main] INFO  Orabbix - Starting Orabbix Version 0.6
 2010-04-15 09:11:00,019 [main] INFO  Orabbix - Connected as ZABBIX
 2010-04-15 09:11:00,026 [main] INFO  Orabbix - --------- on Database -> tlp
 2010-04-15 09:11:42,247 [pool-1-thread-1] INFO  Orabbix - Done with dbJob on database tlp elapsed time 42132 ms
 2010-04-15 09:16:43,962 [pool-1-thread-2] INFO  Orabbix - Done with dbJob on database tlp elapsed time 43826 ms

The orabbix installation-description is good, but how can i integrate it in zabbix. Can you explain it?
The XML-Template is empty :-( Can you fix it ?

Thanks a lot!

blue

[dalle]

You are right,
i don't know why but the last export of mine template is empty.. i'm sorry about.
Just import this one in attach to see graph, item received etc.. let me know if work
Have a nice day
Dalle

[dalle]

Orabbix Version 0.6.1 a little fix on template

This is the same release i've just updated the template_oracle.xml inside Template directory.
I'm sorry but the old one was empty, please us this release instead Orabbix 0.6.

You ca download from here the new release

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

more info here:

http://www.smartmarmot.com/

see ya
Dalle

[blueunderground]

Hi,

thanks, i try it with the new release ;-)

[dalle]

Hi,

thanks, i try it with the new release ;-)

you can just import the template the release is the same

[blueunderground]

okay, i have import it.

What must i do next?

Send the Orabbix-Client the data to the zabbix-server? How can i check it ?