Pro-Test Orabbix monitoring Oracle Process

Many online tutorials, but generally older, worried about the new version of the changes, so personally tested, the recording process is as follows:

First, the environment

Centos7.3 192.168.56.104

Oracle is installed under Windows, 192.168.56.101

Second, step:

1. Ensure that the JRE environment uses Java commands to identify

If you do not have a direct yum install Java Java-devel

2. Installing Orabbix

Orabbix Official website: Http://www.smartmarmot.com/wiki/index.php?title=Orabbix

: http://www.smartmarmot.com/product/orabbix/download/Latest Version Orabbix-1.2.3.zip

Download and upload to Zabbix-server/opt/orabbix/(recommended directory, otherwise it will affect the subsequent script execution)

#mkdir/opt/orabbix#cd/opt/orabbit#unzip Orabbix-1.2.3.zip

The extracted directory

3. Configure Orabbix

Attach permissions to the Orabbix directory

#chmod A+x/opt/orabbix-r

Create a Orabbix configuration file

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

Edit Config.props

[[email protected] ~]# cat/opt/orabbix/conf/config.props#comma separed List of Zabbix serverszabbixserverlist= Zabbixserver zabbixserver.address=192.168.56.104 #Zabbix server address port zabbixserver.port=10051#zabbixserver2.address =ip_address_of_zabbix_server#zabbixserver2.port=port_of_zabbix_server#pidfileorabbixdaemon.pidfile=./logs/ Orabbix.pid #Java进程 #frequency of item ' s refreshorabbixdaemon.sleep=300#maxthreadnumber should be >= than the numb Er of your databasesorabbixdaemon.maxthreadnumber=100#put here your databases in a comma separated list#databaselist=db1, Db2,db3databaselist=win-oracle #此处名称需和oracle db-End Zabbix front-end hostname? Consistent #configuration of Connection pool#if not speci Fied Orabbis is going to use default values (hardcoded) #Maximum number of active connection inside Pooldatabaselist.maxact Ive=10#the maximum number of milliseconds that pool would wait # (when there is no available connections) for a Connect Ion to is returned #before throwing an exception, OR <= 0 to wait indefinitely. Databaselist.maxwait=100databaselist.maxidle=1#define here your connection strings for each database#db1. Url=jdbc:oracle:thin: @server .domain.example.com:<listener_port>:D b1win-oracle.url=jdbc:oracle:thin:@ 192.168.56.101:1521:ORCL #实例名为orcl #db1. USER=ZABBIXWIN-ORACLE.USER=ZABBIX#DB1. Password=zabbix_passwordwin-oracle. Password=zabbix#those values was optionals if not specified Orabbix was going to use the general valueswin-oracle. Maxactive=10win-oracle. Maxwait=100win-oracle. Maxidle=1win-oracle. 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 users and permissions on the Oracle side

CREATE USER ZABBIX identified by ZABBIX default tablespace SYSTEM temporary tablespace TEMP profiles default account UNLOCK ; GRANT CONNECT to ZABBIX; GRANT RESOURCE to ZABBIX; ALTER USER ZABBIX DEFAULT ROLE all; 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; GRANT ALTER SESSION to Zabbix; GRANT CREATE SESSION to Zabbix; GRANT CONNECT to Zabbix; ALTER USER Zabbix DEFAULT ROLE all; GRANT SELECT on v_$instance to Zabbix; GRANT SELECT on dba_users to Zabbix; GRANT SELECT on v_$log_history to Zabbix; GRANT SELECT on V_$log to Zabbix; GRANT SELECT on V_$parameter to Zabbix; GRANT SELECT on SYS. Dba_audit_session to Zabbix; GRANT SELECT on V_$lock to Zabbix; GRANT SELECT on Dba_registry to Zabbix; GRANT SELECT on V_$librarycache to Zabbix; GRANT SELECT on V_$sysstat to Zabbix; GRANT SELECT on V_$parameter to Zabbix; GRANT SELECT on V_$latch to Zabbix; GRANT SELECT on V_$pgastat to ZabBix GRANT SELECT on V_$sgastat to Zabbix; GRANT SELECT on V_$librarycache to Zabbix; GRANT SELECT on v_$process to Zabbix; GRANT SELECT on Dba_data_files to Zabbix; GRANT SELECT on Dba_temp_files to Zabbix; GRANT SELECT on Dba_free_space to Zabbix; GRANT SELECT on v_$system_event to Zabbix; GRANT SELECT on V_$locked_object to Zabbix; GRANT SELECT on dba_objects to Zabbix; GRANT SELECT on dba_tablespaces to Zabbix; GRANT SELECT on v_$session to Zabbix;

There are duplicate, different documents in the above, I was found that the permissions of a document does not seem to be complete, so the synthesis of two documents.

Said 11G also need to perform the following procedure, 11G Previous version has not tried, do not know whether to execute:

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;

Configuring Orabbix Services and processes

#cp-a/opt/orabbix/init.d/orabbix/etc/init.d/orabbix#chmod 755/etc/init.d/orabbix#/etc/init.d/orabbix start

? log? file in/opt/orabbix/logs/orabbix.log tail-f tracking? Log analysis issues during deployment.

Third, the front-end increase the host

Then add the template to Zabbix Web configuration-"templates-" Import
Then added to the hosts to increase the Oracle template,enable the corresponding needs to monitor the content.

　　

　　

　　

　　

　　

　　

Pro-Test Orabbix monitoring Oracle Process