bdjhx 发表于 2019-1-18 07:22:50

zabbix 之 orabbix安装指导

  zabbix利用orabbix监控oracle
  

  

  Orabbix 是一个用来监控 Oracle 数据库实例的 Zabbix 插件。下载地址:
  http://www.smartmarmot.com/product/orabbix/download/
  Orabbix插件的安装与配置
  确保安装jdk环境,java version查看,没有则通过yum来安装JAVA:yum install java
  1.在/opt目录下新建一个orabbix目录:
   #mkdir -p /opt/orabbix  (建议在此目录下,如果放置其他目录稍后需要更改orabbix的启动文件orabbix,启动文件默认写在opt/orabbix目录下 )
  2. 解压安装文件
    cd /opt/orabbix
    unzip orabbix-1.2.3.zip  3.赋予权限
    chmod -R a+x /opt/orabbix/  4 通过/opt/orabbix/conf/config.props.sample文件创建一个config.props文件:
    cp /opt/orabbix/conf/config.props.sample /opt/orabbix/conf/config.props  5.编辑orabbix配置文件,具体如下
  #vi conf/config.props
  ZabbixServerList=ZabbixServer1
  

  ZabbixServer1.Address=10.0.0.10
  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=rac1,rac2
  

  #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'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.创建执行文件(直接cp即可)
    cp /opt/orabbix/init.d/orabbix /etc/init.d/orabbix  7.保存退出,启动orabbix服务(确保有执行权限)
    /etc/init.d/orabbix start  Orabbix服务加入随系统启动:
    chkconfig --add orabbix
    chkconfig --level 345 orabbix on  常见问题:
  若config.props文件未配置,或是配置了错误,无法通过配置的信息正确连进Oracle数据库的,会出现以下错误信息
  # /etc/init.d/orabbix start
  Starting Orabbix service:
  # 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)
  可查看log信息判断解决
  # tail -f /opt/orabbix/logs/orabbix.log
  到此,安装配置完成,则通过web页面访问直接导入模块即可,模板文件:
  Orabbix_export_full.xml
  导入后生成template模板名为:Template_Oracle
  将oracle主机host与导入的模板Template_Oracle关联;
  注意:zabbix页面中配置oracle主机host名称必须和上面DatabaseList=rac1,rac2中的rac1、rac2一致,并且大小写敏感!!!!
  




页: [1]
查看完整版本: zabbix 之 orabbix安装指导