## 1.监控所需使用到的命令。


![image.png](http://175.178.83.16/static/img/bfcb3c168d6c2abd57eb33e0ee87a794.image.webp)


## 2.zabbix监控架构
- zabbix是cs客户端架构。

![image.png](http://175.178.83.16/static/img/a6aa4821e904e89e31f42d0645883246.image.webp)


## 3.安装Zabbix5.0

```shell
rpm -Uvh https://mirrors.aliyun.com/zabbix/zabbix/5.0/rhel/7/x86_64/zabbix-release-5.0-1.el7.noarch.rpm
```

```js
cd /etc/yum.repos.d
```

![image.png](http://175.178.83.16/static/img/e644601e4b4a03f9fc159f954fd7c3aa.image.webp)

更换阿里云仓库

```js
sed -i 's#http://repo.zabbix.com#https://mirrors.aliyun.com/zabbix#' /etc/yum.repos.d/zabbix.repo

```
### 3.1 安装zabbix服务端

```js
yum install zabbix-server-mysql zabbix-agent -y
```

### 3.2安装工具包，安装后不影响其他安装包的依赖。

```js
yum install -y centos-release-scl
```

:::warning{title="注意"}
安装后它会把文件放到 /opt/rh 目录下
:::



### 3.3改zabbix.repo文件配置。

```js
vi /etc/yum.repos.d/zabbix.repo
```

![image.png](http://175.178.83.16/static/img/84f1047dd40a2e5a3b1359d776168611.image.webp)


### 3.4安装zabbix前端环境，且安装到scl环境下。

```js
yum install -y zabbix-web-mysql-scl zabbix-apache-conf-scl
```

### 3.5安装mariadb数据库

```js
yum install -y mariadb-server
```
### 3.6设置开机自动启动数据库

```bash
systemctl enable --now mariadb
```

### 3.7初始化数据库

```js
 systemctl status mariadb
```

![image.png](http://175.178.83.16/static/img/8c73e439c68fa9a8bfb3a7bb8a6b4a9b.image.webp)



```bash
mysql_secure_installation
```

![image.png](http://175.178.83.16/static/img/f6f06edb9487ec0fe8a26accd9b54cf2.image.webp)

### 3.8登录数据库

```shell
mysql -uroot -p 
```

```sql
create database zabbix character set utf8 collate utf8_bin;
```
创建用户设置只能本地连接，并且设置密码。

```sql
 create user zabbix@localhost identified by '123456789';
```

对zabbix用户进行授权

```sql
grant all privileges on zabbix.* to zabbix@localhost;
```
刷新授权
```sql
 flush privileges;

```
### 3.9导入数据

```bash
zcat /usr/share/doc/zabbix-server-mysql-5.0.34/create.sql.gz | mysql -uzabbix -p zabbix
```

### 4.0修改zabbix的server配置文件，修改数据库的密码。

```
vi /etc/zabbix/zabbix_server.conf
```

![image.png](http://175.178.83.16/static/img/58425d6382c68da1fce68848eec92992.image.webp)
:::info{title="相关信息"}
把DBPassword注释去掉，填写数据库密码。
:::

### 4.1修改zabbix的php配置

```js
vi /etc/opt/rh/rh-php72/php-fpm.d/zabbix.conf
```

```js
php_value[date.timezone] = Asia/Shanghai
```

![image.png](http://175.178.83.16/static/img/6230f787f208bba2edcdc8db000e6368.image.webp)

### 4.2启动zabbix服务器。

```bash
systemctl restart zabbix-server zabbix-agent httpd rh-php72-php-fpm
systemctl enable zabbix-server zabbix-agent httpd rh-php72-php-fpm
```

### 4.3访问zabbix
ip/zabbix

```js
默认登录账号密码
Admin
zabbix
```
## 4.Zabbix server is not running: the information displayed may not be current报错问题

1、查看防火墙和selinux是否关闭

```js
systemctl stop firewalld 			///关闭防火墙
setenforce 0				///关闭selinux
```
2、查看数据库是否启动

```js
status mariadb			///查看数据库启动状态
start mariadb			///启动数据库
```

:::info{title="详细看此连接"}
https://blog.csdn.net/VillianTsang/article/details/104315962
:::

1.Zabbix的安装

## 1.下载portainer

```js
docker pull portainer/portainer
```


## 2.运行如下命令即可 打开可视化服务

```bash
docker run -d -p 9000:9000 --restart=always -v /var/run/docker.sock:/var/run/docker.sock --privileged=true portainer/portainer
```

16.Docker可视化工具portainer

## 查询各个数据文件的详细信息


```js
select * from dba_data_files;
```
## 创建数据库表空间并且自动增长


```js
create tablespace daxt datafile 'd:\app\administrator\oradata\orcl\DAXT.dbf' size 100m autoextend on;
```
## 查询数据库中所有用户的信息

 
```js
select * from dba_users;
```
## 创建数据库用户、指定表空间及授权角色



```
create user '用户名' identified by '密码' default tablespace daxt temporary tablespace temp;
grant dba to '用户名';
```
## 删除数据库用户

```
drop user '用户名' cascade; 
```
## 数据库还原


```js
imp userid=用户名/密码@orcl file=D:\路径.dmp log=D:\日志.log  buffer=30720 commit=no full=yes grants=yes ignore=yes indexes=yes rows=yes show=no constraints=yes
```

## 数据库导出

```js
exp userid=用户名/密码@orcl owner=数据库名 compress=n file=数据库导出路径文件.dmp 
```