Database

admin on August 28th, 2013

I am happy to announce another new happy user! The Universidade Federal De Santa Caterina (Federal University of Santa Catarina) in the list of our Orabbix, DBforBIX, PostBIX and MySQLBix users. Some time ago I received a e-mail from Gustavo Tonini from the Federal University of Santa Catarina saying that I can place the university […]

Continue reading about Another New Happy User!

admin on June 11th, 2012

There is a bug on zabbix , all messages greather than 10K of size can make hung ( and consequently crash) the zabbix trapper, so please take care about how much data are going to send to Zabbix. My advice is to verify all the queries and analize how many data they return. All Orabbix/DBforBIX user […]

Continue reading about Zabbix has a bug caused from large data received

New features added on this release: Added support for Sybase Anywhere Added support HP Allbase databases those two point are made with the effort of: Andreas Pohl Andreas thank you for all your work!!! fixed other issue introduced by a refactoring. The complete diagram of the supported platform is the following: Please referred to the […]

Continue reading about DBforBIX 0.6 has been released! Now DBforBIX support HP ALLBASE and Sybase Anywhere

I’ve made a script  to create an Orabbix/DBforBIX user with the minimum grants available. CREATE USER ZABBIX IDENTIFIED BY <REPLACE WITH PASSWORD> DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; GRANT ALTER SESSION TO ZABBIX; GRANT CREATE SESSION TO ZABBIX; GRANT CONNECT TO ZABBIX; ALTER USER ZABBIX DEFAULT ROLE ALL; GRANT SELECT ON […]

Continue reading about How-To create on Oracle an Orabbix/DBforBIX user with the minimum privileges.

admin on February 15th, 2012

I’ve received from Johan Nilsson a nice way to check   the failed scheduled jobs . He sent to me a nice query to do that, the query is the following: For Oracle 10g and Oracle 11i: broken_jobs.Query=select * from (  select job_name, count(*) “failures” ,status from dba_scheduler_job_log where log_date > sysdate-1 and status != ‘SUCCEEDED’ […]

Continue reading about How-to track failed scheduled jobs with Orabbix/DBforBIX