Orabbix Monitoring Oracle Database

Orabbix monitoring Oracle Database 1 Downloads

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

2 permissions granted to a file for execution

#chmod +x /opt/orabbix -R#chmod +x /opt/orabbix/run.sh

3 Create a file named Config.props, you can refer to the template.

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

Here is one of my configurations:
Note that databaselist is case sensitive and is consistent with the hostname above Zabbix.

[email protected] orabbix]# cat Conf/config.props#comma separed List of Zabbix serverszabbixserverlist=zabbixserver1zabbixserver1.address=127.0. 0. 1zabbixserver1.port=10051#ZabbixServer2. Address=ip_address_of_zabbix_server#ZabbixServer2. Port=port_of_zabbix_server#pidFileOrabbixdaemon.pidfile=./logs/orabbix.pid#frequency of item ' s refreshorabbixdaemon.sleep= -#MaxThreadNumber should be >= than the number of your databasesOrabbixdaemon.maxthreadnumber= -#put here your databases in a comma separated listDatabaselist=db68#Configuration of Connection pool#if not specified orabbis are going to use default values (hardcoded)#Maximum number of active connection inside poolDatabaselist.maxactive=Ten#The Maximum number of milliseconds that the pool would wait# (when there is no available connections) for a connection to be returned#before Throwing an exception, or <= 0 to wait indefinitely.databaselist.maxwait= -databaselist.maxidle=1#define HERE your connection string for each databaseDB68. url=jdbc:oracle:thin:@10.168. xx.xx:1521: Testdb68.user=zabbixdb68.password=zabbix#Those Values Optionals if not specified Orabbix be going to use the general valuesDB68. Maxactive=TenDB68. maxwait= -DB68. maxidle=1DB68. Querylistfile=./conf/query.props#DB2. Url=jdbc:oracle:thin: @server2 .domain.example.com:<listener_port>:D B2#DB2. User=zabbix#DB2. Password=zabbix_password#DB2. Querylistfile=./conf/query.props##DB3. Url=jdbc:oracle:thin: @server3 .domain.example.com:<listener_port>:D B3#DB3. User=zabbix#DB3. Password=zabbix_password#DB3. Querylistfile=./conf/query.props##

4 Add permissions on the Oracle database:

 CREATEUSER ZABBIX identified byZabbixDEFAULTTablespace SYSTEM temporary tablespace TEMP profileDEFAULTAccount UNLOCK; –2Roles forZABBIX GRANT CONNECT toZABBIX; GRANT RESOURCE toZABBIX; ALTER USER ZABBIXDEFAULTROLE all; –5System Privileges forZABBIX GRANTSELECTAny TABLE toZABBIX; GRANTCREATESESSION toZABBIX; GRANTSELECTAny DICTIONARY toZABBIX; GRANT UNLIMITED tablespace toZABBIX; GRANTSELECTAny DICTIONARY toZABBIX; ``` OneG then execute the stored procedure ' 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

Use the following statement to test:


select utl_inaddr.get_host_name(‘127.0.0.1‘) from dual;


5 Add power-on self-boot:

chkconfig--addorabbix

6 Start Orabbix

start

Observe Logs/orabbix.log
The following output appears to indicate that Orabbix is functioning properly:

2015-05-0810:57:44,343 [pool-1-thread-1] INFO  withon datime1125 ms

Otherwise, it depends on the specific error message, the general may be the rights are not connected to the database.
Orabbix is a Java program that connects Oracle, so you need to install the Java environment.

7 Zabbix template for importing XML above

Under the template directory there is orabbix_export_full.xml, import he is ok.

8 Zabbix Add Host

Note here that you don't need to add a Linux template, just add the Oracle template you just imported.

9 End

Now that Oracle has been added, you can see the operational status of Oracle in the Zabbix diagram. The picture is not cut. Refer to the official Wiki
Http://www.smartmarmot.com/wiki/index.php/Orabbix
The steps are written in detail. English OK friends directly to see on the line.

Orabbix Monitoring Oracle Database