2020 年 12月随笔档案 - helontian

centos7 systemctl 管理MySQL

摘要：[root@ze11 ~]# ll /usr/local/mysqllrwxrwxrwx. 1 mysql mysql 35 Dec 22 21:52 /usr/local/mysql -> mysql-5.7.25-linux-glibc2.12-x86_64[root@ze11 ~]# ps - 阅读全文

posted @ 2020-12-22 22:42 helontian 阅读(495) 评论(0) 推荐(0)

Oracle11.2.0.4_Linux7静默安装

摘要：Oracle11.2.0.4_Linux7静默安装软件包 unzip linux.x64_11gR2_database_1of2.zip unzip linux.x64_11gR2_database_2of2.zip 操作系统环境配置编辑文件/etc/hosts 192.168.0.215 ze 阅读全文

posted @ 2020-12-16 22:46 helontian 阅读(206) 评论(0) 推荐(1)

问题处理：ORA-01157 ORA-01110

摘要：Oracle DG库报错 SQL> select * from w.v_result_detail;select * from w.v_result_detail *ERROR at line 1:ORA-01157: cannot identify/lock data file 201 - see 阅读全文

posted @ 2020-12-05 23:31 helontian 阅读(752) 评论(0) 推荐(0)

【PgSQL插件】性能分析pgbadger日志分析工具

摘要：环境介绍 # uname -aLinux p0-mcrm-midsrv-db01 4.18.0-553.58.1.el8_10.x86_64 #1 SMP Thu Jun 12 14:27:07 EDT 2025 x86_64 x86_64 x86_64 GNU/Linux# cat /etc/re 阅读全文

posted @ 2020-12-03 16:03 helontian 阅读(156) 评论(0) 推荐(0)