MMG Monitor Configuration

The following settings are configured in installer/bin/config.sh and control the bundled Prometheus, Node Exporter, and Oracle DB Exporter components used by OFS MMG monitoring.

Table 5-2 Configured Settings in config.sh

Setting What it controls Allowed values Default Impact / behavior
MMG_PROMETHEUS_PORT Port used by Prometheus Provide a free TCP port 9090 Changes the Prometheus listen port. Any local consumers of the bundled Prometheus service must use the same port.
MMG_PROMETHEUS_SCRAPE_INTERVAL Global Prometheus scrape interval Provide a Prometheus-compatible duration string 30s Lower values collect metrics more often but increase load and storage growth. Higher values reduce load but make monitoring data less granular.
MMG_PROMETHEUS_EVALUATION_INTERVAL Global Prometheus rule evaluation interval Provide a Prometheus-compatible duration string 30s Controls how often Prometheus evaluates rules. In the current checked-in config.sh, no rule files are defined, so this matters only if rules are added separately.
MMG_PROMETHEUS_RETENTION_TIME How long Prometheus keeps stored metrics Provide a Prometheus-compatible retention string 15d Higher retention keeps more history but uses more disk. Lower retention reduces disk usage but keeps less history.
MMG_PROMETHEUS_DATA_DIR Directory used by Prometheus to store TSDB data Any path string ${FTPSHARE_DIR}/mmg/monitor/prometheus/data The installer creates this directory. It must be writable and should have enough disk space.
MMG_NODE_EXPORTER_PORT Port used by Node Exporter Provide a free TCP port 9100 Changes the Node Exporter listen port. The same port is written into the generated Prometheus scrape target.
MMG_MONITORING_ENABLED Replaces the following parameters:
  • MMG_PROMETHEUS_ENABLED
  • MMG_NODE_EXPORTER_ENABLED
  • MMG_ORACLEDB_EXPORTER_ENABLED

This parameter controls controls whether the monitoring tools are enabled/disabled

true, false false When set to true, Prometheus, Node Exporter, and OracleDB Exporter are started. When set to false, these tools are not started; as a result, monitoring data is not collected and the Health tab does not display updated information.
MMG_MONITORING_SSL_CRT Mandatory if MMG_SSL_ENABLED is set to true. Valid path to PEM certificate file No default value. User needs to set the value to true. The ports exposed by Prometheus, Node Exporter, and OracleDB Exporter are now TLS protected.
MMG_MONITORING_SSL_KEY Mandatory if MMG_SSL_ENABLED is set to true. Valid path to PEM certificate file No default value. User needs to set the value to true. The ports exposed by Prometheus, Node Exporter, and OracleDB Exporter are now TLS protected.
MMG_ORACLEDB_EXPORTER_PORT Port used for the Oracle DB Exporter scrape target Provide a free TCP port 9161 This value is written into the generated Prometheus scrape target. In the current scripts, it is not passed as a startup argument to the oracledb_exporter process.
MMG_ORACLEDB_EXPORTER_LOG_ENABLED Oracle DB Exporter log disable flag 0, 1 0 Written to the exporter config as log.disable. 1 disables exporter logging in that config; 0 leaves it enabled.

Oracle DB Exporter Prerequisite

If MMG_ORACLEDB_EXPORTER_ENABLED=true, the OFS MMG config schema must have read access to the Oracle dynamic performance and DBA views used by the exporter. These privileges may be granted individually, or through an existing role such as SELECT_CATALOG_ROLE, if that role already provides the required access.

GRANT SELECT ON SYS.GV_$SESSION TO <MMG_CONFIG_SCHEMA>;
GRANT SELECT ON SYS.GV_$RESOURCE_LIMIT TO <MMG_CONFIG_SCHEMA>;
GRANT SELECT ON SYS.GV_$ASM_DISKGROUP_STAT TO <MMG_CONFIG_SCHEMA>;
GRANT SELECT ON SYS.GV_$INSTANCE TO <MMG_CONFIG_SCHEMA>;
GRANT SELECT ON SYS.GV_$DATAFILE TO <MMG_CONFIG_SCHEMA>;
GRANT SELECT ON SYS.GV_$SYSSTAT TO <MMG_CONFIG_SCHEMA>;
GRANT SELECT ON SYS.GV_$PROCESS TO <MMG_CONFIG_SCHEMA>;
GRANT SELECT ON SYS.GV_$SYSTEM_WAIT_CLASS TO <MMG_CONFIG_SCHEMA>;
GRANT SELECT ON SYS.GV_$PARAMETER TO <MMG_CONFIG_SCHEMA>;
GRANT SELECT ON SYS.GV_$DATABASE TO <MMG_CONFIG_SCHEMA>;
GRANT SELECT ON SYS.GV_$SQLSTATS TO <MMG_CONFIG_SCHEMA>;
GRANT SELECT ON SYS.GV_$SYSMETRIC TO <MMG_CONFIG_SCHEMA>;
GRANT SELECT ON SYS.DBA_TABLESPACE_USAGE_METRICS TO <MMG_CONFIG_SCHEMA>;
GRANT SELECT ON SYS.DBA_TABLESPACES TO <MMG_CONFIG_SCHEMA>;
GRANT SELECT ON SYS.DBA_TEMP_FREE_SPACE TO <MMG_CONFIG_SCHEMA>;