Orabbix:"Another way to monitor Oracle reloaded"

[dalle]

mmm you have update configuration files with the new one?
because there is a little change... that is turned into an hell
i've changed a property abnd now the query file is referenced inside config.props with
QueryListFile
i've done this just to generalize config file for further version of Orabbix, i'm working on postgres version and i've done this change for this reason i didn't like a parameter OracleQueryListFile
I hope that this solve your problem!

You've completely rewritten the sender object. I tried to upgrade from 0.6.1 today and it won't start

        java.lang.NullPointerException
	at java.io.File.<init>(Unknown Source)
	at com.smartmarmot.orabbix.Configurator.<init>(Configurator.java:48)
	at main.main(main.java:76)

I re-iterate: It was 100% fully functional before I attempted an upgrade. When I try to start it, I get this error. Even with DEBUG set, I see nothing but:

2010-07-22 15:13:05,863 [main] INFO  Orabbix - Starting Orabbix Version 0.9.1

Nothing more. Any ideas? This is RHEL 5 with the specified java package (which was fully functional with 0.6.1).

$ /usr/java/jre1.6.0_20/bin/java -version
java version "1.6.0_20"
Java(TM) SE Runtime Environment (build 1.6.0_20-b02)
Java HotSpot(TM) 64-Bit Server VM (build 16.3-b01, mixed mode)

[dalle]

Orabbix 0.9.2 is out!

On this release:
Added more information on error that should be really appreciate in case of problem with configuration files,logfiles are more verbose, or better should be easily understandable.
Added a features that send "0" (zero) or the values NoDataFound when a database is not available so you will see HIT/Ratio and other graps that fall down to zero and don't continue to show a value that is not real.

[untergeek]

I can't download. I get a "with registration you can download here" message. When I try to register, I am denied with a "User registration is currently not allowed."

Please help!

[dalle]

Solved... sorry.... never trust to automatic update of plugins

I can't download. I get a "with registration you can download here" message. When I try to register, I am denied with a "User registration is currently not allowed."

Please help!

[dalle]

Orabbix 0.9.3 out

On this release I’ve added more and more informations on error,
I’ve added default values for:

• MaxWait
• MaxIdle
• MaxActive
• OrabbixDaemon.Sleep
• OrabbixDaemon.MaxThreadNumber (this one is calculated and based from number of monitored databases)

In case that Orabbix can’t read values from config properties file (because are missing or invalid) the daemon will go ahead.

New features:
you can specify for each database different values of:

• MaxWait
• MaxIdle
• MaxActive

specific for each database, so each database can have a different connection pool configuration.
Modified the template excluded all that is not strictly “Orabbix” from template (so i’ve removed cpu performances etc.. and other tests where data don’t come from Orabbix)
downloadable here

[rflribeiro]

Orabbix 0.9.3 out

Congratulations for the excelent work.
I'm having troubles with template import in fedora 13 32bits / zabbix 1.8 installed from fedora repositories.
When i try configuration/export/import/templates/imports and select the template:

* ...
* Added trigger "PGA Alarm on {HOSTNAME}" to host "Template_Oracle"
* Added trigger "Active Session {HOSTNAME}" to host "Template_Oracle"
* Added trigger "Tablespaces on {HOSTNAME}" to host "Template_Oracle"
* Added trigger "User Locked on {HOSTNAME}" to host "Template_Oracle"
* Undefined index: ymin_itemid[/usr/share/zabbix/api/classes/class.cgraph.php:577]
* Undefined index: ymax_itemid[/usr/share/zabbix/api/classes/class.cgraph.php:591]
* Graph [ Logical I/O ]: Incorrect item for Ymax value

I've tried instalation from source, with same results.
Any sugestions?
Thanks in advance.

[dalle]

I know that there are problem with import export on zabbix 1.8.1 if you are using this release please try import on 1.8.2 i don't have trouble/problem with import/export on 1.8.2

[dalle]

Orabbix 0.9.4 Out

I've done just some minor change, added more information if an error occurs and revisited some classes.
more info as usual on my website

http://www.smartmarmot.com

[rflribeiro]

Template Importing Error

Unfortunaly, the problem persists. Same error with Orabbix 0.9.4. Zabbix-server is 1.8.2. MySql is 5.1.48 Source distribution. Apache 2.2. Is there any kind of feature missing?

3351:20100804:093433.136 Starting Zabbix Server. Zabbix 1.8.2 (revision 11211).
3351:20100804:093433.151 **** Enabled features ****
3351:20100804:093433.152 SNMP monitoring: YES
3351:20100804:093433.152 IPMI monitoring: YES
3351:20100804:093433.152 WEB monitoring: YES
3351:20100804:093433.152 Jabber notifications: YES
3351:20100804:093433.152 ODBC: YES
3351:20100804:093433.152 SSH2 support: YES
3351:20100804:093433.152 IPv6 support: YES
3351:20100804:093433.152 **************************
3354:20100804:093433.586 server #1 started [DB Cache]
3361:20100804:093433.592 server #7 started [Trapper]
3363:20100804:093433.593 server #9 started [Trapper]
3365:20100804:093433.594 server #11 started [Trapper]
3362:20100804:093433.594 server #8 started [Trapper]
3364:20100804:093433.595 server #10 started [Trapper]
3367:20100804:093433.595 server #13 started [Alerter]
3366:20100804:093433.595 server #12 started [ICMP pinger]
3368:20100804:093433.595 server #14 started [Housekeeper]
3368:20100804:093433.595 Executing housekeeper
3369:20100804:093433.595 server #15 started [Timer]
3371:20100804:093433.595 server #17 started [HTTP Poller]
3351:20100804:093433.596 server #0 started [Watchdog]
3383:20100804:093433.601 server #19 started [DB Syncer]
3384:20100804:093433.601 server #20 started [Escalator]
3360:20100804:093434.617 server #6 started [Poller. SNMP:YES]
3359:20100804:093434.624 server #5 started [Poller. SNMP:YES]
3356:20100804:093434.629 server #3 started [Poller. SNMP:YES]
3355:20100804:093434.630 server #2 started [Poller. SNMP:YES]
3358:20100804:093434.632 server #4 started [Poller. SNMP:YES]
3382:20100804:093434.637 server #18 started [Discoverer. SNMP:YES]
3370:20100804:093434.639 server #16 started [Poller for unreachable hosts. SNMP:YES]

