Database Administrator

Alter system archive log current/all/switch logfile Alter system switch logfile;Force log switching is performed on the current instance in a single instance database or RAC to archive the current redo log. If automatic archiving is not enabled

Enable MySQL remote connection in Linux How to enable MySQL remote connection in Linux. By default, the root user of MySQL can only access MySQL locally and cannot remotely connect to and manage MySQL databases. How can I enable MySQL remote

Problems encountered during upgrading MySQL 5.1.61 to 5.6.19 in CentOS 6.3 and Their Solutions Environment: MySQL 5.1.61 Operating System: CentOS 6.3 Objective: To upgrade to MySQL 5.6.19 First, yum is not feasible. because the yum source is not

Using Keepalived to build master-master MySQL Replication Overview: MySQL-HA has many implementation solutions. It is common to use master + keepalived to implement MySQL-HA. The two MySQL instances have a master-slave relationship and use

Install MySQL 5.6 using the source code in Linux MySQL is an open-source database, so it can be installed based on the source code. Source code-based installation provides more flexibility. That is to say, we can select a suitable compiler for our

Key to enterprise application of NoSQL The discussion about whether NoSQL can be competent for enterprise-level databases is rampant. The focus of attention is that the environment of NoSQL databases is uncertain and changing. Some NoSQL enterprises

Bug of rain and Oracle GoldenGate in Jinan, oraclegoldengateJinan is raining now (am). However, my mood is best described by Qi Qin's Song-"relentless rain, gently wake me up and make my tears ice like rain"I have just confirmed a bug of ogg in the

[MongoDB] Eight optimization skills and eight MongoDB skillsTip 1: Minimize disk access to memory much faster than disk access. Therefore, the essence of optimization is to minimize disk access.The read speed of the memory is 1 million times faster

Solution to slow query caused by high water level line and water level line As we all know, with the continuous DML operations on table records, the high watermark line (HWM) of the table will be continuously improved. After the DELETE operation,

SELECT field FROM table WHERE a field Like condition, selectwhereSQL provides four matching modes for conditions: 1. %: Represents any 0 or multiple characters. It can match any type and length of characters. In some cases, if it is Chinese, use

Missing filename opening checkpoint file., openingcheckpointGGSCI (hosta) 48> view report dpfull**************************************** *******************************Oracle GoldenGate Capture for OracleVersion 11.2.1.0.27 19591627 OGGCORE_11.2.1.0.

The host SHUTDOWN experiment fails to be shut down normally due to host commands. SHUTDOWN has the following parameters: SHUTDOWN NORMAL: NORMAL is also the default clause, and the execution condition is No new connections are allowed after the

SQL Injection and SQL Injection In the past, when I was working on the student information management system and data room charging system, SQL injection was a common problem, but I did not really understand what SQL injection was like. it was not

Oracle 11g RAC manually uninstall grid, no deinstall, griddeinstall1. log on to the ORACLE_HOME page of the grid as the root user. [Root @ db01] # source/home/grid/. bash_profile[Root @ db01] # cd $ ORACLE_HOME/crs/install/ 2. Execute the

Use explain to analyze and optimize the view performance composed of multiple tables (more than three tables ). View: Create or replace view FLOW_SUBMITPROCESS_V Select pi. START_USER_ID _, pir. STARTUSERID, pi. PROC_INST_ID _, pir. PROCESSINSTID,

An example of SQL SERVER database attack Recently, it was found that the SERVER on the internet is inexplicably restarted. This SERVER currently mainly starts the IIS and SQL SERVER services. Remote Login, found that the system reaction is slow,

Oracle _ view, oracle View Oracle _ view ① View1. A view is a virtual table.A view is built on an existing table. The tables created by the view are called base tables.The statement that provides data to the view is a SELECT statement, which can be

Centos6.5 installation Oracle11gR2 (64-bit), centos6.5 installation tutorialCentos6.5 install Oracle11gR2 (64-bit) and centos6.5 (My virtual machine environment) 1. Download The centos6.5 installation package. For example: 2. Download the oracle

The agent slave Database Host cannot be found when the slave database is created in EM12c, And the em12cagent Symptom:When you use EM12cR4 to create a slave database, you cannot find the slave Database Host, but the slave Database Host

Difference between truncate table and delete, truncatetable Truncate table requires the drop table permission, which completely clears a table. Logically, the truncate table is the same as the delete table, or the drop table + create table is the