首页 > 数据库 >oracledb_exporter部署

oracledb_exporter部署

时间:2023-03-12 20:35:15浏览次数:60  
标签:exporter 部署 oracledb prometheus usr oracle 18.5

oracledb_exporter
服务端口:9161

部署

1.下载安装包并解压

安装包:oracledb_exporter.0.2.8-ora18.5.linux-amd64.tar.gz
解压:

tar -zxvf oracledb_exporter.0.2.8-ora18.5.linux-amd64.tar.gz -C /usr/local
cd /usr/local/ && mv oracledb_exporter.0.2.8-ora18.5.linux-amd64 oracledb_exporter

下载地址:https://github.com/iamseth/oracledb_exporter

2.下载并安装oracle客户端

oracle-instantclient18.5-basic-18.5.0.0.0-3.x86_64.rpm
oracle-instantclient18.5-sqlplus-18.5.0.0.0-3.x86_64.rpm
https://www.oracle.com/database/technologies/instant-client/downloads.html


oracledb_exporterer连接oracle数据库,需依赖oracle client,因此也要提前下载好oracle client。如果是Oracle 19C可用21版本的Client,如果是Oracle 11g可用18版本的Client,如果操作系统比较新(如是CentOS7以上),则可以装21,对于去连接Oracle 19C和11g,因为大版本是可向下兼容的。这边我用以前下载的18.5为案例,一个basic的rpm,一个sqlplus的rpm。

rpm -ivh oracle-instantclient18.5-basic-18.5.0.0.0-3.x86_64.rpm
rpm -ivh oracle-instantclient18.5-sqlplus-18.5.0.0.0-3.x86_64.rpm

3.oracle上创建监控用户

create user prometheus identified by xxxxxx;
grant connect,resource to prometheus;

4.配置监听文件

vim /usr/lib/oracle/18.5/client64/tnsnames.ora

prometheus =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = 实例名)
    )
  )

5.添加全局环境变量并验证远程sqlplus登陆

vim /etc/profile
export ORACLE_HOME=/usr/lib/oracle/18.5/client64
export TNS_ADMIN=/usr/lib/oracle/18.5/client64/network
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/lib
export PATH=$PATH:$ORACLE_HOME/bin
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export DATA_SOURCE_NAME="prometheus/xxxxxx@数据库ip:1521/实例名"
source /etc/profile

5.1验证是否可以登陆:

sqlplus prometheus/xxxxxx@数据库ip/实例名

6.配置环境文件

(全局变量改成env文件)

vim /usr/local/oracledb_exporter/oracle-env
ORACLE_HOME=/usr/lib/oracle/18.5/client64
TNS_ADMIN=/usr/lib/oracle/18.5/client64/network
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/lib
PATH=$PATH:$ORACLE_HOME/bin
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
DATA_SOURCE_NAME="prometheus/xxxxxx@数据库ip:1521/实例名"

7.采集器加入开机自启动

vim /etc/systemd/system/oracledb_exporter.service
[Unit]
Description=oracledb_exporter
After=network.target
[Service]
Type=simple
EnvironmentFile=-/usr/local/oracledb_exporter/oracle-env
User=root
ExecStart=/usr/local/oracledb_exporter/oracledb_exporter\
           --default.metrics /usr/local/oracledb_exporter/default-metrics.toml\
           --query.timeout=50\
           --web.listen-address=:9161
Restart=on-failure

加入开机自启动并启动
systemctl enable oracledb_exporter.service
systemctl status oracledb_exporter.service

配置加入prometheus

vim /etc/prometheus/prometheus.yml

  - job_name: 'oracledb'
    scrape_interval: 50s
    scrape_timeout: 50s
    static_configs:
    - targets: ['监控服务所在的服务器ip:9161']
      labels:
        instance: '10.120.100.2'
        tags: 'oracle数据库-10.120.100.2'

systemctl restart prometheus
systemctl restart grafana-server

加入告警规则

groups:
  - name: oracle-alerting
    rules:
    - alert: instance-down
      expr: up{job=~"oracledb"} == 0
      for: 2m
      labels:
        severity: high
        alertinfo: push_oracle_alert
      annotations:
        summary: "Instance {{ $labels.instance }} down"
        description: "{{ $labels.tags }} has been down for more than 2 min."
    - alert: tablespace_use_status
      expr: 100*(oracledb_tablespace_bytes{type=~"PERMANENT"}-oracledb_tablespace_free{type=~"PERMANENT"})/oracledb_tablespace_max_bytes{type=~"PERMANENT"} >95
      for: 2m
      labels:
        severity: high
        alertinfo: push_oracle_alert
      annotations:
        summary: "{{ $labels.tablespace }} 表空间不足高于95%"
        description: "{{ $labels.tablespace }} 表空间高于95%"

标签:exporter,部署,oracledb,prometheus,usr,oracle,18.5
From: https://www.cnblogs.com/haiyoyo/p/17208997.html

相关文章