Shulou(Shulou.com)06/01 Report--

zabbix uses orabbix to monitor oracle

Orabbix is a Zabbix plug-in for monitoring Oracle database instances. Download Address:

http://www.smartmarmot.com/product/orabbix/download/

Installation and Configuration of Orabbix Plugin

Make sure you install jdk environment, Java version view, No through yum to install JAVA: yum install java

1. Create a new orabbix directory under/opt directory:

[root@oracle orabbix]#mkdir -p /opt/orabbix

(It is recommended to place it in this directory. If you need to change orabbix startup file later, the startup file is written in opt/orabbix directory by default.)

2. Extract the installation file

cd /opt/orabbix unzip orabbix-1.2.3.zip

3. granted this permission

chmod -R a+x /opt/orabbix/

4 Create a config.props file from/opt/orabbix/conf/config.props.sample:

cp /opt/orabbix/conf/config.props.sample /opt/orabbix/conf/config.props

5. Edit the orabbix configuration file as follows

[root@oracle orabbix]#vi conf/config.props

ZabbixServerList=ZabbixServer1

ZabbixServer1.Address=10.0.0.10

ZabbixServer1.Port=10051

#ZabbixServer2.Address=IP_ADDRESS_OF_ZABBIX_SERVER

#ZabbixServer2.Port=PORT_OF_ZABBIX_SERVER

#pidFile

OrabbixDaemon.PidFile=./ logs/orabbix.pid

#frequency of item's refresh

OrabbixDaemon.Sleep=300

#MaxThreadNumber should be >= than the number of your databases

OrabbixDaemon.MaxThreadNumber=100

#put here your databases in a comma separated list

DatabaseList=rac1,rac2

#Configuration of Connection pool

#if not specified Orabbis is going to use default values (hardcoded)

#Maximum number of active connection inside pool

DatabaseList.MaxActive=10

#The maximum number of milliseconds that the pool will wait

#(when there are no available connections) for a connection to be returned

#before throwing an exception, or 'resolve.xml',description =>'resolve acl', principal =>'ZABBIX', is_grant => true, privilege =>'resolve'); exec dbms_network_acl_admin.assign_acl(acl=> 'resolve.xml', host =>'*'); commit;

6. Create an execution file (cp directly)

cp /opt/orabbix/init.d/orabbix /etc/init.d/orabbix

7. Save exit, start orabbix service (make sure you have execute permission)

/etc/init.d/orabbix start

Orabbix service added with system launch:

chkconfig --add orabbix chkconfig --level 345 orabbix on

Frequently Asked Questions:

If the config.props file is not configured, or if it is configured incorrectly, and you cannot connect to the Oracle database correctly with the configured information, the following error message appears

[root@zabbix orabbix]# /etc/init.d/orabbix start

Starting Orabbix service:

[root@zabbix orabbix]# Stopping

java.lang.Exception: ERROR on main - Connections is empty

atcom.smartmarmot.orabbix.Orabbixmon.run(Orabbixmon.java:101)

atcom.smartmarmot.orabbix.bootstrap.main(bootstrap.java:50)

You can view log information to determine the solution

[root@oracle orabbix]# tail -f /opt/orabbix/logs/orabbix.log

At this point, the installation configuration is complete, and you can directly import the module through the web page. Template file:

Orabbix_export_full.xml

Template name generated after import: Template_Oracle

Associate oracle host with imported template Template_Oracle;

Note: The oracle host name configured in zabbix page must be consistent with rac1 and rac2 in DatabaseList=rac1,rac 2 above, and case-sensitive!!!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.