05 2021 档案
摘要:环境: OS:Centos 7 redis版本:4.0.15 背景:原来是2个节点组成的3主3从的集群,现在想修改为3个节点组成的3组3从的集群原来的集群部署拓扑:192.168.56.111:7001192.168.56.111:7002192.168.56.111:7003 192.168.56
阅读全文
摘要:explain plan forselect/*+ full(t) */ count(1) from xpi_childinfo partition(xpchild01) t where t.cid is not null;set timing on;查看执行计划select * from tabl
阅读全文
摘要:我这里的是dataguard环境,我尝试将从库删除进行重新配置,下面是报错个解决办法: [oracle@18c_single ~]$ dbca -silent -deleteDatabase -sourceDB ora18c[FATAL] [DBT-10201] Delete database op
阅读全文
摘要:环境: DB:12C OS:Centos 7 1.数据库启动然后启动所有的pdb CREATE OR REPLACE NONEDITIONABLE TRIGGER open_all_pdbs AFTER STARTUP ON DATABASE BEGIN EXECUTE IMMEDIATE 'alt
阅读全文
摘要:1.进入到MGMT日志目录 [grid@rac01 rdbms]$ cd /u01/grid/grid_base/diag/rdbms[grid@rac01 rdbms]$ cd ./_mgmtdb必须使用./-MGMTDB
阅读全文
摘要:环境: 主库:2节点rac 从库:单节点 数据库版本:18C 1. Rac主库上通过克隆的方法创建 SQL> create pluggable database pdb6 from pdb1; Pluggable database created. SQL> show pdbs CON_ID CON
阅读全文
摘要:1.主库添加了pdbSQL> create pluggable database pdb5 admin user jiangt identified by "oracle"; Pluggable database created. SQL> alter pluggable database pdb5
阅读全文
摘要:环境: 主库:2 节点RAC 从库:单节点 db:18c 1.主库上新增了一个pdb SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO 4 PDB2 REA
阅读全文
摘要:前提条件是要设置secure_file_priv,该参数是需要重启实例的 mysql> show variables like '%secure%';+ + +| Variable_name | Value |+ + +| require_secure_transport | OFF || secu
阅读全文
摘要:1.生成证书1.执行命令创建ca 执行:su - elasticsearch[elasticsearch@rac01 bin]$ cd /usr/local/services/elasticsearch/bin[elasticsearch@rac01 bin]$ ./elasticsearch-ce
阅读全文
摘要:es7.12集群部署环境:192.168.56.111192.168.56.112192.168.56.113 基础安装 系统配置 每个机器上都要执行 系统参数配置 修改limits.conf配置文件 vi /etc/security/limits.conf root用户下添加如下2两项,然后退出使
阅读全文
摘要:es集群部署环境:192.168.56.111192.168.56.112192.168.56.113 基础安装 系统修改配置 每个机器上都要执行 系统参数配置 修改limits.conf配置文件 vi /etc/security/limits.conf root用户下添加如下2两项,然后退出使用e
阅读全文
摘要:centOS7环境下安装jdk1.81.首先下载jdk1.8 去官网下载jdk:http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html 我这里下载的是 jdk-8u291-linux-x6
阅读全文
摘要:set line 1000; set head offset echo offset feed offset heads offset pages 50000SET NEWPAGE NONEspool bb.txtSELECT A.FMONITORCODEFROM tb_test A WHERE A
阅读全文
摘要:IM on ADG: End of Empty Journal Recovered data files to a consistent state at change 2066571stopping change tracking2021-05-14T06:09:07.839764-04:00Er
阅读全文
摘要:[test@test-cratedb-4nqdg11-prd zabbix_agentd.d]$ more mysql.conf UserParameter=check_sync_available,sh /etc/zabbix/scripts/check_sync_available.sh [ro
阅读全文
摘要:#!/bin/bashwx(){#将下面的webhook地址替换成你的企业微信机器人地址,$1为告警消息 $2为@人的手机号 $2可以为空cat > $0.msg << EOFcurl 'https://qyapi.weixin.qq.com/cgi-bin/webhook/send?key=0c5
阅读全文
摘要:安装ruby1.下载编译安装[root@localhost soft]# wget http://cache.ruby-lang.org/pub/ruby/2.4/ruby-2.4.1.tar.gz[root@localhost soft]# tar zxvf ruby-2.4.1.tar.gz[r
阅读全文