摘要：
1.在线安装[root@localhost plugins]#grafana-cli plugins install vertamedia-clickhouse-datasource[root@localhost plugins]#systemctl restart grafana-server.s 阅读全文
posted @ 2021-07-06 09:45
slnngk
阅读(335)
评论(0)
推荐(0)
摘要：
切换成集成模式 GGSCI (ora11g) 77> stop repepGGSCI (ora11g) 63> alter repep, integrated 2021-07-01 14:05:58 INFO OGG-06594 Replicat REPEP has been altered. Ev 阅读全文
posted @ 2021-07-01 14:10
slnngk
阅读(885)
评论(0)
推荐(0)
摘要：
ogg版本:12.3.0.1 1.停掉主库的相关进程GGSCI (rac01 as goldengate@slnngk1) 30> stop dpepSending STOP request to EXTRACT DPEP ...Request processed. GGSCI (rac01 as 阅读全文
posted @ 2021-07-01 10:54
slnngk
阅读(342)
评论(0)
推荐(0)
摘要：
1.停掉从库的ogg相应的进程GGSCI (ora11g) 46> stop repep Sending STOP request to REPLICAT REPEP ...Request processed. GGSCI (ora11g) 47> stop mgrManager process i 阅读全文
posted @ 2021-06-30 17:45
slnngk
阅读(120)
评论(0)
推荐(0)
摘要：
1.投递pump进程的Write部分的rba与rep复制进程一致,说明数据已经完成同步 主库 GGSCI (rac01) 101> info dpep,showch EXTRACT DPEP Last Started 2021-06-30 15:55 Status RUNNING Checkpoin 阅读全文
posted @ 2021-06-30 16:02
slnngk
阅读(145)
评论(0)
推荐(0)
摘要：
1.编辑主库的抽取进程，加上如下红色部分参数 GGSCI (rac01) 53> view params extep extract extep userid goldengate, password AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVC 阅读全文
posted @ 2021-06-30 14:41
slnngk
阅读(200)
评论(0)
推荐(0)
摘要：
1.查看新增的磁盘[root@localhost ~]# fdisk -l Disk /dev/sda: 42.9 GB, 42949672960 bytes, 83886080 sectorsUnits = sectors of 1 * 512 = 512 bytesSector size (lo 阅读全文
posted @ 2021-06-24 11:49
slnngk
阅读(166)
评论(0)
推荐(0)
摘要：
[root@es02-010007081131 dumpbackup]# more /home/script/backup/mysql_dumpbackup.sh #!/bin/bash . /etc/profile . ~/.bash_profile backup_date=`date "+%Y% 阅读全文
posted @ 2021-06-24 11:29
slnngk
阅读(921)
评论(0)
推荐(0)
摘要：
mysql -h localhost -uroot -p123456 -N -s mysql> select id,unit_name from region_ext_info limit 30;4311231002 五星岭林场机关43012116000 江背镇五美卫生院110000000000 北 阅读全文
posted @ 2021-06-22 17:40
slnngk
阅读(888)
评论(0)
推荐(0)
摘要：
环境: Python:3.6.5 Cratedb:4.5.1 写入程序 #!/usr/bin/env python #coding=utf-8 from crate import client import os, time, datetime ##client = Client(host='192 阅读全文
posted @ 2021-06-21 17:53
slnngk
阅读(242)
评论(0)
推荐(0)
摘要：
1.安装python3.5可能使用的依赖yum install openssl-devel bzip2-devel expat-devel gdbm-devel readline-devel sqlite-develyum install gcc 2.到python官网找到下载路径, 用wget下载 阅读全文
posted @ 2021-06-21 16:00
slnngk
阅读(600)
评论(0)
推荐(0)
摘要：
创建数据字典视图SQL> @?/rdbms/admin/catalog.sql如下：@/u01/app/oracle/product/12.2.0.1/db_1/rdbms/admin/catalog.sql创建PL/SQL的软件包和过程SQL> @?/rdbms/admin/catproc.sql 阅读全文
posted @ 2021-06-16 09:18
slnngk
阅读(210)
评论(0)
推荐(0)
摘要：
环境情况源库:os:Centos 7db版本:12.2.0.1endianness格式: little 当前运行模式:单机目的库:os:Centos 7db版本:18.3.0.0endianness格式: little当前运行模式:单机(带dataguard,单机->2节点的rac)1.查看操作系统 阅读全文
posted @ 2021-06-15 16:50
slnngk
阅读(358)
评论(0)
推荐(0)
摘要：
CREATE PROCEDURE `sp_optimize_table`() BEGIN declare l_delete_date varchar(16); declare l_state_date varchar(16); declare l_dutyno int; declare l_row_ 阅读全文
posted @ 2021-06-10 08:45
slnngk
阅读(446)
评论(0)
推荐(0)
摘要：
OS:Centos 7DB:18.3.0.0 1.在其中一个节点上执行如下命令(当前数据库是在open模式,数据库在关闭模式下也可以删除)[oracle@rac01 ~]$ dbca -silent -deleteDatabase -sourceDB slnngkEnter SYS user pas 阅读全文
posted @ 2021-06-09 10:20
slnngk
阅读(578)
评论(0)
推荐(0)
摘要：
SQL> startup mount ORACLE instance started. Total System Global Area 2466249080 bytesFixed Size 8898936 bytesVariable Size 671088640 bytesDatabase Buf 阅读全文
posted @ 2021-06-08 17:38
slnngk
阅读(432)
评论(0)
推荐(0)
摘要：
环境:主库:2节点RAC备库:1单节点数据库版本:18.3.0.01.配置静态监听在主库的2个节点上的配置文件添加相应的对应项(grid用户下) 节点1vi /u01/grid/grid_home/18.0.0/network/admin/listener.ora [grid@rac01 admin 阅读全文
posted @ 2021-06-08 16:34
slnngk
阅读(147)
评论(0)
推荐(0)
摘要：
2021-06-06T23:44:38.735686-04:00Errors in file /u01/oracle/app/diag/rdbms/slnngk/slnngk1/trace/slnngk1_j000_972.trc:ORA-12012: error on auto execute o 阅读全文
posted @ 2021-06-07 13:37
slnngk
阅读(353)
评论(0)
推荐(0)
摘要：
python 2.7环境 [root@localhost send_wrong_sql]# more send_fujin01.py #!/usr/bin/env python # -*- coding: UTF-8 -*- import smtplib from email.mime.multip 阅读全文
posted @ 2021-06-04 10:35
slnngk
阅读(52)
评论(0)
推荐(0)
摘要：
环境: OS:Centos 7 DB:18C 1.当前数据库以及在应用日志模式SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED 2 PDB$SEED READ ONLY NO 3 PDB1 READ ONLY NO 4 PDB2 READ ON 阅读全文
posted @ 2021-06-01 10:14
slnngk
阅读(200)
评论(0)
推荐(0)
摘要：
环境: 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 阅读全文
posted @ 2021-05-31 15:46
slnngk
阅读(1476)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2021-05-31 08:42
slnngk
阅读(87)
评论(0)
推荐(0)
摘要：
我这里的是dataguard环境,我尝试将从库删除进行重新配置，下面是报错个解决办法: [oracle@18c_single ~]$ dbca -silent -deleteDatabase -sourceDB ora18c[FATAL] [DBT-10201] Delete database op 阅读全文
posted @ 2021-05-28 11:29
slnngk
阅读(401)
评论(0)
推荐(0)
摘要：
环境: DB:12C OS:Centos 7 1.数据库启动然后启动所有的pdb CREATE OR REPLACE NONEDITIONABLE TRIGGER open_all_pdbs AFTER STARTUP ON DATABASE BEGIN EXECUTE IMMEDIATE 'alt 阅读全文
posted @ 2021-05-28 09:05
slnngk
阅读(86)
评论(0)
推荐(0)
摘要：
1.进入到MGMT日志目录 [grid@rac01 rdbms]$ cd /u01/grid/grid_base/diag/rdbms[grid@rac01 rdbms]$ cd ./_mgmtdb必须使用./-MGMTDB 阅读全文
posted @ 2021-05-28 08:50
slnngk
阅读(220)
评论(0)
推荐(0)
浙公网安备 33010602011771号