Zabbix's Oracle Monitoring

Source: Internet
Author: User

1. Installing the JDK

 2, installing Orabbixwget HTTP://WWW.SMARTMARMOT.COM/DOWNLOADS/ORABBIX-1.2.3.ZIPMKDIR/OPT/ORABBIXMV Orabbix-1.2.3.zip/opt/orabbixcd/opt/orabbixunzip orabbix-.1.2.3.zip 3, authorized chmod +x/opt/orabbix/run.shchmod +x/ Opt/orabbix/init.d/orabbix cp/opt/orabbix/conf/config.props.sample config.props 4, configuring Config.propscat/ Opt/orabbix/conf/config.props |grep-v "#"             Here only with no comments. Zabbixserverlist=zabbixserver           #zabbix名称   zabbixserver.address= 192.168.0.119     #zabbix服务端的IP地址ZabbixServer. port=10051               &NBSP ; #zabbix服务端的端口     orabbixdaemon.pidfile=./logs/orabbix.pidorabbixdaemon.sleep= 300orabbixdaemon.maxthreadnumber=100  databaselist=pfs-dev               #这个名称可以随便起, but must be consistent with the host name of the Monitor.   databaselist.maxactive=10databaselist.maxwait=100databaselist.maxidle=1  twstcptest.com. Url=jdbc:oracle:thin:@192.168.32.48:1521:pfstest   #这里主要是通过JDBC来连接客户端的. Rdcms is primarily the instance name of the database. The client can get the name of the instance through select instance_name from V$instance. Twstcptest.com.user=zabbix       #数据库用户twstcptest. Com.password=zabbix  # Database user Password twstcptest.com.maxactive=10twstcptest.com.maxwait=100twstcptest.com.maxidle= 1TWSTCPTEST.COM.QUERYLISTFILE=./CONF/QUERY.PROPS 5, Oracle Database permissions configuration su-oracle       export Oracle_sid=pfstestsqlplus/as sysdba create user Zabbix identified by "Zabbix" default tablespace system temporary t Ablespace Temp Profile default account Unlock;grant alter session to Zabbix;grant create session to Zabbix;grant connect T o zabbix;alter user Zabbix default role all;grant Select on V_$instance to Zabbix;grant Select on Dba_users to Zabbix;gran T select on V_$log_history to Zabbix;grant Select on V_$parameter to Zabbix;grant Select on Sys.dba_audit_session to Zabbi X;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_t Emp_files to Zabbix;grant Select on Dba_free_space to Zabbix;grant Select on V_$system_event to Zabbix; 6, start orabbix/ Opt/orabbix/run.shps Aux|grep orabbix 

Zabbix's Oracle monitoring

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.