Database Administrator

Reset the MySQL root Password in CentOS There are many ways to reset the MySQL password in CentOS. The official website also provides convenient and quick operations. For details, refer to resetting permissions. To reset the password, follow these

Quick Configuration Guide for Oracle 11g Data Guard physical standby Database OriginI recently conducted a physical standby Database Configuration experiment for Oracle 10g and 11g, and found that Data Guard is actually very easy, but there is a

PL/SQL Developer log on to Oracle 12c After Oracle 12c is installed, PL/SQL Developer cannot connect to Oracle 12c. Search online and follow the instructions in fcflying, so take a note: 1) install Oracle 12c 64-bit :

MongoDB replica set building and adding/Removing Machines 1. replica set You must set the replica set name for each replica set. This parameter is specified when MongoDB is started. 2. Setup steps 2.1 start Start MongoDB first Set to replica set

Postgres-X2 deployment steps Sort 2015 elephant will, everyone is very concerned about PostgreSQL cluster, at present, developers have turned to Postgres-X2, recently according to their own and colleagues deploy xl process to deploy a Postgres-X2.

Common Methods for viewing Oracle execution plans-Series 1: oracle execution plans The SQL Execution Plan actually represents the specific execution steps of the target SQL in the Oracle database, only by knowing whether the execution plan selected

11gR2 RAC exclusive mode replace votedisk encounters PROC-26, restore ocr encounters CRS-4000, PROT-35, proc-26crs-4000 Link: http://blog.itpub.net/23135684/viewspace-748816/ The storage data of the 11gR2 RAC system is completely lost. The software

Use PL/SQL to generate random passwords, and plsql to generate1. Create a Function program CREATE OR REPLACE FUNCTION random_password(in_template IN VARCHAR2) RETURN VARCHAR2 IS l_criteria VARCHAR2(1); l_password VARCHAR2(500); l_pattern VARCHAR2

DB2 specifications-log , db2 log 8:40:23 on Tuesday morning 1. the overall specification keywords are capitalized, {} overall fast [] Option 1.2 note operator priority 1.3 Note link character 1.4 Delete duplicate row keyword distinct show 1.5 use

Oracle transparent data encryption (TDE) real-world use analysis, oracletde Since the R2 version of Oracle Database 1Og, a feature called TDE makes data encryption extremely easy. All we need to do is to declare a column as encrypted, and the rest

SQL statement implementation that limits the number of data queries in ORACLE and SYBASE databases. oraclesybase I. Overview For some software that needs to deal with a large amount of data through databases, processing performance is very

Oracle Database migration-basic and oracle database migrationOracle Database migration-Basics As a developer, We must master database knowledge. However, the company's database is maintained by a dedicated DBA. Generally, we provide an environment

2015 China Database Conference Mongodb sharing, 2015 mongodbThis article was shared by MongoDB Greater China technical consultant. When the "old man" came up, he asked what Mongo meant. He guessed the prize and claimed that he was the best MongoDB

Discuss SQLite database corruption and repair, and discuss sqlite DatabaseLast night, my friend and I reported whether the SQLite database can be recovered due to damage. The general situation is that when the database is used, it accidentally

Install redis in Windows and redis in Windows The following is a reference to the definition of apsaradb for redis: Redis is a key-value storage system. Similar to Memcached, Memcached supports more storage value types, including string, list, set,

The Microsoft Jet Database Engine cannot open the file '(unknown )'. It has been opened exclusively by other users. Deploying an asp program today took me more than an hour. It turns out that the read and write permissions of C: \ Windows \ Temp's

[Translated from mos] How To restore database and mosrestore when backup of control files is lost How can I restore the database when the backup of the control file is lost? Source:How to restore database when controlfile backup missing (Doc ID 14387

Mysql import data load data infile usage, mysqlinfile Mysql import data load data infile usageBasic Syntax: load data [low_priority] [local] infile 'file _ name txt '[replace | ignore] Into table tbl_name [Fields [Terminated by 'T'] [OPTIONALLY]

Tissot k1 k-ux And Oracle database, uxUp to now, Oracle database 12.1.0.2 has not passed the authentication on k-ux because the k-ux operating system is not in the list of authenticated operating systems, no authentication

SQL tracking and tkprof usage, SQL tracking tkprof usageBrief Introduction In oracle databases, awr is a report on the overall load and running status of the database system. However, when the system load is normal, and the client executes some