Orabbix
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 am happy to announce that we have a new wiki! Currently only Orabbix‘s manual has been updated and is almost completed, the rest is still a work in progress but it is a good place where start. On the wiki is also a first version of the manual and DBforBIX PostBIX Stay tuned! The […]
The following error: java.sql.SQLException: ORA-24247: network access denied by access control list (ACL) ORA-06512: at “SYS.UTL_INADDR”, line 4 ORA-06512: at “SYS.UTL_INADDR”, line 35 ORA-06512: at line 1 Cause: A new security measure is introduced in Oracle 11g Release 1 (11.1) for the following network-related PL/SQL packages: UTL_TCP, UTL_HTTP, UTL_SMTP, UTL_MAIL, UTL_INADDR, DBMS_LDAP and the HttpUriType […]
Orabbix 1.2.3 has been released! On this release: Fixed the issue with Alive Deeply improved the dynamic recognition of new databases Now you can add and remove databases simply writing them on configuration file. I’ve improved the scalability. and… I want to say THANK YOU Denis Loshakov for all your tests!!! You can download it […]
Continue reading about Orabbix 1.2.3 has been released! now more scalable and dynamic
