Database Administrator

Install MySQL 5.6.21 in CentOS 6.5Install MySQL MySQL is the most widely used database in Linux. The version installed using the online yum method lags behind several minor versions on the MySQL website. This section tests and installs the new

Notes for Oracle GoldenGate upgrade Oracle GoldenGate is being upgraded recently. refer to the following documents:How To Upgrade Goldengate From 11.2.1.x to 11.2.1.y for Oracle Database (Document ID 1601971.1)This document makes it clear:2. Stop

Compile and install MySQL 5.5.x and MySQL 5.5.x in Linux source code Linux: CentOS 6.5 MySQL version: 5.5.20, attached: [Click to download] 1. Install cmake MySQL 5.5 and later versions have been replaced by the cmake tool./configure compilation and

Navicat shortcut, navicatHot Keys Mian windows   Keys Action CTRL + G SettingsLocationFolder CTRL + # (# represents0to 9) Open Object Window from Favorites List F6 Console CTRL + H History

Steps for installing 11gR2 ASM single instance and 11gr2asm instanceEnvironment: Platform: VisualBox 4.3.12OS: Oracle Linux 5.8 Grid Infrastructure: 11.2.0.3Database: 11.2.0.31. Install the Operating System (omitted)2. Configure the software

Analysis of h2database source code and h2database Recently I want to take a good look at the principles of the database, download the source code of h2database, and have a good look. Some ideas in this process can be written down for the time being.

Mysql usage summary, mysql SummaryDatabase Management System (DBMS) DBMS, Database Management System Database Management, Simply put: is to manage a dataLarge software. DBMS manages and maintains data, or processes data security and

Windows 7 64-bit installation of oracle 11g R2 process, windows711g1. Download Oracle 11g R2 for Windows: Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.htmlThe package contains two packages:

Common oracle and oracle languages In Oracle development, the client sends SQL statements to the server, the server compiles and executes SQL statements, and returns the execution results to the client. An Oracle SQL statement consists of the

Oracle continuous data processing example, oracle Data Processing The function described in the following section is to have a table in the Oracle database, which stores continuous time records and a tag bit. Now you need to obtain a result set:

Stored Procedure Implementation paging, stored procedure Paging USE [HDIS]GO/***** Object: StoredProcedure [dbo]. [AspNetPager] Script Date: 12/30/2014 09:00:35 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCreate procedure [dbo]. [AspNetPager]

SequoiaDB notes, sequoiadb notesSequoiaDB notes In the past few days, I flipped through the SequoiaDB code and took notes. The correctness of the following content is not guaranteed (there must be something wrong)Personal View advantages The code

[Undo tablespace loss-restore-1], undo table loss-1Restore with rman -- undo lossRestore restores the file back;Recover redo with log files;Critical file loss and non-critical file loss (out of system/undo)1>Delete the undo file:[Oracle @ oracle ~] $

How to view User usage (recent logon, activity ...), Logon Activity 1. Make sure the database has opened Audit SQL> show parameter auditNAME TYPE VALUE----------------------------------------------------------------------------------------Audit_file_

[Oracle] export ledba15 To uniquely identify the archived log files for each incarnation of the databas, oracleincarnation You are using Oracle Database 10g. The log LOG_ARCHIVE_FORMAT pa Rameter is set to 'Log % t _ % _ s _ % r. dbf '. Why is % r

Oracle 11g backup-based rman duplicate, rmanduplicateBackup-based rman duplicate command to create standby databasePrerequisites: ensure the backup of the original database and archive is completely visible to the standby end,It is assumed that the

View the ogg target server process. [Oracle @ hosta ggs] $ ps-ef | grep serverroot 2945 1 0? 00:00:00/usr/bin/hidd -- serverroot 3342 1 0? 00:00:00/usr/libexec/gam_serveroracle 15624 3382 0 00:00:00 pts/1 grep server [oracle @ hosta ggs] $ [oracle @

Simple tutorial on SQL statements in linux --- UNION, simple tutorial --- union UNIONThe purpose of the command is to combine the results of two SQL statements. From this perspective,UNIONThis is somewhat similar to JOIN, because both commands can

[Chapter 3. Detailed Configuration [section A],Chapter 3. Configuration3.1. Groups Groups is defined in the NODE_GROUP table. The following SQL statement creates a node group for "corp" and "store" in the distribution store example. insertinto

[Chapter 3. Detailed Configuration [section B],3.4 Table Triggers Mongoricds uses a database trigger to capture the data to be synchronized. The TRIGGER of metrics ricds is defined in the TRIGGER table. SymmetricDS uses a row of records to generate