vim /etc/profileexportORACLE_HOME=/usr/lib/oracle/18.5/client64exportTNS_ADMIN=/usr/lib/oracle/18.5/client64/networkexportLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/libexportPATH=$PATH:$ORACLE_HOME/binexpor
8. 再设置执行的环境变量,命令行直接执行如下命令export: export DATA_SOURCE_NAME=用户名/密码@ 数据库服务名注意:某些字符在xshell中执行需要转义 如:我这里的用户名密码是 system/root12#$ export DATA_SOURCE_NAME="system/oracle12#\$@ORCL" 9.执行vim /opt/minitor/prometheus/prometheus.yml,添加以下配置...
export DATA_SOURCE_NAME=<用户名><密码>@<数据库服务名> export LD_LIBRARY_PATH=$ORACLE_HOME/lib 1. 2. 3. 4. 5. 6. 7. 修改bash_profile完成后,执行source ~/.bash_profile下面这步由root用户执行 然后编辑/etc/ld.so.conf文件,将LD_LIBRARY_PATH的路径加入最后一行 /opt/oracle/product/19c/db...
笔者写好的获取iops的sql如下:select sum(decode(name,'physical read IO requests',value,'physical write IO requests',value,0)) as iops, sum(decode(name,'physical read bytes',value,'physical write bytes',value,0)) / 1024 / 1024 as mbps from v$sysstat where name in ('physical read IO req...
name: oracledb-secret-test # 根据业务需要调整成对应的名称 namespace: oracledb-demo # 根据业务需要调整成对应的命名空间 type: Opaque stringData: datasource: "oracle://test:123456/127.0.0.1:1521/ORCLPDB1" # 对应 OracleDB 连接串信息 # test为用户名,123456为用户密码,127.0.0.1为数据库IP或者域名...
dsn = kingpin.Flag("database.dsn", "Connection string to a data source. (env: DATA_SOURCE_NAME)", ).Default(getEnv("DATA_SOURCE_NAME", "")).String() dsnFile = kingpin.Flag("database.dsnFile", "File to read a string to a data source from. (env: DATA_SOURCE_NAME_FILE)", ...
Prometheus Oracle database exporter. Contribute to iamseth/oracledb_exporter development by creating an account on GitHub.
/bin/sh# 监控测试环境oraclesource.env_var/.9161_192.168.11.8_PDB1_ZABBIX.DBnohuporacledb_exporter--log.levelwarn --web.listen-address :9161--custom.metrics./custom_metrics/performance_metric.toml>>./logs/9161_192.168.11.8_PDB1_ZABBIX.DB.log&...
export DATA_SOURCE_NAME="system/oracle12#\$@ORCL" 9.执行vim /opt/minitor/prometheus/prometheus.yml,添加以下配置文件(红色部分): 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 scrape_configs: # The job name is added as a label `job=<job_name>` to any timeseries scraped fromthisconfi...
6. 使配置完的环境变量生效 #source ~/.bashrc 7.进入/opt/minitor/oracleDb,执行以下命令为oracledb_exporter.linux-amd64赋权。 chmod +x oracledb_exporter.linux-amd64 8. 再设置执行的环境变量,命令行直接执行如下命令export: export DATA_SOURCE_NAME=用户名/密码@ 数据库服务名 注意:某些字符在xshell中...