Plugin info

name: ora-asm-status

Collects the availability status for an ASM instance

Prerequisites

• Linux
  • User Groups: oinstall, asmadmin, asmdba
• Windows
  • Group Memeberships: ORA_ASMADMIN, ORA_ASMDBA

Important, the connection to the database/ASM takes place over BEQ. This means that the process resource limits for myrmex-ad must match those set for the oracle database/ASM processes. Set these limits in the systemd unit file for myrmex-ad and then reload and restart the myrmex-ad service. Refer to https://www.man7.org/linux/man-pages/man5/systemd.exec.5.html#PROCESS_PROPERTIES (opens new window) for the process limit directives and their ulimit equivalents.

Events

• myrmex/ora-asm-status/sid/down set to 1 when ASM instance is down
  • Dimensions
    • sid the ASM SID
• 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
• timeout: execution timeout in duration format (opens new window). Defaults to 10s
• oracle_home: path to ASM ORACLE_HOME
• sid: ASM SID
• connect_as: (optional) one of sysdba, sysoper, sysasm. Default is sysdba

Example Configuration

# path to oracle_home for this asm instance
oracle_home: /u01/app/12.2.0.1/grid
# sid to check
sid: +ASM1

Validate Configuration

ora-asm-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-asm-status --run-conf /path/to/config/file.yaml

List events emmited by this plugin

ora-asm-status --events