Shulou(Shulou.com)06/02 Report--

Use zabbix to monitor oracle here we use the open source orabbix project, software download address:

Https://nchc.dl.sourceforge.net/project/orabbix/orabbix-1.2.3.zip

Deployment method

After the download is completed, put it to the zabbix server server (recommended), or you can put it on another server, as long as this server can communicate with zabbix server and oracle server

Cd / usr/local/src/ & & mkdir orabbix & & cd orabbixunzip orabbix-1.2.3.zipcp-r / usr/local/src/orabbix / usr/local/cd / usr/local/orabbix/chmod-R axix / usr/local/orabbix/

Create a service and configure self-startup (don't start yet)

Ln / usr/local/orabbix/init.d/orabbix / etc/init.d/orabbixchmod 755 / etc/init.d/orabbixchkconfig-add orabbixchkconfig orabbix onsed-I "s@/opt/orabbix@/usr/local/orabbix@g" / etc/init.d/orabbix

Modify the master configuration file

Cd / usr/local/orabbix/conf/cp config.props.sample config.propsvim config.props

The contents are as follows:

The name above the ZabbixServerList=ZabbixServer1,ZabbixServer2# must be the same as the beginning of the following two lines. The name is defined by itself. If there are more than one ZabbixServer, you can write multiple monitoring data, and delete the ZabbixServer2 without the need. The following two lines also need to delete ZabbixServer1.Address=10.8.1.7#, enter the access IP address of the ZabbixServer server ZabbixServer1.Port=10051#, enter the port ZabbixServer2.Address=IP_ADDRESS_OF_ZABBIX_SERVERZabbixServer2.Port=PORT_OF_ZABBIX_SERVER OrabbixDaemon.PidFile=./logs/orabbix.pidOrabbixDaemon.Sleep=300OrabbixDaemon.MaxThreadNumber=100 DatabaseList=DB1,DB2# corresponding to the access IP of the ZabbixServer server, and specify that you want to obtain the data of the host. The name here needs to be the same as that specified when adding hosts in the real ZabbixServer. And the following configuration should also use the same name to start DatabaseList.MaxActive=10DatabaseList.MaxWait=100DatabaseList.MaxIdle=1 DB1.Url=jdbc:oracle:thin:@10.8.5.10:1521:aekdb#10.8.5.10 with the address of the oracle server # 1521 as the port to access the oracle connection # aekdb is the real instance name of the oracle DB1.User=zabbix#oracle database to authorize access to this server's user name (to prevent permission problems Can give dba permission) DB1.Password=aek56.zabbix# authorizes this server to access the user name corresponding to the password DB1.MaxActive=10DB1.MaxWait=100DB1.MaxIdle=1DB1.QueryListFile=./conf/query.props# monitoring script path, you can define your own You can configure different monitoring scripts for unused instances to achieve different requirements of DB2.Url=jdbc:oracle:thin:@server2.domain.example.com::DB2DB2.User=zabbixDB2.Password=zabbix_passwordDB2.QueryListFile=./conf/query.propsDB2.MaxActive=10DB2.MaxWait=100DB2.MaxIdle=1DB2.QueryListFile=./conf/query.props

Start the service

Service orabbix start

Tail-f / usr/local/orabbix/logs/orabbix.log # check the log to see if there is any error

Normal startup success process

If there is a warning or error message, as shown in the following figure

According to the keywords of the above warning or error message, go to the corresponding monitoring script file to search for the corresponding keywords to see how the script is written, and then solve the problem according to the problem. In general, if the permission granted by oracle to orabbix access is dba, there will be no problem, and the problem is usually the permission problem.

After resolving all warnings and errors, upload (import) the zabbix template under the source package directory to zabbix server, and then add it to the corresponding host. At this time, you can receive the data normally.

/ usr/local/orabbix/template/Orabbix_export_full.xml

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.