Database Administrator

Oracle reported EXP-0006: internal inconsistency Error When the system was deployed at the electronic Institute in March October, the export and import of the Oracle database were successful using the exp and imp export database commands, I have

XtraBackup and InnoBackupex online backup XtraBackup online backup: A hot standby tool dedicated to InnoDB and XtraBackup. It is a C language program dedicated to backing up InnoDB and XtraDB engine objects. Efficient, complete, and available

Install and configure Scheduler Agent in Oracle 11g Oracle sched is a powerful scheduled scheduling program that not only schedules jobs to run in the local database, but also initiates these jobs on the remote host. You do not have to install the

Use Case of MySQL quick backup tool XtraBackup in production environment There are many ways to back up MySQL. The most common method is MySQLdump. Export the database to an SQL file. When restoring, source db. SQL is executed happily. Our friends

Performance Comparison of Oracle Database date filtering methods Performance Comparison of Oracle Database date filtering methods When developing SQL statements, filtering date segments is a common problem. How can we efficiently filter out date

Create a table, insert an id column, and automatically generate an id. The id is automatically generated. USE [yuyongTest] GO -- Go: Execute now. The go statement segments the SQL Server script. After a segment is executed, the next segment can be

Mysql: Communications link failure solution, failure Mysql: Communications link failure solves the problem of connecting to MySQL using Connector/J. After the program runs for a long time, the following error will be reported: Communications

HMaster startup code analysis for source code analysis of HBase1.0.0 (1), hbase1.0.0hmaster This article is not really about startup code parsing. This article mainly analyzes the startHMaster part from the startup process. This article will

Basic concepts of Oracle's Business Intelligence Applications Configuration Manager, configurationmanagerOracle's Business Intelligence Applications Configuration Manager: BIACM Once the BIAPPS installation is completed, the newly introduced

Spring database access (oracle) configuration, spring Data Access Chen kezhao: http://blog.csdn.net/u013474104/article/details/44279309 ====================== 1. spring's support for database access When developing the persistence layer, we are

PostgreSQL usage notes (my company uses arterydb, sub-installed postgreSQL), postgresqlarterydb-- Start the database./Bin/aty_ctl-D data-l arterydb. log start-- Connect to the database./Bin/atysql-d artery-- Set Environment VariablesExport

Database Cluster (1) MySQLCluster entry, cluster mysqlcluster Recently, the company is planning to do ITOO products, so preliminary technical research is essential. This article briefly introduces MySQL Cluster: (1) Overview MySQL cluster is a

MySql calculates the time difference between two dates. MySql calculates the difference between two date and time functions: First, the TIMESTAMPDIFF function requires three parameters. The first parameter is a comparison type, FRAC_SECOND, SECOND,

Transaction nature and isolation level, transaction nature isolation levelTransaction concept Transaction is the basic unit of concurrency control. A transaction is a sequence of operations. These operations are either executed or not executed. It

Xinxing analyzes key-related commands in Redis, and Xinxing analyzes rediskey In Redis, we can also directly operate on keys. The following are common commands: (1) keypattern: It indicates getting all the keys matching pattern. Note that we should

Oracle 12cR1 Relink error: ld. so.1: skgxpinfo: fatal: libons. so: open failed: No such file or directory, oracledirectory Source:Oracle 12cR1 Relink Error: "ld. so.1: skgxpinfo: fatal: libons. so: open failed: No such file or directory" (Document

MySQL Distributed Database Service middleware-Cobar research 3, mysql middleware-cobar In practical applications, you often need to deploy a Cobar cluster and then combine the soft load LVS or the Hardware load device F5 to provide external services.

[Translated from mos] Why does the INITIAL parameter be ignored when a table is created in a tablespace locally managed using the uniform size ?, Mosuniform Translation: Why Does a Table Created in a Locally Managed Tablespace With Uniform Extents

Java. SQL. SQLException: No suitable driver found for http: // localhost: 3306/school, nosuitabledriver 1. Error description Java. SQL. SQLException: No suitable driver found for http: // localhost: 3306/school 2. Error cause Class. forName (

Redis persistence-RDB and Redis persistence-RDBRedis provides a RDB persistence mechanism, that is, to write data set snapshots in the memory to the disk at a specified interval.Advantages of RDB:1. In this way, there is only one file to back up the