prometheus的oracle多套部署脚本与步骤

mahan

ORACLE:

[root@prometheus prometheus]# more prometheus.yml
# my global config
global:
  scrape_interval: 15s # Set the scrape interval to every 15 seconds. Default is every 1 minute.
  evaluation_interval: 15s # Evaluate rules every 15 seconds. The default is every 1 minute.
  # scrape_timeout is set to the global default (10s).

# Alertmanager configuration
alerting:
  alertmanagers:
    - static_configs:
        - targets:
          # - alertmanager:9093

# Load rules once and periodically evaluate them according to the global 'evaluation_interval'.
rule_files:
  # - "first_rules.yml"
  # - "second_rules.yml"

# A scrape configuration containing exactly one endpoint to scrape:
# Here it's Prometheus itself.

scrape_configs:
  - job_name: "prometheus"
    static_configs:
      - targets: ["localhost:9090"]
       # The label name is added as a label `label_name=<label_value>` to any timeseries scraped from this config.
        labels:
          app: "prometheus"

  - job_name: "Linux"
    static_configs:
      - targets: ["192.168.117.115:9100"]
        labels:
          alias: '监控系统'

  - job_name: "Windows"
    static_configs:
      - targets: ["192.168.110.197:9182"]
        labels:
          alias: '预约主数据库'
      - targets: ["192.168.110.199:9182"]
        labels:
          alias: '预约备数据库'
      - targets: ["192.168.115.202:9182"]
        labels:
          alias: '移动护理主数据库'
      - targets: ["192.168.115.192:9182"]
        labels:
          alias: '移动护理备数据库'
      - targets: ["192.168.116.130:9182"]
        labels:
          alias: '分诊主数据库'

  - job_name: "oracle"
    static_configs:
      - targets: ["192.168.117.115:9161"]
        labels:
          role: 'primary'
          instance_name: 'ydhl'
      - targets: ["192.168.117.115:9162"]
        labels:
          role: 'standby'
          instance_name: 'ydhldg'


  - job_name: "sqlserver"
    static_configs:
      - targets: ["192.168.117.115:9401"]
        labels:
          addr: "192.168.110.197:1433"
          role: "primary"
      - targets: ["192.168.117.115:9402"]
        labels:
          addr: "192.168.110.199:1433"
          role: "standby"
      - targets: ["192.168.117.115:9403"]
        labels:
          addr: "192.168.116.130:1433"
          role: "primary"

[root@prometheus prometheus]#



[root@prometheus ~]# cat /etc/systemd/system/oracledb_exporter@.service
[Unit]
Description=Oracle DB Exporter for %i
After=network.target

[Service]
Type=simple
EnvironmentFile=/opt/oracledb_exporter/config/%i.env
Environment="QUERY_TIMEOUT=15"
ExecStart=/opt/oracledb_exporter/oracledb_exporter --web.listen-address=:${EXPORTER_PORT}
Restart=on-failure

[Install]
WantedBy=multi-user.target



[root@prometheus ~]# cd /opt/
[root@prometheus opt]# ls -ltr
total 7260
drwxr-xr-x.  2 1001 1001    4096 Apr  7 23:50 node_exporter
-rw-r--r--.  1 root root 7412172 May 19 11:41 oracledb_exporter.tar.gz
drwxr-xr-x. 10 root root    4096 May 26 12:03 grafana
drwxr-xr-x.  2 root root    4096 May 26 12:07 soft
drwxr-xr-x.  3 1001  127    4096 May 27 19:01 oracledb_exporter
drwxr-xr-x.  3 1001  118    4096 Jun  3 14:37 prometheus
[root@prometheus opt]# cd oracledb_exporter/
[root@prometheus oracledb_exporter]# ls -ltr
total 25588
-rwxr-xr-x. 1 1001  127 26185988 Oct 24  2024 oracledb_exporter
drwxr-xr-x. 2 root root     4096 May 27 18:51 config
-rw-r--r--. 1 root root     4656 May 27 19:01 oracledb_custom_metrics.toml
[root@prometheus oracledb_exporter]# cd config/
[root@prometheus config]# ls -ltr
total 12
-rw-r--r--. 1 root root 156 May 27 17:38 hisdg.env
-rw-r--r--. 1 root root 158 May 27 18:24 his1.env
-rw-r--r--. 1 root root 158 May 27 18:24 his2.env
[root@prometheus config]# more his1.env
EXPORTER_PORT=9161
DATA_SOURCE_NAME=oracle://prometheus:sztech_4U@192.168.32.131:1521/orcl
CUSTOM_METRICS=/opt/oracledb_exporter/oracledb_custom_metrics.toml



