Database Administrator

OGG target checkpoint table drop Repair Method OGG target checkpoint table drop Repair Method Reference: OGG Replicat Failed Due To Check_point Table beingTruncated (Document ID 1319832.1) 1. First, start repfull reports the following error: GGSCI

Add a new service to InfluxDB in CentOS7.3 Operating System: CentOS7.3.1611 _ x64 Go language version: 1.8.3 linux/amd64 InfluxDB version: 1.1.0 Here, we use the syncd service as an example to record the process of adding a new service to

MSSQL installation in Redhat/CentOS 7 As Microsoft continues to develop towards Linux, from the beginning of Bash on Ubuntu on Windows (see for Ubuntu on Windows installation in Windows) to the current leadership of Microsoft under Satya Nadella,

New Features of Oracle 12C-online migration of table partitions or subpartitions Oracle 12c: new feature-online migration of table partitions or subpartitions. It is no longer necessary to migrate table partitions or subpartitions to different

Test the synchronization of Single-host OGG to Oracle 11 gb db in Linux 1. Install goldengate Software1. test environment:OS: RedHat 6 64bitDB: Oracle 11.2.0.3 64bitView OS and DB versions[Oracle @ redhat6 ~] $ Uname-Linux redhat6 2.6.32-131.0.15.el6

Compile and install the latest version of Redis Stable Currently, REDIS has been upgraded to 3.0.5 as the most stable version, but many system sources are not updated. Therefore, compile and install REDIS here. Suitable for all systems # Wget# Tar

[Translated from mos] Enable encryption for Redo Transport OF DataGuard, and enable dataguardredo Enable encryption for mongouard's Redo Transport Source:Enabling Encryption for Data Guard Redo Transport (Document ID 749947.1) Applicable:Oracle

Beckham _ redis key value learning, Beckham _ rediskey key value Redis General (key) Type 1. What is a general key type? 2. View General commands Iii. General examples         I. general type It is literally translated from the word generic, so it

The "pitfalls" and key points encountered during Oracle RAC installation (2), oraclerac (1) install dependency packages In addition to system configuration parameters, installing Oracle in Linux is another Trivial operation. This installation

Beckham _ redis installation and deployment, and Beckham _ redis deploymentInstall Redis and expand php Redis 1. Download Redis-Related FilesIi. Install RedisIii. phpredis extended Installation   1. download relevant files in this document 1. Redis:

[Mysql] the disadvantage of external key cascade and cascade, mysql key-level disadvantage When creating a table, you can set delete and update to cascade. An example is used to describe the concept of cascade of Foreign keys. Assume that a

Differences between common storage engines of Beckham _ mysql and the storage engine of Beckham _ mysqlStorage engine differencesBrief:1. Storage Engine2. Differences between myisam and innodb   I. Storage Engine 1. What is a storage engine? In

Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE, 1175 tried 1 error description 19: 15: 34 call sp_store_insert (90) Error Code: 1175. you are using safe update mode and you tried to update a

Expdp when encountering ORA-39097 & ORA-39065 & ORA-39079 & ORA-06512 & ORA-24033, expdpora-39097Expdp ORA-39097 & ORA-39065 & ORA-39079 & ORA-06512 & ORA-24033In expdp, various errors are reported. I am also drunk. The version is 11.2.0.1, And the

Introduction to text file output (skipped ):1. Run this as a command instead: output the result to the command line or script2. Number of steps in the file name: If you run the steps in multiple copies, the number of copies will be included in the

Recently, some netizens have been paying attention to CYQ. Data performance issues. Although they have been paying attention to, they have not found anyone who has actively Written Performance Evaluation articles with other frameworks. I am usually

1. Oracle: select * from ( select row_.*, rownum rownum_ from ( query_SQL ) row_ where rownum == min  2. SQL Server:

Some special usage is easy to forget when the SQL statement was previously written. I have sorted out the SQL statement operations to make it easier for me to write SQL statements. I want to paste them here and take a look, at the same time, I hope

BKJIA featured translations] Oracle 11g R2 extends many new feature suites for backup and recovery, including recovery manager RMAN, many of which are extensions for earlier features. BKJIA editing recommendations: New features and application

PD reverse engineering: using windows Data Source Management to create ODBC Data sources 1. Open the control panel and manage tools   2. Open the data source   3. Select the database type you want to operate on, such as SQL Server) 4. Enter