Orabbix monitors oracle databases

Orabbix monitors oracle databases
Orabbix monitors oracle database 1 download 2 Grant file executable permissions

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

3. Create a file named config. props. For more information about templates, see.

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

Below is a configuration of mine:
Note that DatabaseList is case sensitive and consistent with the hostname on zabbix.

[root@iZ23snm97y9Z 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=300#MaxThreadNumber should be >= than the number of your databasesOrabbixDaemon.MaxThreadNumber=100#put here your databases in a comma separated listDatabaseList=DB68#Configuration of Connection pool#if not specified Orabbis is going to use default values (hardcoded)#Maximum number of active connection inside poolDatabaseList.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 <= 0 to wait indefinitely.DatabaseList.MaxWait=100DatabaseList.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 are optionals if not specified Orabbix is going to use the general valuesDB68.MaxActive=10DB68.MaxWait=100DB68.MaxIdle=1DB68.QueryListFile=./conf/query.props#DB2.Url=jdbc:oracle:thin:@server2.domain.example.com:
  
   :DB2#DB2.User=zabbix#DB2.Password=zabbix_password#DB2.QueryListFile=./conf/query.props##DB3.Url=jdbc:oracle:thin:@server3.domain.example.com:
   
    :DB3#DB3.User=zabbix#DB3.Password=zabbix_password#DB3.QueryListFile=./conf/query.props##
   
  

4. Add permissions to the oracle database:

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; -5 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; ''11g, run 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 boot auto start:

chkconfig --add orabbix

6. Start orabbix

/etc/init.d/orabbix start

Observe logs/orabbix. log
The following output indicates that orabbix is running properly:

 2015-05-08 10:57:44,343 [pool-1-thread-1] INFO Orabbix - Done with dbJob on database DB68 QueryList elapsed time 1125 ms

Otherwise, it depends on the specific error message. Generally, the database cannot be connected due to incorrect permissions.
Orabbix connects to oracle through a java program, so you need to install the java environment.

7. xml import template on zabbix

There is Orabbix_export_full.xml under the template directory, and it is OK to import it.

8. Add hosts to zabbix

Note that you do not need to add a linux template. Just add the imported oracle template.

9 End

Now, after oracle is added, you can view the running status of oracle using the zookeeper of zabbix. The graph is not truncated.