Submitted by: Roman Tykhonov

Description:

With SNMP Trap destination setup in Oracle  Enterprise Manager it is the best way to monitor many Oracle Single  Instance/RACs for FREE. (if you have Oracle Standard Edition - Perfomance Tab have to be disabled due to Standart Edition Licence Agreement)

This ZenPack monitors Oracle databases with sqlplus and tnsping  (which need to be installed before use - see attached pdf).

It provides 3 templates (under  /Devices/Server) :

• ORACLE_INSTANCE
• ORACLE_INSTANCE_ADDITIONAL
• TNS_TEST

ORACLE_INSTANCE

Thresholds

• Cluster get block time
• Database Time Ratio
• Inter-Cluster ERRORS
• Shared Pool Free
• User Transaction Per Sec
  

Graphs

• User Transaction Per Sec
• IO
• Database Time Ratio
• System LOAD
• Redo Generated Per Sec
• Shared Pool Free
• Interconnect times
  
• Logons
• Inter-Cluster ERRORS
  

ORACLE_INSTANCE_ADDITIONAL

Thresholds

• Blocking Sessions
  

Graphs

• User Processes
• System User Processes
• Background Processes
• Blocking Sessions
• DBA Invalid Objects
• Listener FAULT
• Datafiles Using
• FLASH AREA
• ASM Volumes Using
  

TNS_TEST

Thresholds

• Negative answer TNS
  

Graphs

• TNS PING TIME
  

Screenshots:

REQUIREMENTS:

• Zenoss Version: 2.x (py2.4 file) and 3.x (py2.6 file)
  
• ZenPack Dependencies: n/a
  
• External Dependencies:
  • You have to install Oracle client before installation of the Zenpack. Be sure that you have sqlplus and tnsping (XE deb package does not have tnsping)

  • Create proper tnsnames.ora in $ORACLE_HOME/network/admin

• Installation: 
  • After installation you will need to restart zenoss stack.
  • Configure the following zProperties: zOracleDBInstance, zOracleHome,  zOraclePass and zOracleUser.
  • Bind the templates that you wish to use.
  • Look into 'Zenpack for Oracle Tips and Tricks.pdf'

Source: http://zenpacks.zenoss.org/trac-zenpacks/browser/zenpacks/ZenPacks.RomanTykhonov.OracleDB

• http://zenpacks.zenoss.org/trac-zenpacks/browser/zenpacks/ZenPacks.RomanTykhonov.OracleDB
• http://github.com/zenoss/Community-Zenpacks/tree/master//ZenPacks.RomanTykhonov.OracleDB/

Tagged Releases:

• http://zenpacks.zenoss.org/trac-zenpacks/browser/tags/oracledb-1.4
• http://github.com/zenoss/Community-Zenpacks/tree/oracledb-2.0

Change   History:

• 1.4 initial release - works only on 2.x
• 2.0 - slight changes and new step-by-step documentation - 
  
  • *-py2.6.egg.gz for Zenoss > 3.x
  • *-py2.4.egg.gz for Zenoss > 2.4

Trac  tickets:

http://zenpacks.zenoss.org/

Known   issues: