Submitted by: Egor Puzanov

Description:

This Monitoring ZenPack provides Oracle Database monitoring. There is a community.sql.OracleDatabaseMap zCollectorPlugin that the device will need to use.

zProperties:

• zOracleConnectionStrings - 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]

Screenshots:

Installation Requirements:

• Zenoss Versions Supported: 2.5 and 3.0
• ZenPack Dependencies:
  • RDBMS Monitoring
  • SQL Data Source
• External Dependencies:
  • Oracle Database Instant Client
  • cx_Oracle (install as zenoss user, on zenoss 2.5.2: easy_install cx_Oracle, on zenoss 3.x: easy_install-2.6 cx_Oracle)

History:

Change History:

• 1.0 initial release
• 1.1 removed Oracle data source
• 1.2 calculate database usage based on MAXBLOCKS values, added thresholds

Tested: This ZenPack was tested with versions 2.5 and 3.0.

Source: https://github.com/epuzanov/ZenPacks.community.OracleMon

Tagged Releases:

• https://github.com/epuzanov/ZenPacks.community.OracleMon/tree/oraclemon-1.0
• https://github.com/epuzanov/ZenPacks.community.OracleMon/tree/oraclemon-1.1
• https://github.com/epuzanov/ZenPacks.community.OracleMon/tree/oraclemon-1.2

Known issues: