Orabbix Monitoring Oracle

Orabbix is a Zabbix plug-in used to monitor an Oracle db instance. ：

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

Orabbix plug-in installation and configuration

Make sure the JDK environment is installed, Java version view, no then yum installs Java:yum install Java

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

[[email protected] Orabbix] #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

[[email protected] Orabbix] #unzip orabbix-1.2.3.zip

3. Granting permissions

[Email protected] orabbix]# chmod-r a+x orabbix/

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

[[email protected] Orabbix] #cp/opt/orabbix/conf/config.props.sample/opt/orabbix/conf/config.props

5. Edit the Orabbix configuration file as follows

[[email protected] Orabbix] #vi confi/config.props

#comma separed list of Zabbix servers
#ZabbixServerList=ZabbixServer1,ZabbixServer2
ZabbixServerList=ZabbixServer1
#(zabbixserver name, the address and port in the downlink refer to this name, so the prefix names of the following two lines should be consistent with the name here)
#ZabbixServer1.Address=IP_ADDRESS_OF_ZABBIX_SERVER
ZabbixServer1.Address=192.168.3.163
#ZabbixServer1.Port=PORT_OF_ZABBIX_SERVER
ZabbixServer1.Port=10051
#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 the number of your databases
OrabbixDaemon.MaxThreadNumber=100
#put here your databases in a comma separated list
#DatabaseList=DB1, DB2, DB3
DatabaseList=DB_QM (DB name, can be freely defined, but be consistent with the following, remember to be consistent with the monitored host name)
#Configuration of Connection pool
#if not specified Orabbis is going to use default values (hardcoded)
#Maximum number of active connection inside pool
DatabaseList.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=100
DatabaseList.MaxIdle=1
#define here your connection string for each database
#DB1.Url=jdbc:oracle:thin:@server.domain.example.com:<LISTENER_PORT>:DB1
DB_QM.Url=jdbc:oracle:thin:@192.168.3.250:1521:qmeas
#Ensure that there is a jdk environment, because this is connected via JDBC
#DB1.User=zabbix
DB_QM.User=qm
#DB1.Password=zabbix_password
DB_QM.Password=qm
#DBUsers and passwords, you can create zabbix users, and give permissions, as follows (here directly with dba permissions users)
#Those values are optionals if not specified Orabbix is going to use the general values
DB_QM.MaxActive=10
DB_QM.MaxWait=100
DB_QM.MaxIdle=1
DB_QM.QueryListFile=./conf/query.props
#DB2.Url=jdbc:oracle:thin:@server2.domain.example.com:<LISTENER_PORT>:DB2
#DB2.User=zabbix
#DB2.Password=zabbix_password
#DB2.QueryListFile=./conf/query.props
#DB3.Url=jdbc:oracle:thin:@server3.domain.example.com:<LISTENER_PORT>:DB3
#DB3.User=zabbix
#DB3.Password=zabbix_password
#DB3.QueryListFile=./conf/query.props
#Note Unused DB connection 

To create a Zabbix user, follow these steps:

CREATE USER ZABBIX

Identifiedby Zabbix <Password>

Defaulttablespace SYSTEM

Temporarytablespace TEMP

Profiledefault

Accountunlock;

GRANT CONNECT to ZABBIX;

Grantresource to ZABBIX;

Alteruser ZABBIX DEFAULT ROLE all;

GRANT SELECT any TABLE to ZABBIX;

GRANT CREATE SESSION to ZABBIX;

Grantselect any DICTIONARY to ZABBIX;

grantunlimited tablespace to ZABBIX;

Grantselect any DICTIONARY to ZABBIX;.

Oracle 11g Add the following command

Execdbms_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

6. Create execution file (direct CP)

[Email protected] orabbix]# Cp/opt/orabbix/init.d/orabbix/etc/init.d/orabbix

7. Save exit, start the Orabbix service (ensure that you have execute permission )

/etc/init.d/orabbix start

Orabbix service join with system boot:

Chkconfig--add Orabbix

Chkconfig--level 345 Orabbix on

Problems:

The following error message occurs if the Config.props file is not configured, or if an error is configured that cannot be properly connected to the Oracle database through the configured information

[[email protected] orabbix]#/etc/init.d/orabbix start

Starting Orabbix Service:

[email protected] orabbix]# stopping

Java.lang.Exception:ERROR on Main-connections is empty

Atcom.smartmarmot.orabbix.Orabbixmon.run (orabbixmon.java:101)

Atcom.smartmarmot.orabbix.bootstrap.main (BOOTSTRAP.JAVA:50)

can view log information to determine resolution

[Email protected] orabbix]# tail-f/opt/orabbix/logs/orabbix.log

Here, the installation configuration is complete, and the direct Import module via Web page access

Import template, template placed under/opt/orabbix/template
Orabbix_export_full.xml All import (Chart monitor item trigger)
Orabbix_export_graphs.xml Chart
Orabbix_export_items.xml Monitoring Items
Orabbix_export_triggers.xml Trigger

Select Orabbix_export_full.xml Direct import, you can link to the template directly in the host to use the full functionality (the host name must be consistent with the DATABASELIST=DB_QM in the configuration)!

You can also find this template in the template template. Then the required information directly to the CP past, such as open the monitoring item here, copy it all to the Oracle host, trigger, image display the same!

Create a chart with some of the following effects:

Orabbix Monitoring Oracle