Oracle monitoring under the Zabbix

I.　　Orabbix description
Orabbix is a Zabbix plug-in tool for monitoring Oracle database performance by installing the data collected on the client on the monitored server and passing it to the Zabbix server, which is then displayed through a call graph. Has the following functions:
1, database version
2, archive file
3, wait for events (such as file I/O, single block of read, block read, direct read, sqlnet message, control file I/O, log write, etc.)
4, Hitratio (monitor hit Ratio trigger, table/stored procedure, sqlarea,body)
5, logical I/O (current read operation, continuous read operation, block change)
6, PGA
7, SGA (fixed buffer, JAVA pool,large pool,log buffer,shared pool,buffer Cache)
8, physical I/O (override operation, data file write operation, data file read operation)
9, Sharepool (pool Dictionary cache, pool free Memory, Library cache,sql area, Misc.)
10, Pin hits Ratio (monitor hit Ratio on Trigger, Tables/procedures, Sqlarea,body)
11, Session/processes (monitor Sessions and Processes)
12, session (Active session, Inactive Sessions, System Session)

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/53/8D/wKioL1Rq8regTwjDAADclK9HQWo784.jpg "style=" float: none; "title=" image056.jpg "alt=" Wkiol1rq8regtwjdaadclk9hqwo784.jpg "/>

Second, Orabbix installation
2.1. Java Environment
First install the Java environment on the server being monitored, you can download the corresponding package installation directly to Oracle website.

wget HTTP://DOWNLOAD.ORACLE.COM/OTN-PUB/JAVA/JDK/7U72-B14/JRE-7U72-LINUX-X64.RPMRPM–IVH jre-7u72-linux-x64.rpm

2.2, set up the corresponding directory
Orabbix The default configuration is/opt/orabbix, the relevant content will be in this folder, if you specify a different directory at the time of installation, remember to change to the correct file path in the configuration file.

Mkdir–p/opt/orabbixcd/opt/orabbix

2.3, install the corresponding files

wget http://192.168.0.201:8080/%e5%b8%b8%e7%94%a8%e8%bd%af%e4%bb%b6/%e5%b7%a5%e5%85%b7/zabbix/ Orabbix-1.2.3.zipunzip ORABBIX-1.2.3.ZIPCP init.d/orabbix/etc/init.d/chmod +x run.shchmod +x/etc/init.d/orabbix

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/53/8F/wKiom1Rq8rLw6wVkAAF1GrcZPFs532.jpg "title=" Image057.jpg "alt=" Wkiom1rq8rlw6wvkaaf1grczpfs532.jpg "/>
2.4. Increase monitoring users

create user zabbixidentified by <replace with password>default  tablespace userstemporary tablespace tempprofile defaultaccount unlock; grant alter session to zabbix; grant create session to zabbix; grant connect to zabbix; alter user zabbix default role all; grant select on v_$instance to zabbix; grant select on dba_users to zabbix; grant select on v_$log_history to zabbix; grant select on v_$parameter to zabbix; Grant select on sys. dba_audit_session to zabbix; grant select on v_$lock to zabbix; grant select on dba_registry to zabbix; grant select on v_$librarycache to zabbix; grant select on v_$sysstat to zabbix; Grant select on v_$parameter to zabbix; grant select on v_$latch to zabbix; grant select on v_$pgastat to zabbix; grant select on v_$sgastat to zabbix; grant select on v_$librarycache to zabbix; grant select on v_$process to zabbix; grant select on dba_data_files to zabbix; grant select on dba_temp_files to zabbix; grant select on dba_free_space to zabbix; grant select on v_$system_event to zabbix;

If it is a 11G database version, you also need to execute the following statement open ACL access control, or in the process of monitoring some of the content will not display properly (for example, database version, database file size, etc.), and the Orabbix log display also has the following error message.
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/53/8F/wKiom1Rq8tfSYwxJAAFEdiSdIzo896.jpg "title=" Image058.jpg "alt=" Wkiom1rq8tfsywxjaafedisdizo896.jpg "/>

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;

After the settings are complete, you can view the added status by using the following statement.

Select Utl_inaddr.get_host_name (' 127.0.0.1 ') from dual;

2.5. Configuration Files
Orabbix all the configuration files are in the Conf directory, you need to copy the default profile config.props.sample and then modify and configure it.

CD CONFCP config.props.sample Config.propsvim config.progs

The following are based on this profile.

zabbixserverlist=zabbixserverzabbixserver.address=192.168.0.189zabbixserver.port=10051orabbixdaemon.pidfile=./ logs/orabbix.pidorabbixdaemon.sleep=300orabbixdaemon.maxthreadnumber=100databaselist= Crmdbdatabaselist.maxactive=10databaselist.maxwait=100databaselist.maxidle=1crmdb. Url=jdbc:oracle:thin:@192.168.0.209:1521:orclcrmdb.user=zabbixcrmdb. Password=zabbixcrmdb.maxactive=10crmdb. Maxwait=100crmdb. Maxidle=1crmdb. Querylistfile=./conf/query.props

It is important to note that Databaselist=crmdb refers to the name of the monitored server, which is consistent with the machine name in the Zabbix server interface, and the settings referenced in the configuration file are subject to that name.
Crmdb. URL=JDBC:ORACLE:THIN:@192.168.0.209:1521:ORCL Specifies the connection information for the monitored server (for example, a JDBC-based join method, The server address is 192.168.0.209,oracle port is 1521,ORCL refers to the instance of the database)
2.6. Add Monitoring Host
In Zabbix GUI management interface to add monitoring host before you need to import the Oracle database monitoring template, the monitoring template is saved in the extracted template folder, select Orabbix_export_full.xml Import.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/53/90/wKiom1Rq9M_BhavmAAB4BXn8Xno798.jpg "style=" float: none; "title=" image059.jpg "alt=" Wkiom1rq9m_bhavmaab4bxn8xno798.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/53/8D/wKioL1Rq9UTA517yAADdf9yx7_I317.jpg "style=" float: none; "title=" image060.jpg "alt=" Wkiol1rq9uta517yaaddf9yx7_i317.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/53/90/wKiom1Rq9M_xCtf-AACywp_bM0o434.jpg "style=" float: none; "title=" image061.jpg "alt=" Wkiom1rq9m_xctf-aacywp_bm0o434.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/53/8E/wKioL1Rq9UXzQS5sAABu8KsDHnc322.jpg "style=" float: none; "title=" image062.jpg "alt=" Wkiol1rq9uxzqs5saabu8ksdhnc322.jpg "/>

2.7. Start the service
The Orabbix can be added to the system service first, and then start the monitoring service and observe the corresponding log files, if there is no error prompt, the monitoring interface can display the normal monitoring graphics.

Chkconfig–add orabbixchkconfig–level 345 Orabbix onservice Orabbix Starttail–f/opt/orabbix/log/orabbix.log

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/53/8E/wKioL1Rq9W3wn3pXAADyyZx4WnM855.jpg "title=" Image063.jpg "alt=" Wkiol1rq9w3wn3pxaadyyzx4wnm855.jpg "/>

Iii. references
Http://www.smartmarmot.com/wiki/index.php/Orabbix
http://www.peasland.net/
http://www.smartmarmot.com/product/orabbix/

This article is from the "virtual reality" blog, be sure to keep this source http://waringid.blog.51cto.com/65148/1579107

Oracle monitoring under the Zabbix