监控安全
具体如何安装zabbix与orabbix ,这里就不再说了。下面要监控的是gps_index与gps_data表空间文件大小。首先修改好 #  vi  /opt/orabbix/conf/query.props分别加入以下内容。注意加入 QueryList 中的 内容,分行时,要加\      gps_index,gps_data单独一行加入以上内容,如下图:最后需要添加 查询内容:gps_index.Query=select bytes from dba_data_files where tablespace_name = 'GPS_INDEX'gps_data.Query=select bytes from dba_data_files where tablespace_name = 'GPS_DATA'完成后,保存。最后重启orabbix服务。下一步就要到zabbix中,添加监控项与图表。如下图所示,按此方法添加 gps_index与gps_data的监控项。最后添加图表,命名为GPS,如下图所示:最后测试数据是否正常。
Orabbix无法获取Oracle DB Size和DB Files Size的解决方法这几天在研究Orabbix时发现在Zabbix中无法获取DB Size和DB Files Size的大小,,后来发现问题出在/opt/orabbix/conf/query.props文件的配置上:因为最新的Orabbix 1.2.3版本在解压安装后,默认的query.props文件内没有配置这两个选项的检测,所以需要手动加上,分别在此文件中两个地方加入配置,具体如下:1. 在“QueryList=”的最后加上“,dbfilesize,dbsize”,注意要用逗号格开;2. 另外加上,dbfilesize,dbsize的检测语句,如下:dbfilesize.Query=select to_char(sum(bytes/1024/1024), 'FM99999999999999990') retvalue from dba_data_filesdbsize.Query=SELECT to_char(sum(  NVL(a.bytes/1024/1024/10 - NVL(f.bytes/1024/1024, 0), 0)), 'FM99999999999999990') retvalue \FROM sys.dba_tablespaces d, \(select tablespace_name, sum(bytes) bytes from dba_data_files group by tablespace_name) a, \(select tablespace_name, sum(bytes) bytes from dba_free_space group by tablespace_name) f \WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = f.tablespace_name(+) \AN...
Orabbix 是一个用来监控 Oracle 数据库实例的 Zabbix 插件。下载地址:http://www.smartmarmot.com/product/orabbix/download/  Orabbix插件的安装与配置 确保安装jdk环境,java version查看,没有则通过yum来安装JAVA:yum install java  1.在/opt目录下新建一个orabbix目录: [root@oracle orabbix]#midir -p /opt/orabbix(建议在此目录下,如果放置其他目录稍后需要更改orabbix的启动文件orabbix,启动文件默认写在opt/orabbix目录下 )  2. 解压安装文件[root@oracle orabbix]#unzip orabbix-1.2.3.zip 3.赋予权限 [root@oracle orabbix]# chmod -R a+x orabbix/ 4 通过/opt/orabbix/conf/config.props.sample文件创建一个config.props文件:  [root@oracle orabbix]#cp/opt/orabbix/conf/config.props.sample /opt/orabbix/conf/config.props  5.  编辑orabbix配置文件,具体如下 [root@oracle orabbix]#vi confi/config.props #comma separed list of Zabbix servers#ZabbixServerList=ZabbixServer1,ZabbixServer2ZabbixServ...
 
0
Zabbix 通过pyora监控oracle1.oracle客户端的安装从oracle官方网站上下载客户端,devel和sqlplus程序或者从以下网址下载 http://pan.uu456.com/s/1mgx8Fsk以root用户安装rpm –ivh oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpmrpm –ivh oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpmrpm –ivh oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpmvim /root/.bashrc 添加export ORACLE_HOME=/usr/lib/oracle/11.2/client64export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/libexport TNS_ADMIN=/usr/lib/oracle/11.2/client64/network/adminexport PATH=$PATH:$ORACLE_HOME/bin设置好环境变量之后执行source /root/.bashrc创建文件 /etc/ld.so.conf.d/oracle.conf添加/usr/lib/oracle/11.2/client64/lib执行命令 ldconfig创建连接文件在ORACLE_HOME目录下创建以下目录network/admin,并创建文件tnsnames.ora,内容如下:vim /usr/lib/oracle/11.2/client64/network/admin/tnsnames.oraorcl =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.10)(PORT = 1521)) )(CONNECT_DATA =(SERVICE_NAME = orcl)))...
zabbix 监控 oracle 数据库   一、简介       Orabbix 是设计用来为 zabbix 监控 Oracle 数据库的插件,它提供多层次的监控,包括可用性和服务器性能指标。        它提供了从众多 Oracle 实例采集数据的有效机制,进而提供此信息的监控和性能指标。然后,您可以利用的 zabbix 的报告功能为收集的所有数据,并提供分析。目前的发行版中包含了一组预先定义的模板,包括从初始部署警报和图形功能。然而,这些可以进行微调,以满足您的需求和数据/监控要求。Orabbix 监控什么?数据库版本归档日志与生产趋势分析触发器,表/过程等命中率逻辑 I/O 性能物理  I/O 性能PGASGA共享池Sessions数据库大小 二、安装配置# mkdir /opt/orabbix# cd /opt/orabbix# unzip orabbix-1.2.3.zip# mvconf/config.props.sample conf/config.props# cp init.d/orabbix /etc/init.d/# chmod 755 /etc/init.d/orabbix# chkconfig orabbix on  三、修改 orabbix 配置# vim conf/config.pr...
 
