1.只有承认无知，才能装下新的东西； 2.进步来自一点点滴滴的积累； 3.广博让你更优秀，而专业让你无法替代； 4.挫折和失败能够转换为一种财富。
访问量(1037779) 积分(1523) 等级(核心会员) 排名(6)
SELECT * FROM T1 INTO OUTFILE '/tmp/T1.csv'; ERROR 1227 (42000): Access denied; you need (at least one of) the FILE privilege(s) for this operation 使用如下方法绕过: mysql -h 主机 -u 用户 -p密码 -P端口 -D库 -Bse "select * from T1;" > /tmp/T1.csv
2024-05-11 13:41 450 0
sed -i "s/ngx_http_parse_multi_header_lines.*/ngx_http_parse_multi_header_lines(r, r->headers_in.cookie, /&iphp->sticky_conf->cookie_name, /&route) != NULL){/g" ngx_http_sticky_module.c
2024-05-09 09:16 565 0
在数据库在线备份的时候会与Load和ALTER TABLE <表名> ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE发生冲突导致这两种操作被挂起，而在MIS系统中数据库往往比较大（TB级别很常见），备份时候经常花费几个小时，甚至1天以上的时间。当我们急需上述两种操作的时候，就需要kill掉备份，一般步骤如下： #1 找到备份连接 [db2inst1@limt ...
2024-05-08 08:46 467 0
oracle@ORACLE ~]$ sqlplus /nolog SQL> conn /as sysdba; SQL>select userenv(‘language’) from dual; --查看服务端字符集 SQL>SHUTDOWN IMMEDIATE --关闭数据库 SQL>STARTUP MOUNT --启动到 Mount SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION; SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; SQL>ALTER SYSTE
2024-04-24 09:55 579 2
1.CZone（City Zone） CZone是指将数据中心部署在不同城市之间的多活架构。这种架构通过实现地理上的隔离，可以有效地降低整体系统的故障对在线业务可用性的影响。主要特点如下： 彼此之间的网络延迟相对较大，通常在几十到几百毫秒 数据中心间采用异地双活或异地多活方式部署业务，提高服务可用性 数据异步复制，可以容忍部分数据丢失 故障隔离...
2024-04-17 16:17 1063 0
mysql 5.7.33升级至mysql 5.7.44后无法启动 /var/log/mysql/mysqld.log日志报错： [ERROR] unknown variable 'myisam_repair_threads=1' [ERROR] Aborting 根本原因: https://docs.oracle.com/cd/E17952_01/mysql-5.7-relnotes-en/news-5-7-38.html mysql 5.7.38后已经废弃了myisam_repair_threads这个参数，在/etc/mysql.cnf文件中注释掉该...
2024-04-12 15:11 492 0
1.收集日志 mkdir /tmp/`date "+%Y-%m-%d"` db2pd -alldbs -wlocks > /tmp/`date "+%Y-%m-%d"`/wlocks.out db2 list applications show detail | grep -i lock > /tmp/`date "+%Y-%m-%d"`/app1.out db2pd -alldbs -lock showlocks wait -applications -transactions -dynamic > /tmp/`date "+%Y-%m-%d"`/db2pd.out
2024-03-07 08:47 598 0
Question & Answer Question In DB2 v10.x why receiving SQL5035N when connecting to database even if the database level is the same as the instance level? Cause In DB2 v10.x if the file ownership of the local database directory is wrong when connecting to database, SQL5035N will be received. The follo
2024-01-18 16:47 688 0
Problem 执行db2stop force，实例无法停掉并报错。 SQL1072C The database manager resources are in an inconsistent state. DB2 may have been incorrectly terminated, or another application may be using system resources in a way which conflicts with DB2’s use of system resources. System resource cleanup may be required
2023-11-29 11:00 754 0
stream{ server{ listen 3306; proxy_connect_timeout 1s; proxy_timeout 3s; proxy_pass 192.168.56..1xx:3306 } } 现在可以通过nginx代理的端口访问到内网的mysql服务了。这也直接避免了mysql直接暴露到公网，增加些许的安全。当然，利用stream也可以实现后端服务的负载均衡。
2023-11-28 13:49 639 0
oracle ORA-12514错误 su - oracle sqlplus / as sysdba show parameter local_listener; alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xxx.xxx.xxx)(PORT = 1521))';
2023-10-25 13:40 635 0
1.windows下mysql 8数据库启动报错： Windows服务无法启动 服务没有报告任何错误 解决方案如下： 2.解决方案，发现C:/xxxxx/mysql-xxx/data文件夹内容为空，判定为未进行初始化。 1.清空data目录 2.sc delete mysql 3.mysqld --initialize --console 4.mysqld --install 5.net start mysql 6.mysql -uroot -p<temp_password> 7.进...
2023-09-13 13:46 717 0
安装完数据库后自动启动EM，也可通过如下命令启停和查看 --启动 SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500); PL/SQL procedure successfully completed. --停止 exec DBMS_XDB_CONFIG.SETHTTPSPORT(0); --检查 SQL> select dbms_xdb_config.gethttpsport FROM DUAL; GETHTTPSPORT ------------ 5500 访问地...
2023-09-01 10:49 928 0
cd C:/Program Files/Oracle/VirtualBox C:/Program Files/Oracle/VirtualBox>VBoxManage list hdds C:/Program Files/Oracle/VirtualBox>VBoxManage closemedium disk "F:/vbox/tdsql03/tdsql03_1.vdi" --delete 0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
2023-08-20 10:12 796 0
fatal: [tdsql_chitu2]: FAILED! => {"changed": true, "cmd": "/usr/local/php/sbin/php-fpm -y /usr/local/php/etc/php-fpm.conf -c /usr/local/php/lib/php.ini", "delta": "0:00:00.618807", "end": "2023-08-17 11:00:11.993493", "msg": "non-zero return code", "rc": 70, "start": "2023-08-17 11:00:11.374686"
2023-08-17 11:09 1073 0
1.配置主机名 hostnamectl set-hostname tdsql01 hostnamectl set-hostname tdsql02 hostnamectl set-hostname tdsql03 hostnamectl set-hostname tdsql04 2.添加主机名映射 [root@tdsql01 ~]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost
2023-08-13 19:39 1598 0
[root@was01 ~]# su - oracle Last login: Tue Aug 8 17:06:37 CST 2023 on pts/0 [oracle@was01 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Wed Aug 9 03:22:05 2023 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to an idle instanc
2023-08-09 14:11 697 0
If manually executing "sqlplus / as sysdba", then sqlpus will not return any message and hung. From ps command result, there are no background processes generated. The user id/group settings and permission for $ORACLE_HOME/bin/oracle at the issue node are same with the normal node. strac
2023-07-21 09:00 865 0
python文件转换为exe文件 很多时候python做了个程序只能自己用，那么如何复制的其他服务器上并允许。 1、运行cmd 2、输入pip install pyinstaller安装模块。 3、制作个python的文件，最后要有个input函数，否则会闪退。或者用time函数停顿也行。之后保存路径。 4、在cmd的DOS界面中输入，cd /d D:/pycharm ，切换到文件存放的需要的文件夹（根据...
2023-07-20 16:55 818 0
2022-08-16-15.22.17.651790-180 I1931E403 LEVEL: Warning PID : 11698 TID : 139894944950016 PROC : db2sysc 2 INSTANCE: db2dpf NODE : 002 HOSTNAME: hostHADR2 EDUID : 18 EDUNAME: db2fcms-0 2 FUNCTION: DB2 UDB, fast comm manager, sqkfT
2023-07-17 16:38 825 0
CNDBA社区
