- 博客(306)
- 资源 (13)
- 收藏
- 关注
原创 centos7.6 安装 rlwrap-0.45报 Requires: /usr/bin/python3
【代码】centos7.6 安装 rlwrap-0.45报 Requires: /usr/bin/python3。
2023-10-09 16:04:40 478
原创 postgresql 15.2 + redhat linux 7.9 安装: postgis-3.2.4
适用范围pg 14+问题概述pg15 需要安装postgis问题原因解决方案################ 系统环境:安装: postgis-3.2.4##########
2023-06-09 09:23:36 1218
原创 redis参数说明
##########ADVANCED CONFIG##########activerehashing yesaof-rewrite-incremental-fsync yesclient-output-buffer-limit normal 0 0 0#该配置表示,对于 Pub/Sub 客户端来说,若 output-buffer 占用内存达到 32M 或者超过 8M 的时间达到 60s,则关闭客户端连接client-output-buffer-limit pubsub 32mb 8mb 60client
2023-03-20 23:53:35 236 1
原创 ERROR 1129 (00000): Host ‘xxx‘ is blocked because of many connection errors; unblock with ‘mysqladmi
ERROR 1129 (00000): Host 'xxx' is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts'
2022-10-24 10:23:39 605
转载 resetlog之后继续增量恢复
RMAN> list incarnation ;using target database control file instead of recovery catalogDB 关键字 Inc 关键字 DB 名 DB ID STATUS 重置 SCN 重置时间1 1 TEST 1978860036 PARENT 1 30-8月 -052 2 TEST 1978860036 PARENT 534907 05-3月 -093 3 TEST 1978860036 PARENT 762990 10
2022-03-28 10:12:45 146
转载 oracle修改统计信息收集的节点
http://www.dba-oracle.com/t_packages_dbms_auto_task_admin.htmThe Oracle docs note this on automatic maintenance tasks:“In Oracle 11g, there is no GATHER_STATS_JOB. It has been now incorporated into DBMS_AUTO_TASK_ADMIN job along with Automatic segment ad
2021-09-23 22:37:22 288
原创 ORA-28040: No matching authentication protocol
oracle 12c以前版本的库的普及,一些应用还用旧版本的jdbc,如是就产生ORA-28040: No matching authentication protocol之类的问题。网上的解决方案两个,要么替换jdbc版本,要么修改sqlnet.ora中参数。就测修改sqlnet.ora参数:sqlnet.allowed_logon_version=8 12c 推出类似参数:SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10SQLNET.ALLOWED_LOGON_
2021-08-18 16:55:43 407
原创 oracle 12.2.0.1 opatch lsinventory时报LsInventorySession failed: RawInventory gets null OracleHomeInfo
[grid@node1 ~]$ opatch lsinventory -detail -oh /u01/app/12.2.0/gridOracle Interim Patch Installer version 12.2.0.1.25Copyright © 2021, Oracle Corporation. All rights reserved.Oracle Home : /u01/app/12.2.0/gridCentral Inventory : /u01/app/oraInve
2021-07-22 11:59:29 671
原创 postgresql13源码安装
./configuremakesumake installadduser postgresmkdir /usr/local/pgsql/datachown postgres /usr/local/pgsql/datasu - postgres/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfilestart/usr
2021-07-06 14:03:46 263
原创 2021-06-22
PDB Close ORA-65107 ORA-16078run{ALLOCATE CHANNEL ch00 TYPE ‘SBT_TAPE’ parms ‘ENV=(NB_ORA_CLIENT=hforclsrv01.hf.haier)’;ALLOCATE CHANNEL ch01 TYPE ‘SBT_TAPE’ parms ‘ENV=(NB_ORA_CLIENT=hforclsrv01.hf.haier)’;set until time “to_date(‘2021-06-22 03:20:00’
2021-06-22 20:13:49 145
原创 rac pdb database role service
rac pdb database role service主库srvctl add service -d ggc -s prim_db -l PRIMARY -r ‘ggc1,ggc2,ggc3’ -e SESSION -m BASIC -w 10 -z 10 -pdb hjksrvctl add service -d ggc -s stby_db -l PHYSICAL_STANDBY -r ‘ggc1,ggc2,ggc3’ -e SESSION -m BASIC -w 10 -z 10 -pdb
2021-06-21 17:11:32 275
原创 linux测试命令
linux加粗样式查网络,IO,CPUdstat -tnrcmd数据库监控:/opt/oracle.ahf/tfa/ext/oratop/oratop.RDBMS_11.2_LINUX.X64 ‘/ as sysdba’ -i 2 -diotop数据库SET SERVEROUTPUT ONDECLARElat INTEGER;iops INTEGER;mbps INTEGER;BEGIN– DBMS_RESOURCE_MANAGER.CALIBRATE_IO (, <M
2021-06-20 15:55:55 89
原创 ORA-00600: internal error code, arguments: [6856]
ORACLE Instance fdcdb2 (pid = 33) - Error 607 encountered while recovering transaction (788, 16) on object 1211616.2021-05-19T15:29:37.131499+08:00Errors in file /oracle/app/diag/rdbms/xx/xx2/trace/xxx2_smon_29051.trc:ORA-00607: Internal error occurr
2021-05-19 18:58:28 247
原创 proxysql现实读写分离和SQL路由
########################################## ProxySQL ###################################################配置 ProxySQL 所需账户在 Master 的MySQL 上创建 ProxySQL 的监控账户和对外访问账户create user 'monitor'@'%' identified by 'Monitor@123';grant all privileges on *.* to 'mo.
2021-05-13 17:12:52 230
原创 ORACLE数据库xtts跨平台迁移DB
xtts:1.源:execute dbms_tts.transport_set_check('DC',true,true);select * from TRANSPORT_SET_VIOLATIONS全备export TMPDIR=/home/db/oracle/xttsperl xttdriver.pl --backup传输全备scp backup/* root@192.168.66.144:/home/db/oracle/backupscp xtts/res.txt root.
2021-05-13 07:26:13 163
原创 利用impdp+network从11g迁移数据到19c
补充:1 IMPDP+network_link, 直接导入到目标库中(从dblink对应的远端库)2 EXPDP+network_link,直接将远端库上的数据,导出到本地机器上一、目标端dblinkCREATE PUBLIC DATABASE LINK conn_old_11g CONNECT TO system IDENTIFIED BY "oracle" USING '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL.
2021-04-14 15:37:20 741
原创 mydumper与mysqldump备份脚本
#!/bin/bash #export LANG=zh_CN.UTF8script_dir=/root/scripts#如果没有备份文件夹则建立.
2021-03-22 09:22:38 224
原创 dblink导致存储过程报异常ORA-03113:通信通道文件尾 ORA-02063紧接着line(xxxdblink名称) ORA-06512在(xxxx)line 24
从报错信息得知,报错在存储过程的24行: select count(1) into v_count1 from xxx.xxxx@xxxx where chsj<v_date;database link名称与报信息一致。通过网上查找,出现此类报错的原因,是database link使用过多并且没有释放导致 ,一般在使用dblink时会做commit或rollback操作,可以确认后台有没有释放的dblink 。查询后台没有释放的dblink的会话。(windows)一般p...
2021-03-11 10:53:41 4190
原创 gitee使用方法
1、在https:/gitee.com网站创建用户密码2、下载gitee.exe在windows上安装3、在windows上设置安装完后,提示窗口:4、设置ssh密码:a.第一步ssh-keygen -t rsa -C "xxxx@163.com"三次回车即可生成$ cat ~/.ssh/id_rsa.pubssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABgQDM42aoKozakQ/v6NQrY8Jh7/moIBfLMYV1aEJ3+pL4
2021-03-01 14:45:43 2825
原创 python实现对oracle访问操作
1、安装cx_Oraclepython -m pip install cx_Oracle2、连接db = cx_Oracle.connect('user','passwd','192.168.0.77:1521/orclpdb')3、生成cursorcursor= db.cursor()4、执行sqlrows.cursor.execute('select count(1) from user_tables') ;5、读取结果rows.fetchall()...
2021-02-25 15:33:37 127
原创 python实现MySQL指定表增量同步数据到clickhouse
python实现MySQL指定表增量同步数据到clickhouse,脚本如下:#!/usr/bin/env python3# _*_ coding:utf8 _*_from pymysqlreplication import BinLogStreamReaderfrom pymysqlreplication.row_event import (DeleteRowsEvent,UpdateRowsEvent,WriteRowsEvent,)import clickhouse_driverim
2021-02-25 15:24:58 1007 1
原创 mysql8.0.22 mysqlshell管理MGR
创建cluster:var cluster = dba.createCluster('testCluster', {'localAddress':'172.18.0.5:33061'})添加instance到cluster:cluster.addInstance('root@172.18.0.6:13306',{'localAddress':'172.18.0.6:33061'})删除instance:cluster.removeInstance('root@172.18.0.7:
2021-02-25 09:47:56 294
原创 MySQL时区参数
相关参数:system_time_zone:1.取自操作系统时区2.查看操作系统的时区命令: timedatectl, date -Rtime_zone:1、数据库会话时区参数2、 值为system时,取system_time_zone值3、可动态修改:set global time_zone='+8:00'4、永久添加/etc/my.cnf中 :default-time-zone = '+08:00'lc_time_names :日 与 ...
2021-02-03 16:54:21 653
原创 mysql8.0.22脚本实现自动安装
[root@localhost Dockerfile]# cat setup.sh#!/bin/bash#if [ $# -ne 2 ] ;then# exit#fiexport PATH=$PATH:/home/db/mysql/bin:/home/db/mysql/lib# MASTER=falseSLAVE=$1#slave_ip=$2source /etc/profileInit_env(){# pathmkdir -p /home/db/mysql /hom..
2021-01-09 15:06:30 432 1
原创 maxscale异常处理fail to open
maxscale异常分析日志文件:/var/log/maxscale/maxscale.log2021-01-08 11:15:51 error : Failed to open PID file '/var/run/maxscale/maxscale.pid'. (Permission denied)2021-01-08 11:23:38 error : Failed to open lock file /var/cache/maxscale/maxscale.lock: Permi...
2021-01-08 15:19:55 1775
原创 python xlrd xlwt实现批量读取execl内容,选取字段内容存储在汇总execl中
# codin=utf-8import osimport xlrdimport xlwtimport time # 引入time模块print(os.getcwd())os.chdir(r'D:\\宜昌\\2021-01(1)')path_execl_file = os.getcwd()col_key=[]col_item=[u'file',u'sheet',u'卡号',u'姓名',u'性别',u'身份证号']item = {}file = 'x.'num = .
2021-01-08 09:21:29 390
原创 virtualbox NAT访问外网设置
1、全局设定2、NAT设置3、虚拟机设置[root@localhost network-scripts]# pwd/etc/sysconfig/network-scripts[root@localhost network-scripts]# cat ifcfg-enp0s3TYPE=Ethernet# BOOTPROTO=dhcpDEFROUTE=yesPEERDNS=yesPEERROUTES=yes# IPV4_FAILURE_FATAL=no#IPV6INIT=y
2021-01-04 16:14:56 733
原创 MySQL日期分区表
CREATE TABLE `table1` ( `gid` bigint(20) NOT NULL COMMENT '主键', `mer_id` varchar(8) NOT NULL COMMENT '商户号', `file_id` bigint(20) NOT NULL COMMENT '所属文件的id', `file_name` varchar(60) NOT NULL COMMENT '文件名', `start_date` varchar(10) NOT NULL COMMENT...
2020-12-24 09:09:16 494 1
原创 maxscale-2.5.3-1安装与配置
https://mariadb.com/kb/en/mariadb-maxscale-25-mariadb-maxscale-configuration-guide/创建监控用户create user scalemon@'%' identified by "Scalemon@123"; grant replication slave, replication client on *.* to scalemon@'%';创建路由用户create user maxscale@'%' iden
2020-10-24 12:35:18 1472 1
oracle ass.awk工具
2020-10-15
analyze_binlog.py
2019-09-24
Oracle Enterprise Manager(12c安装文档
2016-09-28
oem12c+plugin+ogg agent
2016-09-28
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人