Hey guys
Im using Zabbix 1.8.2 and Orabbix 1.0.4.
Installed Orabbix to try and see if it could be useful for us but im kinda stuck.
Orabbix config looks like this:
ZabbixServerList=ZabbixServer1
ZabbixServer1.Address=10.11.0.105
ZabbixServer1.Port=10051
DatabaseList=DB1
DB1.Url=jdbc
racle:thin:@localhost:1521:BO1
DB1.User=ZABBIX
DB1.Password=XXXXX
from /orabbix.log
In Zabbix i got a host created as ltgs1, regular items from the template_oracle works but the stuff from orabbix isnt.
Our DB guy installed the acl package and its working and put in this:
Im using Zabbix 1.8.2 and Orabbix 1.0.4.
Installed Orabbix to try and see if it could be useful for us but im kinda stuck.
Orabbix config looks like this:
ZabbixServerList=ZabbixServer1
ZabbixServer1.Address=10.11.0.105
ZabbixServer1.Port=10051
DatabaseList=DB1
DB1.Url=jdbc
racle:thin:@localhost:1521:BO1DB1.User=ZABBIX
DB1.Password=XXXXX
from /orabbix.log
Code:
2010-09-28 16:40:02,092 [pool-1-thread-5] DEBUG Orabbix - dbname DB1 sending item sga_java_pool value 16 All queries get the values they should. Orabbix - dbname DB1 sending item dbversion value – DB_NAME = <b>bo</b> - INSTANCE_NAME = <b>bo1</b> <br />- SERVERNAME = <b>ltgs1</b> - SERVERADDRESS = <b>127.0.0.1</b> <br /> CATALOG Oracle Database Catalog Views 11.1.0.7.0 VALID <br /> CATJAVA Oracle Database Java Packages 11.1.0.7.0 VALID <br /> CATPROC Oracle Database Packages and Types 11.1.0.7.0 VALID <br /> EM Oracle Enterprise Manager 11.1.0.7.0 VALID <br /> EXF Oracle Expression Filter 11.1.0.7.0 VALID <br /> JAVAVM JServer JAVA Virtual Machine 11.1.0.7.0 VALID <br /> OWM Oracle Workspace Manager 11.1.0.7.0 VALID <br /> RAC Oracle Real Application Clusters 11.1.0.7.0 VALID <br /> XDB Oracle XML Database 11.1.0.7.0 VALID <br /> XML Oracle XDK 11.1.0.7.0 VALID <br />
Our DB guy installed the acl package and its working and put in this:
Code:
BEGIN;
DBMS_NETWORK_ACL_ADMIN.create_acl (
acl => 'zabbix_acl_file.xml',
description => 'ACL for ORABBIX plugin for ZABBIX',
principal => 'ZABBIX',
is_grant => TRUE,
privilege => 'connect',
start_date => SYSTIMESTAMP,
end_date => NULL);
COMMIT;
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.add_privilege (
acl => 'zabbix_acl_file.xml',
principal => 'ZABBIX',
is_grant => TRUE,
privilege => 'resolve',
position => NULL,
start_date => NULL,
end_date => NULL);
COMMIT;
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.assign_acl (
acl => 'zabbix_acl_file.xml',
host => 'localhost',
lower_port => NULL,
upper_port => NULL);
COMMIT;
END;
/
Comment