Database Administrator

MySQL Character Set details Character garbled characters are common and frequently asked questions in the database. In view of the fact that at most my level can only be attributed to non-streaming and so on, I am very worried about misleading

MySQL getting started Operating System: CentOS 6.7MySQL version: 5.6.30 1. Preparations 2. System Configuration 3. CMake compilation Configuration 4. make & make install 5. Subsequent configuration and Testing Reference 1. Preparations First,

The Oracle Database verifies whether the imported metadata of IMP overwrites the historical table data. Scenario: When imp imports data, the final trigger reports an error and exits without importing stored procedures, triggers, and functions.Now

Implementation of ASM Resizing in VirtualBox Implement online ASM resizing 1. First disable the Cluster[Root @ node1 bin] #./crsctl stop crs[Root @ node2 bin] #./crsctl stop crs Shutdown, halt Create two vdi disks on the first host, set the sharing,

Eight years of experience using NoSQL Mike Bowers, an Enterprise Data architect at Jesus Christ's late Saints Church (LDS), introduced eight years of experience using NoSQL databases at the recent Enterprise Data World Conference (EDW. He talked

RMAN backup reports RMAN-06059 Error RMAN backup reported RMAN-06059 error: RMAN-03002: backup plus archivelog command (on 00:08:52) failedRMAN-06059: failed to find the expected archive log, loss of archive log will affect recoverabilityORA-19625:

Redis cluster creation and deployment documentation Redis cluster creation and deployment documentation 1. Install dependencies (not always install so many dependencies. I have installed mysql and php in my environment, so I didn't need to test the

[ERROR] ORA-09945, ORA-09817 disk space is insufficient I. Problem DescriptionWhen you use client software to connect to the database, a ORA-09945, such as, is reported as there is no space as prompted. When using sqlplus to connect, an error

Oracle SQL * PLUS commands 1. Common Oracle SQL * Plus commands (1) Environment commands SET command format: SET The SHOW command can display the SQL * Plus environment parameter values. (2) common functionsSQL> set linesize x SQL> SET PAGESIZE y

Differences between translate and replace Today, the nesting of replace and translate in the Oracle database is a bit confused, so I went online and looked at it, and it suddenly became clear: The problems encountered today are as follows: Replace

Install MongoDB on Linux Install MongoDB on Linux. 1. Download the installation package and decompress tgz (the installation on 64-bit Linux is demonstrated below ). Curl-O https://fastdl.mongodb.org/linux/mongodb-linux-x86_64-3.0.6.tgz # download

MySQL Engine Features-InnoDB redo log roamingPreface InnoDB has two very important logs: undo log and redo log. The former is used to ensure the atomicity of transactions and the MVCC of InnoDB, and the latter is used to ensure transaction

Configuration Modification of MariaDB database storage path MySQL is not running, but lock file (/var/lock/subsys/mysql) existsThis problem is generally caused by three reasons:1: some files in the configuration are not authorized enough. Change all

Definition formats of basic Oracle statements Oracle built-in data typesI. character data1. char (size)2. varchar2 (size) is the most commonly used, with a maximum length of 4000 bytes.3. nvhar (size) and nvarchar (size)4. varchar (size)5. We

Zabbix uses the Orabbix plug-in to monitor Oracle databases (enhanced version) According to some information on the Internet, the installation finally found many problems, so I fixed some problems and recorded them. 1. Install jdk (Orabbix Server) 1.

Use pgpool to achieve high availability of PostgreSQL Pgpool-ii is used to achieve high availability of PG. Based on the stream replication method, two nodes are automatically switched: 1. Single pgpool A. Environment: Pgpool: 192.168.238.129Data1: 1

Oracle Reports ORA-01691 error, single data file size limit problem 1. Problem: an error occurs when the Oracle database synchronizes a large table from another database. ERROR at line 3: ORA-24801: illegal parameter value in OCI lob function ORA-020

Connect SQL plus to Oracle There are three methods for SQLPlus connection. 1. sqlplus/as sysdba Operating system authentication does not require the database server to start listener or the database server to be available. For example, if you

Error Caused by Oracle 11g import to 10g Environment Introduction Old Environment   New Environment   Operating System: RedHat5.8 64-bit   Redhat6.4 64-bit Database Version: Oracle 10.2.0.4 64-

Oracle 12c In-Memory Oracle introduced the In-Memory and columnar compression option In 12c, which greatly improves query performance. Here, we can see how much performance can be improved in the same query through a comparison. 1. allocate Memory