Zabbix monitors oracle databases

Zabbix monitors oracle databases

Orabbix description Orabbix is a plugin designed to work with Zabbix Enterprise Monitor to provide multi-tiered monitoring, performance and availability reporting and measurement for Oracle Databases, along with server performance metrics.
It provides an effective tive mechanism to acquire data from numerous Oracle instances, and in turn provides this information for monitoring and performance metrics to your Zabbix server. you can then utilize the reporting capabilities of Zabbix for all data collected, and provide analysis such as graphs and service level agreement metrics for stakeholders.
The current distribution contains a set of pre-defined templates which in1_ate alerting and graphing capabilities from initial deployment. However these can be fine tuned to suit your needs and data/monitoring requirements.

Orabbix is a multi-layer monitoring plug-in designed for zabbix. It can be used to monitor the performance and availability of Oracle databases and the running metrics of services. It provides an effective mechanism to obtain data from numerous oracle instances, and then provides oracle instance data and performance indicators to the zabbix server. Zabbix collects all the data and provides analysis results, shape, and service-level indicators. You can take full advantage of this monitoring information. The current release version contains a set of predefined templates, including alarm and graphic functions during initial deployment. These can well meet your data/monitoring needs.
Monitored object

Below are some examples of what Orabbix is capable of monitoring:

• DB Version (I. e. Validity of package)
  
• Archiving (Archive log production with trend analysis)
  
• Event Waits (Files I/O, single block read, multi-block read, direct path read, SQLNet Messages, Control file I/O, Log Write)
• Hit Ratio (Hit Ratio on Triggers, Tables/Procedures, SQL Area, Body)
• Logical I/O (Server performance on Logical I/O of: Current Read, Consistent Read, Block Change)
• Physical I/O (Redo Writes, Datafile Writes, Datafile Reads)
• PGA
• SGA (In particle; Fixed Buffer, Java Pool, Large Pool, Log Buffer, Shared Poolm Buffer Cache)
• Shared Pool (Pool Dictionary Cache, Pool Free Memory, Library Chache, SQL Area, MISC .)
• Pin Hit Ratio (Oracle library cache pin are caused by contention with the library cache, the area used to store SQL executables for re-use)
• Sessions/Processessize of database really used space and of Filesize)
• Sessions (Active Sessions, Inactive Sessions, System Sessions)
• DBSize/DBFileSize (DBSize size of database really used space and of Filesize)

Install Orabbix Server @ Zabbix Server 1. Configure JAVA

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

2. Download https://sourceforge.net/projects/orabbix/
The downloaded file is orabbix-1.2.3.zip.
3. Install Orabbix

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

4. Configure orabbix. Make sure that the red part matches.

# Vim./conf/config. props

ZabbixServerList = ZabbixServer

ZabbixServer. Address = 10.0.6.102

ZabbixServer. Port = 10051

OrabbixDaemon. PidFile =./logs/orabbix. pid

OrabbixDaemon. Sleep = 300

Orabbian daemon. MaxThreadNumber = 100

DatabaseList = PROM

DatabaseList. MaxActive = 10

Database List. 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. Max wait = 100

PROM. MaxIdle = 1

PROM. QueryListFile =./conf/query. props

The jdbc connection format is as follows: jdbc: oracle: thin :@::


Orabbix client configuration @ Oracle DB 1. Create zabbix users

-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;

2. Run the following command to add the acl list for oracle 11g:

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;

Start Orabbix and configure zabbix to display @ Zabbix Server
1. Start orabbix

# Service orabbix start

View status

# Service orabbix status

View logs

# Tail-f/opt/orabbix/logs/orabbix. log

21:01:17, 597 [main] INFO Orabbix-maxIdleTime = 1800000 ms

21:01:17, 597 [main] INFO Orabbix-poolTimeout = 100

21:01:17, 597 [main] INFO Orabbix-timeBetweenEvictionRunsMillis =-1

21:01:17, 597 [main] INFO Orabbix-numTestsPerEvictionRun = 3

21:01:18, 471 [main] INFO Orabbix-Connected as ZABBIX

21:01:18, 474 [main] INFO Orabbix---------- on Database-> promotio

21:01:20, 679 [pool-1-thread-1] INFO Orabbix-Done with dbJob on database PROM QueryList elapsed time 2161 MS

21:02:18, 552 [pool-1-thread-2] INFO Orabbix-Done with dbJob on database PROM QueryList elapsed time 11 MS

21:03:20, 413 [pool-1-thread-3] INFO Orabbix-Done with dbJob on database PROM QueryList elapsed time 1849 MS

2. Add a monitoring host to zabbix
Import orabbix template Orabbix_export_full





Add host

Note that the Host name must be the same as DatabaseList in the orabbix configuration file.


Add a template for the Host. The Template Name Is Template_Oracle.


Then add the monitoring image to Screens.



Reprinted Please note:
Cross screw
Http://blog.chinaunix.net/uid/23284114.html
QQ: 463725310
E-MAIL: houora # gmail.com (# Replace it @)