Database Administrator

ORA-14400: The inserted partition keyword is not mapped to any partition Problem description: When kettle is used to extract data from the original Library to the standard library, an error is reported during the extraction process: ORA-14400:

Install Redis in CentOS6 I. Download redis Official website address: http://redis.io/ If make is not installed in the system, see Wget http://download.redis.io/redis-stable.tar.gzTar xzf redis-stable.tar.gzCd redis-stableMake MALLOC = libcMake

New Features of MySQL 5.7 We are proud to announce that MySQL 5.7 stable version is available for download. MySQL 5.7.9 is an exciting new version of the world's most popular open-source database, which is three times faster than MySQL 5.6. It also

MySQL SQL _mode Mode Modification my. cnf 1. SQL _mode ModeThe mysql database has an environment variable SQL _mode, which defines the SQL syntax and data verification that mysql should support! You can view the SQL _mode used by the current

Data Types of MySQL Learning I. Data Types 1. value types: TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT, and DECIMAL2. Time type -- DATE, DATETIME, TIMESTAMP3. string type-CHAR, VARCHAR, TEXT4. Special types-ENUM and SETString case sensitive --

ASM learning Overview Oracle ASM (Oracle Automatic Storage Management)Oracle ASM is a volume manager and a file system for Oracle database files that supports single-instance Oracle DatabaseAnd Oracle Real Application Clusters (Oracle RAC)

Win remote ASM instance in Linux I. Windows ASM instances in remote Linux1. Listener files in Linux[Grid @ myrac1 admin] $ cat listener. ora# Listener. ora Network Configuration File:/g01/app/grid/product/11.2.0/grid/network/admin/listener. ora#

Upgrade Oracle 11.2.0.1.0 to 11.2.0.3.0 View the database version [Oracle @ RedHat6 ~] $ Sqlplus/as sysdba SQL * Plus: Release 11.2.0.1.0 Production on Fri Dec 6 21:12:32 2013 Copyright (c) 1982,200 9, Oracle. All rights reserved. Connected to an

ORA-01012: not logged on Processing SQL> startup nomountORA-01012: not logged onSQL> startupORA-01012: not logged on SQL> shutdown immediateThe ORA-24324: service handle not initialized.ORA-24323: value not allowedORA-01089: immediate shutdown in

MySQL monitoring tool-Innotop Innotop is a powerful MySQL monitoring tool. It uses perl to show the running status of MysQL servers and Innodb in text mode. Install innotop : Https://github.com/innotop/innotop Github provides two versions: The

About the field-based fuzzy query method of MongoDB About the field-based fuzzy query method of mongodb Fuzzy query: tname contains a keyword Test' Cd/opt/soft/mongodb/bin ./Mongo -- host 192.168.0.1 -- port 17017 test Db. test_info.find

ORA-00824: cannot set sga_target due to existing solution When I got home from work today, I received a call from a colleague, saying that after I used the Oracle9i client to connect to Oracle10g, some parameters were modified, so that Oracle10

MySQL paging Optimization This afternoon, I helped my colleagues rewrite a MySQL SQL statement that involves two tables, one of which is a dictionary table (a field needs to be returned ), the other table is a business table (which contains 150

Comparison between one-time transaction and CTE data insertion Sometimes we need to construct some data for testing, as shown below:IF OBJECT_ID (N 't14') IS NOT NULL BEGIN Drop table T14 END GO Create table T14 (t14_id INT) GO DECLARE @ I INT =

Principles and basic configurations of Oracle DataGuardRecently, the group is working on a disaster recovery solution for the high availability of Oracle. We chose the "maximum performance" mode of DG without affecting the performance of the master

Set Oracle 11gR2 to start automatically under CentOS6.5 Set Oracle 11gR2 to start automatically under CentOS6.5 1. Modify ORATAB as the root user (set N to Y ): [Root @ ora11gr2 ~] # Vim/etc/oratabMytest:/oracle/product/11.2.0/db_1: Y 2. oracle

In CentOS 6.5, Oracle 12c is automatically started upon startup. In Linux, the Oracle Database Service is automatically started at any time by default, unlike in Windows. In Linux, You need to manually set the settings to enable automatic Oracle

How does MySQL manage multiple instances? MySQL can run multiple instances in two ways. The first is to start different processes to implement multiple instances. The second is to use a separate configuration file through mysqld_multi to implement

MySQL5.7.10 installation documentation 1. Install the dependency package Yum-y install gcc-c ++ ncurses-devel cmake make perl gcc autoconf automake zlib libxml libgcrypt libtool bison 2. Install the boost Library: First, check whether boost has been

Manage managed servers by configuring Node Manager in WebLogic 12c This document is based on the Oracle WebLogic Server 12c: logging ing and Using Node Manager Official Document. After practice, you will get it. It is designed to provide guidance