0

Zabbix_2.4 Installation

发表者:admin分类:监控安全2015-03-25 13:01:02 阅读[1844]
Installation from packagesFrom distribution packagesSeveral popular OS distributions have Zabbix packages provided. You can use these packages to install Zabbix.OS distributions may lack the latest version of Zabbix in their repositiories.From Zabbix official repositoryZabbix SIA provides official RPM and DEB packages for Red Hat Enterprise Linux, Debian and Ubuntu LTS. Package files are available at repo.zabbix.com. yum and apt repositories are also available on the server. A step-by-step tutorial for installing Zabbix from packages is provided here.Red Hat Enterprise Linux / CentOSSupported for versions: RHEL6, CentOS 6Installing repository configuration packageInstall the repository configuration package. This package contains yum configuration files.Zabbix 2.4 for RHEL6:# rpm -ivh http://repo.zabbix.com/zabbix/2.4/rhel/6/x86_64/zabbix-release-2.4-1.el6.noarch.rpmInstalling Zabbix packagesInstall Zabbix packages. Example for Zabbix server and web frontend with mysql database.Zabbi...
 
0
备份原有的yum[root@ns1 ~]# find /etc/yum.repos.d/ -name '*.repo' -exec mv {} {}.back \;#配阿里云yum源[root@ns1 ~]# vim /etc/yum.repos.d/aliyun.repo [aliyun]name=centos6baseurl=https://mirrors.aliyun.com/centos/6/os/x86_64/enabled=1gpgkey=https://mirrors.aliyun.com/centos/6/os/x86_64/RPM-GPG-KEY-CentOS-6gpgcheck=1 [epel]name=Extra Packages for Enterprise Linux 6 - $basearchbaseurl=http://mirrors.aliyun.com/epel/6/$basearch        http://mirrors.aliyuncs.com/epel/6/$basearchfailovermethod=priorityenabled=1gpgcheck=0gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL-6安装前端web[root@ns1 ~]yum -y install httpd PHP php-MySQL mysql-server [root@ns1 ~]service httpd start修改数据库配置文件,把编码改为utf8[root@ns1 ~]vim /etc/my.cnf[mysqld]default-character-set=utf8[root@ns1 ~]service mysqld start加入开机自启动[root@ns1 ~]chkconfig httpd on[root@ns1 ~]chkconfig mysqld on安装zabbix服务端[root@ns1 ~]#yum -y install zabbix22-server初始化数据库[root@ns1 ~]# &n...
很早之前有一位群友告知zabbix登陆不了,一直有如下提示:Access denied.Your are logged in as guest. You have no permissions to access this page.If you think this message is wrong, please consult your administrators about getting the necessary permissions.个案没多想,后来又有一位同学有这个问题,决定找出问题,很高兴群友信得过把机器开给我排查,最后找到问题,并解决问题了。logged in as guest现象正常登陆zabbix应该是下图:但是,却出现下图:解决方法如果你是Apache用户,应该不存在此问题,如果是nginx有可能因为配置不当而出现,我们需要修改php.ini# vim /usr/local/php-5.5.7/etc/php.inicgi.fix_pathinfo=0改为cgi.fix_pathinfo=1问题根源在zabbix php定位问题发现,zabbix是依据php文件名来设置权限,例如index.php、dashboard.php这些,如果cgi.fix_pathinfo设置为0,那么php无法获取到url请求的文件名称,例如访问index.php,获取不到index.php也定位到权限,于是出现这个错误。
    总共14页,当前第8页 | 页数:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14