Database Administrator

Summary of Oracle 11g undo_retention and retention guarantee Undo records the pre-image of the modified data block, but it is not the copy of the original data block, but a change vector. The real consistent read requires the use of CR blocks, the

Range of the interval partition store in Parameter Oracle 11g introduced interval partitions. In the past, partitions were manually or semi-automated scripts to implement partition expansion. However, the emergence of such interval partitions

ORA-00257 archiving logs full resolution April 3, 2016 Customer environment: Linux + RAC Client account login, error prompt: ORA-00257: archiver error. Connect internal only, until freed   Use PUTTY to connect to the server Enter the Oracle account:

[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

Synchronize table data between Oracle and SQL Server Synchronize some tables in SQLServer2008 to the Oracle database. We can use the linked server and SQLAgent to synchronize data between different database types. Instance 1:SQLServer2008 has a

MySQL 5.6.x multi-instance ConfigurationPrerequisites For testing, the installation is in binary mode, which is simple, convenient, and fast.MySQL-5.6.x binary version installation record I do not like to configure multiple instances in mysqlmulti

CentOS6.2 download and install MongoDB 3.0.4 CentOS6.2 download and install MongoDB 3.0.4 1.: wget http://fastdl.mongodb.org/linux/mongodb-linux-x86_64-3.0.4.tgz 2. Unzip and install Tar-zxvf mongodb-linux-x86_64-3.0.4.tgz Music mongodb-linux-x86_64-

MySQL High Availability DRBD + Heartbeat + MySQL1. Architecture Mysql: Master 10.24.6.4: 3306 VIP: 10.24.6.20 The VIP and mysql must be in the same network segment; otherwise, the ping fails.2. References 3. DRBD shared memory settings Shared Hard

How to automatically start PDB Pluggable Database in Oracle 12c PDB Pluggable Database is an important new feature of 12c, but for PDB in CDB, all PDB is not brought when CDB is started by default, in this way, we need to manually alter pluggable

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

Install MySQL 5.5.35 in the source code of Ubuntu 14.04 The Ubuntu-14.04-desktop-amd64 is installed. During this process, I made a low-level error. When I installed the partition in Ubuntu, I divided the partition in free space. However, the windows

Install MySQL and Security Optimization Using yum on CentOS 0. Description The advantage of yum installation is that you don't have to solve the dependency problem between software by yourself. Basically, after yum is executed, the software is

Try Redis: getting started with RedisOpening Redis is a NoSQL database that stores data using key-value pairs. Key-value pairs store data based on a key. Then you can use this key to retrieve the stored value. AvailableSETThe command uses the key

MySQL monitoring tool-orzdba Source code: http://code.taobao.org/p/orzdba/src/trunk/[Root @ bkjia servers] # chmod + x orzdbaConfigure your MySQL verification information in line 1 of the Code: username, password, socket, host, port[Root @ bkjia

Oracle 11g RAC manual gi psu patch (11.2.0.4.8)I. Preparations 1. database environment Operating system version: RedHat 6.5x64Database Version: Oracle 11.2.0.4 x64 RACGrid: 11.2.0.4Oracle database: 11.2.0.42. Prepare the content Gi psu: p21523375_112

Solve the Problem of mysql stop fail in Ubuntu I recently encountered a MySQL stop fail problem when I was studying mysql. Here I will write down the problem and the solution process, not how difficult it is, however, I did not find a valid Chinese

Oracle Shared Server Configuration 1. Exclusive server (dedicatedserver) Each session is assigned a serverprocess independently. Resources occupied by the process are released only when the user disconnects. In most cases, sessions are idle, so

Install MySQL Binary Package for RedHat Linux Enterprise 6.4 Download MySQL and upload it to the server 1. Download the mysql binary installation package from the Mysql official website. Https://edelivery.Oracle.com/osdc/faces/SearchSoftware? _

Oracle 11g RAC two-node root. sh execution error: one case Only record the Oracle 11g rac installation process once 1. The installation of multi-path software using RHEL6.5 multipath using udev to configure the ASM shared disk failed. At that time,

Solution for Oracle 11g forgetting SYS and SYSTEM passwords Oracle 11g forgets the SYS and SYSTEM passwords. The answer is simple: change the password! 1. First, log on to the SYS account using the operating SYSTEM authentication method and change