Use Zabbix to monitor Oracle basic usage

using Zabbix to monitor Oracle Here we use the Open source Orabbix project, software:

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

Attachments can also be downloaded

Deployment Method

when the download is complete , it is placed on the Zabbix server server (recommended), or it can be placed on a different server, as long as the server communicates with Zabbix server and Oracle server.

cd/usr/local/src/&& mkdir Orabbix && Cdorabbix

Unzip Orabbix-1.2.3.zip

Cp-r/usr/local/src/orabbix/usr/local/

cd/usr/local/orabbix/

Chmod-r a+x/usr/local/orabbix/

Create the service and configure the self-boot (do not start first)

Ln/usr/local/orabbix/init.d/orabbix/etc/init.d/orabbix

chmod 755/etc/init.d/orabbix

Chkconfig--add Orabbix

Chkconfig Orabbix on

Sed-i "[Email protected]/opt/[email protected]/usr/local/[email protected]"/etc/init.d/orabbix

Modifying the master configuration file

cd/usr/local/orabbix/conf/

CP Config.props.sample Config.props

Vim Config.props content is as follows:

zabbixserverlist=ZabbixServer1,ZabbixServer2

# The name above must be the same as the beginning of the following two lines, the name of its own definition, if more than one zabbixserver need to monitor the data to write multiple, do not need to delete ZabbixServer2, The following two lines correspond to also delete

ZabbixServer1. address=10.8.1.7

# Enter the access IP address of the Zabbixserver server above

ZabbixServer1. port=10051

# Enter the port that corresponds to the access IP of the Zabbixserver server

ZabbixServer2. Address=ip_address_of_zabbix_server

ZabbixServer2. Port=port_of_zabbix_server

Orabbixdaemon.pidfile=./logs/orabbix.pid

orabbixdaemon.sleep=300

orabbixdaemon.maxthreadnumber=100

databaselist=DB1,DB2

# above specifies the data to get the host, the name needs to be the same as the name specified when the host is added to the real zabbixserver, and the following configuration will start with the same name

databaselist.maxactive=10

databaselist.maxwait=100

Databaselist.maxidle=1

DB1. url=jdbc:oracle:thin:@10.8.5.10:1521:aekdb

#10.8.5.10 is the address of the Oracle server

#1521 to access an Oracle- connected Port

#aekdb is the true instance name of Oracle

DB1. User=zabbix

#oracle Database authorizes the user name accessed by this server (you can give DBA authority to prevent permissions problems )

DB1. Password=aek56.zabbix

# The password for the user name that this server is authorized to access

DB1. maxactive=10

DB1. maxwait=100

DB1. Maxidle=1

DB1. Querylistfile=./conf/query.props

# Monitoring script path, can be defined by itself, can be configured for the use of different monitoring scripts to achieve different requirements

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

DB2. maxactive=10

DB2. maxwait=100

DB2. Maxidle=1

DB2. Querylistfile=./conf/query.props

Start the service

Service Orabbix Start

Tail-f/usr/local/orabbix/logs/orabbix.log # Check the log for any errors

Normal Startup Success Process

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M01/9A/14/wKiom1lRAgjBmyuQAAKScBXF6Us853.png-wh_500x0-wm_ 3-wmp_4-s_2427993675.png "title=" 1.png "alt=" Wkiom1lragjbmyuqaakscbxf6us853.png-wh_50 "/>

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

650) this.width=650; "Src=" https://s2.51cto.com/wyfs02/M02/9A/14/wKioL1lRAhKjG-tkAAFggEh4MuQ119.png-wh_500x0-wm_ 3-wmp_4-s_2709779007.png "title=" 2.png "alt=" Wkiol1lrahkjg-tkaafggeh4muq119.png-wh_50 "/>

according to the above warning or error message keyword, go to the corresponding monitoring script file to search the corresponding keyword, see how the script is written, and then to solve the problem, generally if the Oracle authorized Orabbix access to the rights of DBAs Don't go wrong, problems are usually permissions

after all the warnings and errors are resolved, upload (import) the Zabbix template under the source package directory to the Zabbix server andadd it to the corresponding host, the data can be received normally.

/usr/local/orabbix/template/orabbix_export_full.xml

This article is from the "Blue _ Storm" blog, make sure to keep this source http://270142877.blog.51cto.com/12869137/1942174

Use Zabbix to monitor Oracle basic usage