Difference between revisions of "Orabbix"
(→What can it monitor?) |
|||
| Line 25: | Line 25: | ||
* Sessions (Active Sessions, Inactive Sessions, System Sessions) | * Sessions (Active Sessions, Inactive Sessions, System Sessions) | ||
* DBSize/DBFileSize (DBSize size of database really used space and of Filesize) | * DBSize/DBFileSize (DBSize size of database really used space and of Filesize) | ||
| + | |||
| + | |||
| + | |||
| + | ===Orabbix Author=== | ||
| + | Andrea Dalle Vacche: http://www.smartmarmot.com | ||
| + | |||
| + | ===History=== | ||
| + | You can read about the history and evolution of the Orabbix plug-in in these threads below: | ||
| + | |||
| + | Original here: http://www.zabbix.com/forum/showthread.php?t=13666 | ||
| + | Latest here: http://www.zabbix.com/forum/showthread.php?t=16391 | ||
| + | |||
| + | ===Distribution=== | ||
| + | You can find the latest versions of Orabbix at the locations listed below: | ||
| + | |||
| + | http://www.smartmarmot.com/product/orabbix/download/ | ||
| + | or | ||
| + | https://sourceforge.net/projects/orabbix/ | ||
| + | |||
| + | |||
| + | ===Requirements=== | ||
| + | To use Orabbix, you will require the following on your Zabbix Server: | ||
| + | * Zabbix 1.8.x Server | ||
| + | * Java Runtime Environment 6 | ||
| + | |||
| + | Current known successfully tested Oracle host platforms: | ||
| + | * RHEL5.X (CentOS 5.4 & 5.5) | ||
| + | * Windows 2003 (with Java SE 1.6) | ||
| + | * HP-UX 11.31 | ||
| + | * AIX 5.3 | ||
| + | |||
| + | Currently known tested Oracle Versions: | ||
| + | * 10g | ||
| + | * 10.2 | ||
| + | |||
| + | ** IMPORTANT** | ||
| + | You do NOT need to install an Oracle client of any kind for Orabbix to work. | ||
| + | |||
| + | Orabbix uses Java objects and connection strings to connect to the Oracle Database, and as such doesn’t require an Oracle client to be installed on your Zabbix Server. | ||
| + | Installation | ||
| + | |||
| + | ===Assumptions=== | ||
| + | The installation instructions have been created based on instructions for most *nix deployments (i.e. RHEL/CentOS), and is assumed that any alterations required for your specific environment are to be taken into account accordingly. | ||
| + | |||
| + | This guide is based upon there being two (2) Hosts, 1x Zabbix Server and 1x Oracle Server. If you are planning on monitoring an Oracle instance that is running on your Zabbix Server, the steps are the same, with minor adjustments required for your connection information. | ||
| + | |||
| + | The steps also assume you are configuring Orabbix to monitor a new installation or setup of Oracle. The installation steps will have you GRANT access for the Zabbix user to all tables, and this will include any USER tables present at the time of execution. If you do not want Zabbix to have access to specific tables or resources within your database, you will need to set a DENY to the Zabbix users access as required. Consult your DBA for details, as this is beyond the scope of these instructions. | ||
| + | |||
| + | ===Steps for Installation=== | ||
| + | |||
| + | 1.Download Orabbix to your Zabbix Server | ||
| + | 2.On your Zabbix server, unzip Orabbix to: /opt/orabbix | ||
| + | 3.Copy file /opt/orabbix/init.d/orabbix to /etc/init.d/orabbix | ||
| + | 4.Grant execute permissions to the following files: | ||
| + | * /etc/init.d/orabbix | ||
| + | * /opt/orabbix/run.sh | ||
| + | 5.Create a User (ZABBIX) for Orabbix to access your Oracle Database. You can use the following script: | ||
Revision as of 16:11, 25 October 2011
Contents
Download & Installation Instructions
About Orabbix
Product Description
Orabbix is a plugin designed to work with Zabbix Enterprise Monitor to provide multi-tiered monitoring, performance and availability reporting and measurement for Oracle Databases, along with server performance metrics.
It provides an effective mechanism to acquire data from numerous Oracle instances, and in turn provides this information for monitoring and performance metrics to your Zabbix server. You can then utilize the reporting capabilities of Zabbix for all data collected, and provide analysis such as graphs and service level agreement metrics for stakeholders.
The current distribution contains a set of pre-defined templates which incorporate alerting and graphing capabilities from initial deployment. However these can be fine tuned to suit your needs and data/monitoring requirements.
What can it monitor?
Below are some examples of what Orabbix is capable of monitoring:
- DB Version (i.e. Validity of package)
- Archiving (Archive log production with trend analysis)
- Event Waits (Files I/O, single block read, multi-block read, direct path read, SQLNet Messages, Control file I/O, Log Write)
- Hit Ratio (Hit Ratio on Triggers, Tables/Procedures, SQL Area, Body)
- Logical I/O (Server performance on Logical I/O of: Current Read, Consistent Read, Block Change)
- Physical I/O (Redo Writes, Datafile Writes, Datafile Reads)
- PGA
- SGA (In particular; Fixed Buffer, Java Pool, Large Pool, Log Buffer, Shared Poolm Buffer Cache)
- Shared Pool (Pool Dictionary Cache, Pool Free Memory, Library Chache, SQL Area, MISC.)
- Pin Hit Ratio (Oracle library cache pin are caused by contention with the library cache, the area used to store SQL executables for re-use)
- Sessions / Processes
- Sessions (Active Sessions, Inactive Sessions, System Sessions)
- DBSize/DBFileSize (DBSize size of database really used space and of Filesize)
Orabbix Author
Andrea Dalle Vacche: http://www.smartmarmot.com
History
You can read about the history and evolution of the Orabbix plug-in in these threads below:
Original here: http://www.zabbix.com/forum/showthread.php?t=13666 Latest here: http://www.zabbix.com/forum/showthread.php?t=16391
Distribution
You can find the latest versions of Orabbix at the locations listed below:
http://www.smartmarmot.com/product/orabbix/download/ or https://sourceforge.net/projects/orabbix/
Requirements
To use Orabbix, you will require the following on your Zabbix Server:
- Zabbix 1.8.x Server
- Java Runtime Environment 6
Current known successfully tested Oracle host platforms:
- RHEL5.X (CentOS 5.4 & 5.5)
- Windows 2003 (with Java SE 1.6)
- HP-UX 11.31
- AIX 5.3
Currently known tested Oracle Versions:
- 10g
- 10.2
- IMPORTANT**
You do NOT need to install an Oracle client of any kind for Orabbix to work.
Orabbix uses Java objects and connection strings to connect to the Oracle Database, and as such doesn’t require an Oracle client to be installed on your Zabbix Server. Installation
Assumptions
The installation instructions have been created based on instructions for most *nix deployments (i.e. RHEL/CentOS), and is assumed that any alterations required for your specific environment are to be taken into account accordingly.
This guide is based upon there being two (2) Hosts, 1x Zabbix Server and 1x Oracle Server. If you are planning on monitoring an Oracle instance that is running on your Zabbix Server, the steps are the same, with minor adjustments required for your connection information.
The steps also assume you are configuring Orabbix to monitor a new installation or setup of Oracle. The installation steps will have you GRANT access for the Zabbix user to all tables, and this will include any USER tables present at the time of execution. If you do not want Zabbix to have access to specific tables or resources within your database, you will need to set a DENY to the Zabbix users access as required. Consult your DBA for details, as this is beyond the scope of these instructions.
Steps for Installation
1.Download Orabbix to your Zabbix Server 2.On your Zabbix server, unzip Orabbix to: /opt/orabbix 3.Copy file /opt/orabbix/init.d/orabbix to /etc/init.d/orabbix 4.Grant execute permissions to the following files:
- /etc/init.d/orabbix
- /opt/orabbix/run.sh
5.Create a User (ZABBIX) for Orabbix to access your Oracle Database. You can use the following script:
