export ORACLE_HOME=/usr/lib/oracle/11.2/client64
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_.ZHS16GBK
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
6. 使配置完的环境变量生效 source ~/.bashrc
7.进入/opt/minitor/oracleDb,执行以下命令为oracledb_exporter.linux-amd64赋权。
可以私聊我一下我发你资源
chmod +x oracledb_exporter.linux-amd64
8. 再设置执行的环境变量,命令行直接执行如下命令export:
export DATA_SOURCE_NAME=用户名/密码@ 数据库服务名 注意:某些字符在xshell中执行需要转义
如:我这里的用户名密码是 system/root12#$
export DATA_SOURCE_NAME="system/oracle12#\[email protected]"
9.执行 vim /opt/minitor/prometheus/prometheus.yml,添加以下配置文件(红色部分):
scrape_configs:
# The job name is added as a label `job=` to any timeseries scraped from this config.
- job_name: 'prometheus'
# metrics_path defaults to '/metrics'
# scheme defaults to 'http'.
static_configs:
- targets: ['ip:9090']
labels:
instance: prometheus
- job_name: oracle
static_configs:
- targets: ['ip:9161']
labels:
instance: oracle
10.启动oracle_exporter
nohup ./oracledb_exporter.linux-amd64 &
11.去prometheus自带的web页面上查看
![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLicmbw5SMxgTM1QjMxgTYhJGMkZTNwkzMhRGZzgTO2YWYiFzM58CX0JXZ252bj91Ztl2Lc52YucWbp5GZzNmLn9Gbi1yZtl2Lc9CX6MHc0RHaiojIsJye.png)
12.在grafana中查看配置状态(推荐使用3333)
13.效果图如下: