Templates Zabbix Oracle
Zbxora, a powerful Oracle plugin plus templatekisssmall footprinteasy to extendpython poweredresponsiveopen for feature requestsprimary databasesstandby databasesASM. Look at most relevant Zabbix oracle template websites out of 37.5 Thousand at KeyOptimize.com. Zabbix oracle template found at zabbix.com, github.com, slideshare.net. Canadian films list.
Ohai thare, I couldn’t find any decent documentation online about getting Zabbix configured with an Oracle backend so I decided to write one myself. The oracle installation section of this guide is based on John Smileys guide (available ), but has been adapted for 11GR2.
As usual I’ll be basing this on a CentOS 5.4 i386 installation. Please note that to install Oracle you need to have X11 installed. The requirements for an x64 installation are a little different.
I prefer to use X11 forwarding over SSH when it’s available I also need to note here that you can’t use su and then have X11 forwarding work. For the record, I’ve never used the Oracle Database product before this week, so I’m sure there’s bad practices all over the place.
If there is leave a comment and I’ll sort out my mistakes. Oracle Overview For those of you, who like me haven’t had to touch oracle before, I’ve drawn up a pretty picture which outlines how Oracle hangs together in terms of database design and storage. Oracle ASM is the Automated Storage management, which is capable of handling disk redundancy if requested. For those who have come from the land of MSSQL or MYSQL, the structure and terminology can get a bit confusing so I’ll explain it here: In MSSQL you have an Instance, which can contain multiple databases, with each database having its own file for storage.
In Oracle the Instance is called a Database. Each Oracle Database can contain multiple tablespaces, each tablespace can have one or multiple Datafiles assosciated with it which can be located on either an OS partition or an ASM Instance.
Oracle does not have “databases” in the same concept that MSSQL does, instead each user has a default tablespace and a schema assosciated to the user. For example, in MSSQL you could have a database called ZABBIXDB, and a user with permission to access this database. In Oracle you have a user (ZABBIXDBUSER) with a quota in one or more tablespaces. Each user has a default tablespace to store tables in, and each table is labeled zabbixdbuser.tablename. If you wanted to store a table on another tablespace you would use zabbixdbuser.tablename on tablespace. Oracle Installation In terms of physical hardware, I have a Dell PE2650 with 5 72GB SCSI drives installed, the first two are in a RAID1 and the other three are passed directly to the OS to be managed by ASM. I would highly recommend looking at the system requirements.
All of the commands that I list here in black will need to be run as root, the oracle user will be in dark green, and the zabbix user will be in dark blue. Downloads Required If you are going to be using Oracle ASM you’ll need to download the following from.
Zabbix Tutorial
Oracleasm-2.6.18-164.15.1.el5PAE-2.0.5-1.el5.i686.rpm /etc/sysctl.conf /etc/security/limits.conf /etc/pam.d/login /etc/profile /etc/csh.login 2000 -Insert your ASMSNMP Password if you are using ASM, else select where you want to store your database.No Automated Backups -Set Passwords as Required -Install -Run scripts as requested as root, if you get a prompt to overwrite files in /usr/local/sbin/ you can overwrite them. Database Configuration We need to set a number on ENVVARs across the server for the zabbix, apache and oracle users.
Zabbix Weblogic Template
I spent a good 2 days trying to figure out why zabbixserver couldn’t see the database. I would suggest either logging out and logging back in after setting these as we’ll be using them shortly, or just set them manually.