Below are some examples of what Orabbix is capable of monitoring:
tar zxf jdk-8u51-linux-x64.tar.gz
mv jdk1.8.0_51//usr/local/
export JAVA_HOME=/usr/local/jdk1.8.0_51
exportCLASSPATH=$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar
export PATH=$JAVA_HOME/bin:$PATH
source/etc/profile
su - root
# mkdir /opt/orabbix
# cp orabbix-1.2.3.zip /opt/orabbix/
# unzip orabbix-1.2.3.zip
Archive: orabbix-1.2.3.zip
creating: conf/
inflating: conf/config.props.sample
inflating: conf/log4j.properties
inflating: conf/log4j.properties.sample
inflating: conf/query.props
inflating: conf/query.props.sample
inflating: conf/query_a.props
inflating: conf/query_a_1.props
inflating: conf/query_b.props
creating: doc/
inflating: doc/CHANGELOG.txt
inflating: doc/Orabbix_Install_v0.6.pdf
inflating: doc/gpl.txt
creating: init.d/
inflating: init.d/orabbix
inflating: install.cmd
creating: lib/
inflating: lib/commons-codec-1.4.jar
inflating: lib/commons-dbcp-1.4.jar
inflating: lib/commons-lang-2.5.jar
inflating: lib/commons-logging-1.1.1.jar
inflating: lib/commons-pool-1.5.4.jar
inflating: lib/hsqldb.jar
inflating: lib/log4j-1.2.15.jar
inflating: lib/ojdbc6.jar
inflating: orabbix-1.2.3.jar
inflating: orabbix.exe
inflating: orabbixw.exe
inflating: run.bat
inflating: run.sh
creating: template/
inflating: template/Orabbix_export_full.xml
inflating: template/Orabbix_export_graphs.xml
inflating: template/Orabbix_export_items.xml
inflating: template/Orabbix_export_triggers.xml
inflating: uninstall.cmd
inflating: conf/query - Copy.props
# cp ./conf/config.props.sample conf/config.props
# cp init.d/orabbix /etc/init.d/
# chmod 755 /etc/init.d/orabbix
# chkconfig orabbix on
# vim ./conf/config.props
ZabbixServerList=ZabbixServer
ZabbixServer.Address=10.0.6.102
ZabbixServer.Port=10051
OrabbixDaemon.PidFile=./logs/orabbix.pid
OrabbixDaemon.Sleep=300
OrabbixDaemon.MaxThreadNumber=100
DatabaseList=PROM
DatabaseList.MaxActive=10
DatabaseList.MaxWait=100
DatabaseList.MaxIdle=1
PROM.Url=jdbc:oracle:thin:@10.1.1.84:1521:prom
PROM.User=ZABBIX
PROM.Password=zabbix
PROM.MaxActive=10
PROM.MaxWait=100
PROM.MaxIdle=1
PROM.QueryListFile=./conf/query.props
- 1 Create User
CREATE USER ZABBIX
IDENTIFIED BY "zabbix"
DEFAULT TABLESPACE SYSTEM
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
– 2 Roles for ZABBIX
GRANT CONNECT TO ZABBIX;
GRANT RESOURCE TO ZABBIX;
ALTER USER ZABBIX DEFAULT ROLE ALL;
– 3 System Privileges for ZABBIX
GRANT SELECT ANY TABLE TO ZABBIX;
GRANT CREATE SESSION TO ZABBIX;
GRANT SELECT ANY DICTIONARY TO ZABBIX;
GRANT UNLIMITED TABLESPACE TO ZABBIX;
GRANT SELECT ANY DICTIONARY TO ZABBIX;
exec dbms_network_acl_admin.create_acl(acl => 'resolve.xml',description => 'resolve acl', principal =>'ZABBIX', is_grant => true, privilege => 'resolve');
exec dbms_network_acl_admin.assign_acl(acl => 'resolve.xml', host =>'*');
commit;
# service orabbix start
# service orabbix status
# tail -f /opt/orabbix/logs/orabbix.log
2016-07-07 21:01:17,597 [main] INFO Orabbix - maxIdleTime=1800000ms
2016-07-07 21:01:17,597 [main] INFO Orabbix - poolTimeout=100
2016-07-07 21:01:17,597 [main] INFO Orabbix - timeBetweenEvictionRunsMillis=-1
2016-07-07 21:01:17,597 [main] INFO Orabbix - numTestsPerEvictionRun=3
2016-07-07 21:01:18,471 [main] INFO Orabbix - Connected as ZABBIX
2016-07-07 21:01:18,474 [main] INFO Orabbix - --------- on Database -> promotio
2016-07-07 21:01:20,679 [pool-1-thread-1] INFO Orabbix - Done with dbJob on database PROM QueryList elapsed time 2161 ms
2016-07-07 21:02:18,552 [pool-1-thread-2] INFO Orabbix - Done with dbJob on database PROM QueryList elapsed time 11 ms
2016-07-07 21:03:20,413 [pool-1-thread-3] INFO Orabbix - Done with dbJob on database PROM QueryList elapsed time 1849 ms