Plugin info

name: ora-listener-status

Collects the availability status for database listeners

Prerequisites

• Linux
  • User Groups: oinstall, dba
• Windows
  • Group Memeberships: ORA_HOMENAME_DBA

Events

• myrmex/ora-listener/status/oracle-home/listener/down set to 1 when listener down
  • Dimensions
    • oracle-home: the ORACLE_HOME for the listener
    • listener: the name of the listener
• myrmex/plugins/error/plugin/msg set to error message on plugin execution failure
  • Dimensions
    • plugin the name of the plugin that failed

Configuration

Plugin is configured with a yaml file:

• source: the value that will appear as the source of metrics generated by this configuration. defaults to plugin hostname
• oracle_home: path to listener ORACLE_HOME
• tns_admin: optional path to listener TNS_ADMIN
• timeout: execution timeout in duration format (opens new window). Defaults to 10s
• listeners: list of listeners to monitor
  • <name>: the name of the listener

Example Configuration

# set listener ORACLE_HOME path
oracle_home: /u01/app/oracle/product/12.2.0.1/dbhome_1
# path to tns admin directory
tns_admin: /u01/app/12.2.0.1/grid/network/admin
# the list of listeners to check
listeners:
  - LISTENER

Validate Configuration

ora-listener-status --run-conf /path/to/config/file.yaml --validate

Testing

Run the plugin from the command line and get any emmited events on stdout

ora-listener-status --run-conf /path/to/config/file.yaml

List events emmited by this plugin

ora-listener-status --events