There is a bug on Oracle’s JDBC driver.
Oracle has been published a note about here there is an extract:
Applies to:
JDBC – Version: 11.2.0.1 and later [Release: 11.2 and later ]
Information in this document applies to any platform.
Symptoms
A standalone java application connects to a version 10.2.0.4 database via JDBC/Thin 11.2.0.1. The application runs on several machines. The machines have different Unix operating
systems.
Consistently, when trying to connect to the database, the application running on one specific machine fails with:java.sqI.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found
An errorstack trace for ORA-01882 identifies the failing statement.
ksedmp: internal or fatal error
ORA-01882: timezone region not found
Current SQL statement for this session:
ALTER SESSION SET TIME_ZONE=’Africa/Lome’ NLS LANGUAGE = ‘AMERICAN’
NLS TERRITORY=’AMERICA’David has kindly advice a workaround
add the following to run.sh:
“-Duser.timezone=GMT”
Of course you should use your own GMT region
Orabbix 1.2.2 has been released!!
On this release:
- Added the following parameter on main configuration file:
- DefaultUser = <USERNAME>
- DefaultPassword = <PASSWORD>
- <DB_NAME>.ExtraQueryListFile = <relative path to extra query file>
- on query’s properties file I’ve added the following parameter:
- <QUERY_NAME>.WhenNotAlive = <VALUE>
You can download it here
Complete changelog here::
1.2.2
Added the following parameters in the main configuration file:
- DefaultUser = <USERNAME>
- DefaultPassword = <PASSWORD>
- <DB_NAME>.ExtraQueryListFile =
on query’s properties file I’ve added the following parameter:
- <QUERY_NAME>.WhenNotAlive = <VALUE>
with these parameters you can define a default username and password for all databases.
- DefaultUser = <USERNAME>
- DefaultPassword = <PASSWORD>
this default parameter can be overridden using the following pair:
- <DB_NAME>.User and <DB_NAME>.User
It is possible to override only Username or Password.
the following parameter
- <DB_NAME>.ExtraQueryListFile =
adds another custom query to a default query file.
if there are duplicate the ExtraQueryListFile it will override them.
the following parameter
- <QUERY_NAME>.WhenNotAlive = <VALUE>
is used to specify a value or a string to send if a database is not working,
doing so you are going to “clean” the graphs generated in Zabbix with a “set” value.
This fixes the issue introduced by “Zabbix Trapper”:
- if Zabbix don’t receive data the graphs don’t change anymore.
Tags: database, linkedin, monitoring, orabbix, oracle, zabbix
I’m glad to announce that Orabbix has received another award!
This time from win7dwnld.com
Here is an extract from the award mail
″..we found your product as being one of the software products that
captured our attention; so it has been tested by some of our best
colleagues under more circumstances and it has passed some important
criteria that we use in classifying such products (ease of use,
features, user interface, help&support, customization, speed). For all
these results that your product obtained, I decided to grant your
software product with 5 stars Award, the highest ranking that we
carefully grant..″
and… what I can say other than thank you win7downld.com I really appreciate your award!
Tags: database, linkedin, monitor, monitoring, orabbix, oracle, zabbix
DBforBIX 0.4 has been released!
on this release :
- some minor improvement on documentation
- added a new parameter to define a custom period for each queryfile
this software lacks of:
- query for MSSQL Server
- query for DB2
THIS IS A PREVIEW IT’S ONLY 0.4 RELEASE AND IS NOT FULLY TESTED AS A STABLE PRODUCTION RELEASE
You can download DBforBIX here
Tags: database, db2, linkedin, monitoring, MySQL, orabbix, oracle, postgresql, zabbix
Orabbix 1.2.0 has been released!!
On this release:
- modified the extension of all configuration files to remove collision (you will never found overwrote your own config files)
- Now is needed specify the QueryFile for each database
- Implemented Apache Daemon and now Orabbix can run as a service on MS Windows
- Solved an issue about “alive” items
- Changed startup script now jar don’t have more a predefined classpath but it’s generated dynamically
- Fixed a bug on sending to more than 9 zabbix server
You can download it here
NOTE: there are some minor difference between the RC3 and this. The only difference is just a small bug while sending to multiple zabbix server (more than 9).
sending...
