开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
ZenPacks.community.OracleMon
文件大小： unknow
源码售价： 5 个金币 积分规则     积分充值
充值1元得10金币   
资源说明：Oracle Monitor ZenPack
================================
ZenPacks.community.OracleMon
================================

About
=====

This project is `Zenoss `_ extension (ZenPack) that
makes it possible to model and monitor Oracle databases.

Requirements
============

Zenoss
------

You must first have, or install, Zenoss 2.5.2 or later. This ZenPack was tested
against Zenoss 2.5.2, Zenoss 3.2 and Zenoss 4.2. You can download the free Core version of
Zenoss from http://community.zenoss.org/community/download

ZenPacks
--------

You must first install

- `SQLDataSource ZenPack `_
- `RDBMS Monitoring ZenPack `_

External dependencies
---------------------

You can use **pyisqldb** module provided by SQLDataSource ZenPack in combination
with Oracle ODBC driver, or install Python DB-API 2.0 compatible cx_Oracle
module. cx_Oracle can be installed with **easy_install-2.6** command as
**zenoss** user.

- **pyisqldb** - DB-API 2.0 compatible wrapper for **isql** command from
  `unixODBC `_. Oracle ODBC driver must be
  installed and registered with name "OracleDB".

  zOracleConnectionString example:

      ::

          'pyisqldb','DRIVER={OracleDB};SERVER=${here/dsn};UID=${here/zOracleUser};PWD=${here/zOraclePassword}',ansi=True,cp_good_sql='SELECT 1 FROM DUAL'

- `pyodbc `_ - DB-API 2.0 compatible interface
  to unixODBC. Oracle ODBC driver must be installed and registered with name
  "OracleDB".

  zOracleConnectionString example:

      ::

          'pyodbc',DRIVER='{OracleDB}',SERVER='${here/dsn}',UID='${here/zOracleUser}',PWD='${here/zOraclePassword}',ansi=True,cp_good_sql='SELECT 1 FROM DUAL'

- `cx_Oracle `_ - DB-API 2.0 compatible Pure-Python
  interface to the Oracle database.

  zOracleConnectionString example 1:

      ::

          'cx_Oracle','${here/zOracleUser}','${here/zOraclePassword}','${here/dsn}',cp_good_sql='SELECT 1 FROM DUAL'

  zOracleConnectionString example 2 (connect as DBA):

      ::

          'cx_Oracle','${here/zOracleUser}','${here/zOraclePassword}','${here/dsn}',mode=2,cp_good_sql='SELECT 1 FROM DUAL'

Installation
============

If you have an old version of this ZenPack installed, please uninstall it first.

Normal Installation (packaged egg)
----------------------------------

Download the `OracleMon ZenPack `_.
Copy this file to your Zenoss server and run the following commands as the zenoss
user.

    ::

        zenpack --install ZenPacks.community.OracleMon-1.3.egg
        zenoss restart

Developer Installation (link mode)
----------------------------------

If you wish to further develop and possibly contribute back to the OracleMon
ZenPack you should clone the git `repository `_,
then install the ZenPack in developer mode using the following commands.

    ::

        git clone git://github.com/epuzanov/ZenPacks.community.OracleMon.git
        zenpack --link --install ZenPacks.community.OracleMon
        zenoss restart


Usage
=====

Installing the ZenPack will add the following items to your Zenoss system.

Configuration Properties
------------------------

- zOracleConnectionString - connection string template.
- zOracleDSN - list of TSNs for Oracle Database Instances.
- zOracleUser - Username for the Oracle account.
- zOraclePassword - Password for the Oracle account
- zOracleTablespaceIgnoreNames - tablespace names to ignore
- zOracleTablespaceIgnoreTypes - tablespace types to ignore [PERMANENT, TEMPORARY, UNDO]

Modeler Plugins
---------------

- community.sql.OracleDatabaseMap

Monitoring Templates
--------------------

- OracleSrvInst
- OracleTablespace

Performance graphs
------------------

**OracleSrvInst**

- Transactions
- IO
- Database Time Ratio
- Load
- Redo Log
- Shared Pool
- Interconnect Times
- Logon rate
- Errors
- Sessions
- DBA Objects

**OracleTablespace**

- Usage

部分文件列表（点击文件名可查看文件内容）
本源码包内暂不包含可直接显示的源代码文件，请下载源码包。