06 2021 档案
摘要:1.停掉从库的ogg相应的进程GGSCI (ora11g) 46> stop repep Sending STOP request to REPLICAT REPEP ...Request processed. GGSCI (ora11g) 47> stop mgrManager process i
阅读全文
摘要:1.投递pump进程的Write部分的rba与rep复制进程一致,说明数据已经完成同步 主库 GGSCI (rac01) 101> info dpep,showch EXTRACT DPEP Last Started 2021-06-30 15:55 Status RUNNING Checkpoin
阅读全文
摘要:1.编辑主库的抽取进程,加上如下红色部分参数 GGSCI (rac01) 53> view params extep extract extep userid goldengate, password AACAAAAAAAAAAAKAPATACEHBIGQGCFZCCDIGAEMCQFFBZHVC
阅读全文
摘要:1.查看新增的磁盘[root@localhost ~]# fdisk -l Disk /dev/sda: 42.9 GB, 42949672960 bytes, 83886080 sectorsUnits = sectors of 1 * 512 = 512 bytesSector size (lo
阅读全文
摘要:[root@es02-010007081131 dumpbackup]# more /home/script/backup/mysql_dumpbackup.sh #!/bin/bash . /etc/profile . ~/.bash_profile backup_date=`date "+%Y%
阅读全文
摘要:mysql -h localhost -uroot -p123456 -N -s mysql> select id,unit_name from region_ext_info limit 30;4311231002 五星岭林场机关43012116000 江背镇五美卫生院110000000000 北
阅读全文
摘要:环境: 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
阅读全文
摘要:1.安装python3.5可能使用的依赖yum install openssl-devel bzip2-devel expat-devel gdbm-devel readline-devel sqlite-develyum install gcc 2.到python官网找到下载路径, 用wget下载
阅读全文
摘要:创建数据字典视图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
阅读全文
摘要:环境情况源库:os:Centos 7db版本:12.2.0.1endianness格式: little 当前运行模式:单机目的库:os:Centos 7db版本:18.3.0.0endianness格式: little当前运行模式:单机(带dataguard,单机->2节点的rac)1.查看操作系统
阅读全文
摘要: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_
阅读全文
摘要:OS:Centos 7DB:18.3.0.0 1.在其中一个节点上执行如下命令(当前数据库是在open模式,数据库在关闭模式下也可以删除)[oracle@rac01 ~]$ dbca -silent -deleteDatabase -sourceDB slnngkEnter SYS user pas
阅读全文
摘要:SQL> startup mount ORACLE instance started. Total System Global Area 2466249080 bytesFixed Size 8898936 bytesVariable Size 671088640 bytesDatabase Buf
阅读全文
摘要:环境:主库:2节点RAC备库:1单节点数据库版本:18.3.0.01.配置静态监听在主库的2个节点上的配置文件添加相应的对应项(grid用户下) 节点1vi /u01/grid/grid_home/18.0.0/network/admin/listener.ora [grid@rac01 admin
阅读全文
摘要: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
阅读全文
摘要: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
阅读全文
摘要:环境: 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
阅读全文