Oracle
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
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.
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
I’ve fixed an issue notified from Ehartmann and tested from Tiagosoares thank you to all my follower for all the help received! Please download and use DBforBIX 0.5.1
Continue reading about DBforBIX 0.5.1 has been released! please use this version!
DBforBIX 0.5 has been released! on this release : some minor improvement on documentation fixed an issue with “AddSpace” parameter set fixed other minor issue this software lacks of: query for MSSQL Server query for DB2 THIS IS A PREVIEW RELEASE AND IS NOT FULLY TESTED AS A STABLE PRODUCTION RELEASE You can […]
