Zabbix monitoring Oracle via the Orabbix plugin

What is Orabbix?

Orabbix is a plug-in designed to monitor Oracle databases for ZABBIX, providing multiple levels of monitoring, including availability and server performance metrics.
It provides an effective mechanism for capturing data from many Oracle instances, providing monitoring and performance metrics for this information. You can then take advantage of the Zabbix reporting feature for all data collected and provide analysis. A pre-defined set of templates is included in the current release, including the initial deployment of alerts and graphics capabilities. However, these can be fine-tuned to meet your needs and data/monitoring requirements.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/42/96/wKiom1PYeBigjHo5AANICWBV8_4495.jpg "title=" Orabbix_architecture.png "alt=" Wkiom1pyebigjho5aanicwbv8_4495.jpg "/>

What can it monitor?

1. database version

2. archive log and production trend analysis

3. trigger, table/process etc hit rate

4. logical I/O performance

5. physical I/O performance

6. PGA

7. sga

8. shared pool

9. sessions

10. database size

Installation configuration

Orabbix's:

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

Also, before installing, make sure you have a JDK environment and use Java version to view the version.

1. Create a new Orabbix directory under the/OPT directory:

#midir-P/opt/orabbix

( recommended in this directory, if you put other directories later need to change the Orabbix startup file Orabbix, the boot file is written by default in the Opt/orabbix directory )

2. Unzip the installation file

#unzip Orabbix-1.2.3.zip

3. Granting permissions

#chmod-R a+x orabbix/

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

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

5. Edit the Orabbix configuration file as follows

#vi Confi/config.props

#comma separed List of Zabbix servers

Zabbixserverlist=zabbixserver #此处的ZabbixServer与以下两行开头对应

zabbixserver.address=172.16.15.79 #zabbixserver地址

zabbixserver.port=10051 #server的端口

#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 thenumber of your databases

orabbixdaemon.maxthreadnumber=100

#put here your databases in a commaseparated list

DATABASELIST=DB1,DB2 #数据库名 (to correspond to the following), multiple databases are separated by commas

#Configuration of Connection Pool

#if not specified Orabbis are going to Usedefault values (hardcoded)

#Maximum number of active Connectioninside pool

databaselist.maxactive=10

#The maximum number of milliseconds thatthe pool would wait

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

#before throwing an exception, or <= 0to wait indefinitely.

databaselist.maxwait=100

Databaselist.maxidle=1

#define here your connection string foreach database

DB1. Url=jdbc:oracle:thin:@172.16.14.80:1521:media #通过jbdc连接 to ensure that the system has a JDK environment

DB1. User=xxxxx #数据库用户名密码

DB1. Password=xxxxx

#Those values Optionals If NotSpecified Orabbix is going to use the general values

DB1. maxactive=10

DB1. maxwait=100

DB1. Maxidle=1

DB1. Querylistfile=./conf/query.props

172.16.15.88.url=jdbc:oracle:thin:@172.16.15.88:1521:media

172.16.15.88.user=yyyyyy

172.16.15.88.password=yyyyyy

#Those values Optionals If NotSpecified Orabbix is going to use the general values

DB2. maxactive=10

DB2. maxwait=100

DB2. Maxidle=1

#DB2. Querylistfile=./conf/query.props #此句指定数据查询文件, can be customized for different databases, different query files, the default is./conf/query.props This file

6. Start the program

Run /opt/orabbix/run.shdirectly, so it's not easy to make mistakes.

Of course, the program can be made into system services, the method is as follows:

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

#/etc/init.d/orabbix start

7. After successful launch, the installation configuration is complete, then the direct import module via Web page access (template placed under /opt/orabbix/template ), monitoring as follows:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/42/97/wKioL1PYf-7yrM7QAAMWICbKZfU019.jpg "title=" 2.png " alt= "Wkiol1pyf-7yrm7qaamwicbkzfu019.jpg"/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/42/96/wKiom1PYftTBP7ZFAAMhMH5Nq-M280.jpg "title=" 3.png " alt= "Wkiom1pyfttbp7zfaamhmh5nq-m280.jpg"/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/42/97/wKioL1PYf-7zONF6AAOKoSJ_eBM316.jpg "style=" float: none; "title=" 4.png "alt=" Wkiol1pyf-7zonf6aaokosj_ebm316.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/42/98/wKioL1PYh17z3jdRAAM6wwS6pnQ857.jpg "style=" float: none; "title=" 5.png "alt=" Wkiol1pyh17z3jdraam6wws6pnq857.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/42/98/wKiom1PYh2vg0ruNAALMT7WukLI310.jpg "style=" float: none; "title=" 7.png "alt=" Wkiom1pyh2vg0runaalmt7wukli310.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/42/98/wKioL1PYiIWArOEwAAKpr2a0Djg006.jpg "style=" float: none; "title=" 8.png "alt=" Wkiol1pyiiwaroewaakpr2a0djg006.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/42/98/wKiom1PYh2zznI5-AAKgXZCLdAk388.jpg "style=" float: none; "title=" 9.png "alt=" Wkiom1pyh2zzni5-aakgxzcldak388.jpg "/>

This article is from the "child is right and wrong" blog, please be sure to keep this source http://lynxme.blog.51cto.com/4424954/1532769