[root@prometheus config]# systemctl status oracledb_exporter@his1.service
● oracledb_exporter@his1.service - Oracle DB Exporter for his1
     Loaded: loaded (/etc/systemd/system/oracledb_exporter@.service; enabled; vendor preset: disabled)
     Active: active (running) since Wed 2026-05-27 19:01:55 CST; 2 weeks 0 days ago
   Main PID: 67472 (oracledb_export)
      Tasks: 14 (limit: 98757)
     Memory: 19.7M
     CGroup: /system.slice/system-oracledb_exporter.slice/oracledb_exporter@his1.service
             └─ 67472 /opt/oracledb_exporter/oracledb_exporter --web.listen-address=:9161

Jun 11 12:19:24 prometheus oracledb_exporter[67472]: ts=2026-06-11T04:19:24.147Z caller=collector.go:324 level=error scrapeMetricContext=dg_lag ScrapeDuration=64.058583ms msg="No metrics found while parsing"
Jun 11 12:19:39 prometheus oracledb_exporter[67472]: ts=2026-06-11T04:19:39.141Z caller=collector.go:324 level=error scrapeMetricContext=dg_lag ScrapeDuration=76.993699ms msg="No metrics found while parsing"
Jun 11 12:19:54 prometheus oracledb_exporter[67472]: ts=2026-06-11T04:19:54.141Z caller=collector.go:324 level=error scrapeMetricContext=dg_lag ScrapeDuration=71.92831ms msg="No metrics found while parsing"
Jun 11 12:20:09 prometheus oracledb_exporter[67472]: ts=2026-06-11T04:20:09.150Z caller=collector.go:324 level=error scrapeMetricContext=dg_lag ScrapeDuration=65.539045ms msg="No metrics found while parsing"
Jun 11 12:20:24 prometheus oracledb_exporter[67472]: ts=2026-06-11T04:20:24.154Z caller=collector.go:324 level=error scrapeMetricContext=dg_lag ScrapeDuration=73.466211ms msg="No metrics found while parsing"
Jun 11 12:20:39 prometheus oracledb_exporter[67472]: ts=2026-06-11T04:20:39.136Z caller=collector.go:324 level=error scrapeMetricContext=dg_lag ScrapeDuration=76.327699ms msg="No metrics found while parsing"
Jun 11 12:20:54 prometheus oracledb_exporter[67472]: ts=2026-06-11T04:20:54.132Z caller=collector.go:324 level=error scrapeMetricContext=dg_lag ScrapeDuration=74.969616ms msg="No metrics found while parsing"
Jun 11 12:21:09 prometheus oracledb_exporter[67472]: ts=2026-06-11T04:21:09.159Z caller=collector.go:324 level=error scrapeMetricContext=dg_lag ScrapeDuration=77.350532ms msg="No metrics found while parsing"
Jun 11 12:21:24 prometheus oracledb_exporter[67472]: ts=2026-06-11T04:21:24.155Z caller=collector.go:324 level=error scrapeMetricContext=dg_lag ScrapeDuration=77.694042ms msg="No metrics found while parsing"
Jun 11 12:21:39 prometheus oracledb_exporter[67472]: ts=2026-06-11T04:21:39.152Z caller=collector.go:324 level=error scrapeMetricContext=dg_lag ScrapeDuration=70.086705ms msg="No metrics found while parsing"