* Added new application Template_Oracle:Oracle
* Added new item Template_Oracle:alive
* Added new item Template_Oracle:archive
* Added new item Template_Oracle:audit
* Added new item Template_Oracle:dbblockgets
* Added new item Template_Oracle:dbconsistentgets
* Added new item Template_Oracle:dbhitratio
* Added new item Template_Oracle:dbphysicalread
* Added new item Template_Oracle:dbversion
* Added new item Template_Oracle:hitratio_body
* Added new item Template_Oracle:hitratio_sqlarea
* Added new item Template_Oracle:hitratio_table_proc
* Added new item Template_Oracle:hitratio_trigger
* Added new item Template_Oracle:lio_block_changes
* Added new item Template_Oracle:lio_consistent_read
* Added new item Template_Oracle:lio_current_read
* Added new item Template_Oracle:locks
* Added new item Template_Oracle:maxprocs
* Added new item Template_Oracle:maxsession
* Added new item Template_Oracle:miss_latch
* Added new item Template_Oraclega
* Added new item Template_Oraclega_aggregate_target
* Added new item Template_Oraclehio_datafile_reads
* Added new item Template_Oraclehio_datafile_writes
* Added new item Template_Oraclehio_redo_writes
* Added new item Template_Oracleinhitratio_body
* Added new item Template_Oracleinhitratio_sqlarea
* Added new item Template_Oracleinhitratio_table-proc
* Added new item Template_Oracleinhitratio_trigger
* Added new item Template_Oracleool_dict_cache
* Added new item Template_Oracleool_free_mem
* Added new item Template_Oracleool_lib_cache
* Added new item Template_Oracleool_misc
* Added new item Template_Oracleool_sql_area
* Added new item Template_Oraclerocnum
* Added new item Template_Oracle:session
* Added new item Template_Oracle:session_active
* Added new item Template_Oracle:session_inactive
* Added new item Template_Oracle:session_system
* Added new item Template_Oracle:sga_buffer_cache
* Added new item Template_Oracle:sga_fixed
* Added new item Template_Oracle:sga_java_pool
* Added new item Template_Oracle:sga_large_pool
* Added new item Template_Oracle:sga_log_buffer
* Added new item Template_Oracle:sga_shared_pool
* Added new item Template_Oracle:tbl_space
* Added new item Template_Oracle:users_locked
* Added new item Template_Oracle:waits_controfileio
* Added new item Template_Oracle:waits_directpath_read
* Added new item Template_Oracle:waits_file_io
* Added new item Template_Oracle:waits_logwrite
* Added new item Template_Oracle:waits_multiblock_read
* Added new item Template_Oracle:waits_other
* Added new item Template_Oracle:waits_singleblock_read
* Added new item Template_Oracle:waits_sqlnet
* Added trigger "Alive {HOSTNAME}" to host "Template_Oracle"
* Added trigger "No data received from Orabbix" to host "Template_Oracle"
* Added trigger "Archivelog" to host "Template_Oracle"
* Added trigger "Audit on {HOSTNAME}" to host "Template_Oracle"
* Added trigger "Hit Ratio on {HOSTNAME}" to host "Template_Oracle"
* Added trigger "Locks on {HOSTNAME}" to host "Template_Oracle"
* Added trigger "Process Alarm on {HOSTNAME}" to host "Template_Oracle"
* Added trigger "Session Alarm on {HOSTNAME}" to host "Template_Oracle"
* Added trigger "PGA Alarm on {HOSTNAME}" to host "Template_Oracle"
* Added trigger "Active Session {HOSTNAME}" to host "Template_Oracle"
* Added trigger "Tablespaces on {HOSTNAME}" to host "Template_Oracle"
* Added trigger "User Locked on {HOSTNAME}" to host "Template_Oracle"
* Undefined index: ymin_itemid[/usr/share/zabbix/api/classes/class.cgraph.php:577]
* Undefined index: ymax_itemid[/usr/share/zabbix/api/classes/class.cgraph.php:591]
* Graph [ Logical I/O ]: Incorrect item for Ymax value

[dalle]

try with this one is the mine full that is working currently on my zabbix server.

[rflribeiro]

Template Importing Error

Not yet...
it's clear that is not an Orabbix issue.
I think maybe there's something wrong with zabbix installation. I will try again from source under root.
Thanks again.

[yoda]

I also tried with the latest 1.8.3rc3 but the errors when importing orabbix template_oracle.xml remain:

# zabbix_server -V
Zabbix Server v1.8.3rc3 (revision 13783) (2 August 2010)
Compilation time: Aug 5 2010 12:01:42

----

* Undefined index: ymin_itemid[/var/www/zabbix/api/classes/class.cgraph.php:577]
* Undefined index: ymax_itemid[/var/www/zabbix/api/classes/class.cgraph.php:591]
* Graph [ Connection ]: Incorrect item for Ymax value space

Mumble...

[dalle]

also with the last export? that I've published two post ago?

[dalle]

ok I receive the same error on a cleaned installation of zabbix, I'm investigating maybe that is a trouble on export/import of zabbix... i'm working on it

[yoda]

I tried with your last export.
Thank you for your investigation. I try to go deeper too.