zabbix oracle监控插件orabbix部署安装
1,下载orabbix插件包(插件包同时满足在大部分POSIX-linux及unix和大部分版本的windows下运行,玩转类似但不等同于Tomcat)wget http://www.smartmarmot.com/downloads/orabbix-1.2.3.zip
2,解压插件包部署(插件包是绿色的解压即可使用)
unzip orabbix-1.2.3.zip
具体设置见
http://www.cnblogs.com/ruiy/p/data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA8kAAAA0CAIAAAA2Su2UAAAUGUlEQVR4nO1dXcKjIAzs8TyQx/EuHqVH6T60CkkmIVBb3a8zL7tFCPmBMKCf3h4EQRAEQRAEQRyB29kKEARBEARBEMQfAbk1QRAEQRAEQRwDcmuCIAiCIAiCOAYX4Nb3ZbpNy/0ycoY76i0ndtClvwxG/0Cc7py/Fc11Pl65A2V2OnWdb7d5PaTn72Kdb09M08uw44bNb4Z407BZf3jMgIbXd8uBcLj1fZluNT6p1fe5tbCuv+tvLhLXXngc7ImwRmjFd9ddpd+1/Pvm4DwfV48+0QDTYy1/VLxLI96Qme/lA3xRzetvEhVEjA6kDT8Y4iEN+3q8L5MK2vXdYvHGMAu4dZF4X6YPLvNf5tbrLBKD+vlOR//j4vEN3Jep5eLvudQoc+iEfxfvD87L4VLRJ1pgehTSh4VbZvG+zK5eDs0bZhh8NWtCa44J/W+GeEzDzh41yb2+W7x+PsmtTUF1srEX1q6s95n7/58illnvfIVoJFkfowvF5G666YV1NpXK4i80nFevX23IZmlcfledA00MYP/YRZEIN5JIlGqw/zTOSULZebZLG/eGVjM8leFLODOazf2esf7O4MzGgNFHCoHpc2rcoUjP+ZU4c4dgy1mwVfJG8V9Nj4k9nnVGXb/ythw40zxPrg7K9RmZL4ds1+ZVR3qX8CQS5XmJehajcvQcwFPX0DExv/DTiIl1g1ZgyBm7yuF9t5V6YvybIa413GnbfZlu8zwbXV8VfHuVPytoonZxtwC8RcCy3LoqEUmq0rWQ66dpz+Kyj1CmKM4dSbbmVouLRwuSdtWFobPlGiP1rNR3yquwbDFO7Ya0wikXScha5ZcjKlrguw9R4wXtDJdGZuiJh3Tw/ZlsHquWHpwdj9Ux+sac14+uwH0s7li9vtAD58hWmez4p9NjL7cWXEA0rjtd52qFhYvhoMzQ0bKmHYZOuVyLDdfwEA2dII1A49xJlFVAbR2N0NQ4L93/YIiNhs9f4tYEEtiak3KClXb/iVsCqwYJWD+39haAov86P7cO5QeSaQW6kq1uipSH9WtgZ2ylsYRmv6ny+zKVv8doI7Yxl0jQ4vWmFTk0z55Ocekr8ZttszZwG7nG8DptlISTbu6ia3CmxTL6skefOxa9vxt3T5N0YsRrFdPjQAiqpqUlWl/1mi3rQUcOybSQZ1jt3rGjt6O9hH8CBtE/Yv0c5CPm1t4ETEj9wRALDaXAqlycZgf2Crk6CsITF3dL1q6eDDPGrdU2qJor87qN7ec/lYub89CXbPjQnsSr+pmpGi+u4KrX7xu8pCvjg7aeixJCdJJCoo5iV2LBNxdOdKlE2a4rvfbp15gLtT9zzT10Dc4BsYy+7L5KW6fG3crvslftYSLOwfSYhDlmE2LKCi472LuHJCEpE9i/sQEwcNX6562L2zHXewkEX0qkEUgDxhTAtAFNwAZ+M8SreTKjcGjnNBtVMAiTzfXd4uONDNP/vHWQCu/LNC3LXMIyL9WGpZlbXcly9RCe7HUZOEwrNAAMkGS/+fL78nysKRnc2Mb0KHmOX7Gre3MJTHSIal/ApQrCQI8NatHPKSVa9DR30DM4e8LB6ANcKO5Okwz7LOOjp5WLH02PCoqAgPU05l1oxR2UGS3uud4h8dj5aOqE178DNTBiYTqK0ebWSUHCpB8MsT7SdwSW4tDeGh6rtZ1e0C0R3sgwA+8JEelczhDxtIv6lZiHjmSgDLgglfRRDirNz9BxzhoTqmPKtyjns75KQYHzm2LUht4TJaSu+8NmHQuVXfDrK6e61CTiet0wd5S87XTZUOMs0WzuYXRwZsQy+o91lt2/fn0+7j47MdLbzi8/kVjMb/ygABX+ZHpMe+Bu3mcg3FxJFcmkqmTVH5T5ugYXPztY4nIw3vvcrNPHPshaS7bxPEhHIWJu7U3AWOAPhthoKBJJdUkcVuv/idaSsoofxVEXd0sD4wRs7P3W1WWpoaXaMrk197iO5OrewDTParhX5Tl/CetCvgL7Vc4RmwevfFru/vhLKltNa+j8thi0DsfeLu9HyA9HPXikP852qb7NJIe2uIq2dsJIl3o1m/tIDs4+sYy+sQ0u9x+Ke34TnHH+/lMP5d0phfZga2P8zfSY5NaWC2hD5XIPHVxfmZZ7p0zEYbaK5VH0Xje/mIpkyck9H5AL3YCWceWacrkve0Xc+hFMbCzuB0MMNFzxAx/wJFnZ+zBjpx4GuwnXd0sbwwTsAt9lJL4BsyskfgiM/plo3E/9EHo3dcTD3jVv1E35t0fmH0Fj7J2ajn4zxKdoeH23fBLk1r+BjsdHiD8HRv9MnEOtya370cUFkgTxJ/lFPPbOTEe/GWIy6xNAbv0L4DL7y2D0fxIM+0fBW0EBorH3/4xLhph4A+TWBEEQBEEQBHEMyK0JgiAIgiAI4hiQWxMEQRAEQRDEMUhx60/8Mc4ms/l3DcN/+AAaHmiI99SYU86/Jvs/MfBw4P/zPOHjcZy2+3uVvFHuvDxrBMd6eNd8f83TtyLIvGrxtbz6SecfgA/54ct/V8snlo9G5+sLv4q0bs3F4gvonGADi0KCW+N3FAp0z9iEzHd7sdN6qNNeZQ5LXsOvp22Lvd7UvKZWl8U77nrrPdkeEkv7gdz6SCDNv6Mh82qPMgeTwjd0djW5vh8O1TCDHm3V29oPWvA+PZet/E/2GLzUG75y+UkiQJF1tFdev3F/ff2034So3xudyGpHRNd7DX9H82M4tIcmt85Mx97d6dgU7+xFB/nYvOIpc9BGXY/g45S/FrPZcE2tLourcevMqL8mt4aaf0ND5tUuZY49AH1H50DDi/vh68w6z6IMYztM1z/FrWPiejdfR1rn222eZSOpXmnjlZtLMqrG2uYIPWQqqwEDGH8L53Pr1X4MvrHfAZ9MVNvQWqb8NNBcvrKo9kFuL1pbbwenDIk+DbRd27dpttfn+Ch3kzcRXjm6U/s0yUug7tHIbVqWeddG+mVrJKrViuPqvhfrj3vWxsgfKCZgV+myOqyVJ9l3iK4JJCgH3pfp+UW5reddlZcWtc71WED2IzMr00QZjI7TBbLZVEMdZdoGyiRD4LgAW31P+KdeQeoJs/9ficLKq4zhHQJWFVbM/rETcKTs8ub7jHnV9vrZvNqj82Odq8wAZply1/X9UGtoNZGMp/zyxg9yqjbE01ajY717OPPRWdjGV5bUSgl1by4ZmYUJ9hVSa7Eqi/pyh+OtwsGZi7FRZGKjbPhe657FwvUGsFVvEro5EgyEKb9HXEgh5tbCS3LdqAJmQ66XmPsy1Q3RHBY7jyJcVAi3E7JPFXTfEDATnIFha1aTXcx7Uy5TlcmCQUfIyKhdGV44Vs1tmVe3VhwyH+0ekUrAzjg5exsqS0u1DrZceea+lCfE1uqbqB6Nu+/NrEW2UAw0ORpQdKA012p9FgE6yrT1h0rHqLF0GVutPOmpXYZYPZ/AJMop35pQZhBWhf4ogpFKcmvmVdXBV/Jqv84gl2B3Xd8PkvAYTTxq7Y0fX/VqVHpWhK3NJbOlbSUl1/9pCZHApvLxkpFcmBCCmQo13OsHyRCMHFUObXyu8JPjlpBcpxcL3xswbN6iYGshjlQYS1Re7bANF7KIuPW9vi+DxiiI3FY1cAukV1JLceri9GLkCvWEvNAQObqiwS2XfJmJkJJ4km0bt3gr3E+764Y9LDaUb846JjUvUOUo5+W0itTIyUzq5ulg5cTzGRYmdYu76LI60Kq3bT4Ej1womy6V68y8bp1uPRcNhj2c1Lx3FHWCeVXiW3l1XOeGu67vBzk8gCbOOHHLjebgQq5tzzFTMinV5g2vLJ7AWMOHF5aWAomU4uoK3a8zW+0QgSqponJPN8GKzaXAlK7FAgIPmK30TY6UKjdcCCHg1nYvrrHrKAyNsvVq7pyp1XTvTB2qNPJSuAQYQ/Ra5o7uLU+p+wlKGREuVC7TSnMW6cFX9Q3aqsi8z61v0GbQ1qvsxaqPW/tqBDJ3V0e6DXFrKVJMMjA6oB9q3bAOsIu21V5H2bZeKsmF4GFdF1rd9M9+5TVxn/9URqXyoJqIw9waOyEbKQDm1ZPyaofOQDQOSofME/2ghgfkg5AGe+PHoLIEJ4IueupdipISWgf7JIC+gcCm8nE+Ty5MuCdUweG4Up7SScYaKlDzdWfkzrN/G6ODWyeWyNA2XfgmR+ot9+FyazAd3U2T7CPcoDoHMfo4xOz049N3N+u0DfHSaURgnMSbSch7lKPdsombO27kjlX0OMytozsx4g8jkhzaK29w68RxQiAzqVsPt24YiJnZ6CztSi5d0z7ZNh+CRzOUAbf2YzEty1zm1bxU+frAPBgHPeOEFKUrYF49L6+O6hy66/p+MOedxgqXBjvjJ0CxKt8WH3tLabEUZx3skJAWCGqaeWor9y5MTk9oX+eutXgTASiERy1cziDurdnu+7h1IoFrgG7vC/6jzB6OlC83XAjB4dbWO8qc+/b4kPVCsXJvuvnLVgTTEN25BL4W3dgfr9oNQ6p5YAa9yQ1Vwik1qx9OeaV77rbFqyI6DAlJgzu8xM/o+Mtc3sO8uyeQdRePlImA7muDdJCvlSdZw4z4eu0HEoa59WsQy6uwUI5aoI+nA5SGodwVGN5q6zskGwItpGV10z/bL3kNPTLoKm8VGuLWnhPcSJncZ7tjXj0rrw7qXFWCQbm4H6yGlt7V9eu87IwfM3NlpdtrjjhtEeRiULRGrK6Z1eVEGVpZIoFId1jXyRKphcnpqJERxBUnxDnOYCa+tzQhdo02AUAT04+7RFooglT/HOFIlRqJcsiFLCC3ttNx7ye+FyOmnjyDBzJFrpd+Mvt024tdlPbrU7V0AENWe//KX2WMTGScZ3RtpuWS8VSC7rZa1sbMc/vcuhbsKFCJrJ/7R0ssqgzKUe15aWjlSQ68ZM9n9KVhbo3VQYV2cionuDqkLHbchTrKtA2HSlYhPSxDq5v+2btGOcEXpX4W3ad5Hjy3dp3gOSZehZlXbZ9fy6udOgfxLfWv7wegIWQERefqOM4bP8rNUjG4lWjt9615ZQSD4Y29sDfd10EluGtl8QWGde0BAeinvTB53ThZVg0M6O5XoW7l5BbkrHlFkZR84NGi1n2LRQChsLuEKRMkR0Lhicq37Z7DhRQQt274ZgifkHnNTolvIjMJiR+HPcU5BcyrJ6JH58Yh65DMc3B9DYkOZAfmmbhIsr0ALLfmCkD8PyC3JhDu8u10F8gEzKsnokvnJDu4vh+uryHRh+svd/8D/f8SEt88J4jL4vrJhjgD3g1DgmiAB2/EdRE+hXAyrqzbCSC3JgiCIAiCIIhjQG5NEARBEARBEMeA3JogCIIgCIIgjgG59f+DSz1bfClliEPCsb+rKHrjIXr53QCuMH6uoANBEATx5+Bzay48w/jQH1L1RkS/sTL3BzrJXk4bHvAPJq7xKohvInwv9RCS76A9iFv/L/gdSwmCIIiDQG59NIIvBr2JEW6tPohwHGk+c3ioL3T85Eg9nFtnXo9Abk0QBEEQLXjc2v0qYPM01vnMmLmEv/2lvpWNzlzrjxrBzwMi3cwSqT/Iptt63OX5n2V2ToLBd8EKEzRt+3zlfi7OoURZm7XZqhjXFLbcNNVthbMd5RgVuwY7iGQoXcHI1rYHHO2D3scdYjQKlUkItKqEnhRGoZr1a071B93kp0MjzeG32hK628b1DNonoKuD85GuOg3+1l0SgiAIogP5c2uxoiTvwddtFOtc50S5/aC9XtThp+GhZt5HlB27Im6deCAVFoZt276qhGPnNJVxqprPeMbUs/pkKPwGrlsfxChlCMSzpSV5+VBCkWgo+hapj+6i0MabtKJ5p0OAWKzMkMCWJ+WERGmhkOsn9S0CgKi25q7qgRvxDEIyZbnxhLtZJgiCIAiLNLceuwe9r6WppTEo3z4xFZPXpi7VyZP9r/iZLFfABGsrjdvmfeU5xzfYLVFdB3ViJZuSU4Hr+5DYk7TJM+ueUAJV3xjSSbHxQMo7JDk9xwQ2pbV9u7tpnW/zunVbuu+daF1RezMWgSsIgiAIooUubq3uM0cnYBV2IuLxP69cob4ji25WN+4cO0upZ9cYt26fW6MzsA5fVcdsyDkNZezZpOoam+Ap6VEfLBnEKGmIh+QQ7d0GOD31eCBW0h/JeYd0cOt+gU1Piv/gtPC68mLTz3+qpJHi1urxEKy548bhewjCCnJrgiAIoheHn1vLm7H5s1hQnv7LqozAXbl5je419x6noR7cW8hgCR/yVcY5SE5V4HQ9rGSR4EseNiRp4CdOQB+PHg/0cWtQJ++QDtv7BTY9mTzxnZZlLsNiXpZJ7L+OOLeGJvTGIraC3JogCILoQfB+a/V8Q6GI9tpD1JI85IjnrR+P++tJynWW0qfl7hS6NqmjO88u0f86b62aa23wnpCQLrR9paixdY4CkI8Zg3CBlQ1r2oNq9HBzueDEyDVE6oShY9EZSoOm230PNKg56L3XIaHYQJmsQC+gg89bb7aKa96zzlBzqxByb+DGVigdHdTIs6kuMzQJgiCI30X07Zhys7W61dq+dV/92f40z5NZbK2EVHnFk3QZLvRt0so7dtWvV1iS59ZannlzgWzb5SvZvG2zUMNU8rvWcYc1lXD1XACQ7OqLL4xw60dfKBHwUHQ9kDtYxb13OgRav+sZKpMSCDcqyg8BGbU+9/982BelfhbFp3kOti5tN6IZJHVwXYTTILk1QRAE4eDXvsv45lMIBEGcgY9OXD74QRAEQRyHH+PWyXcHEgRxNurnVz47ccmtCYIgiOPwU9yaSyhB/DfwHq36TE9MDARBEMQx+CluTRAEQRAEQRAfBLk1QRAEQRAEQRwDcmuCIAiCIAiCOAb/AGd62HmMqhaRAAAAAElFTkSuQmCC
orabbix 插件监控oracle之权限设定sql语句
1,账号创建,指定数据及临时表空间profile及账号状态;
create user zabbix identified by ruiy default tablespace system temporary tablespace temp profile default account unlock;
2,给账号赋权限
grant connect,resource,dba 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;
3,针对oracle-11G还需执行如下一条语句
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 =>'*');
4,检验一下上面的配置结果
select utl_inaddr.get_host_name('127.0.0.1') from dual;
页:
[1]