分类 Database 下的文章

MySQL故障记录：binlog日志占满磁盘导致MySQL故障

December 30, 2022
1. 故障描述一个服务接口突然报数据库连接异常，错误信息如下：2022-12-30-15-10 [qtp503642634-1677050] [com.itcoder.services.SignService] [ERROR] - checkCertAuthority:nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionE ......
<阅读全文>

Linux 编译安装 Redis-6.2.8

December 20, 2022
0. 安装要求redis配置文件统一保存在/etc/redis/目录下；redis工作目录指定为/var/lib/redis，DB文件和AOF文件保存在该目录。redis日志保存在/var/log/redis/redis.conf1. 下载 Redis下载地址：https://download.redis.io/releases/redis-6.2.8.tar.gz[root@redis ~]# mkdir downloads [root@redis ~]# cd downloads/ [root@redis downloads]# wget https://download.r ......
<阅读全文>

Shell脚本中通过sqlplus批量执行Oracle SQL语句

November 2, 2022
#!/bin/bash . /home/oracle/.bash_profile SID_SERVICE_NAMES=$(lsnrctl status | grep Service | egrep -v "Summary|XDB" | awk -F '"' '{print $2}') ORA_USER=sys ORA_PASS=syspass ORA_PORT=1521 ORA_HOST=localhost ORA_ROLE=sysdba # 多个oracle服务的情况下，for循环执行 for svc in ${SID_SERVICE_NAM ......
<阅读全文>