Database Administrator

ORA-24324 & ORA-01041 reboot Database Error Yesterday, when the Oracle database was restarted, an error was reported, ORA-24324 and ORA-01041 error, the following restore the error process and the process of solving the problem. 1. Prepare the

Compile and install Redis and master-slave replication configuration in Linux The installation and configuration of Redis is very simple, and Redis has been installed a long time ago. But I forgot some details when I installed it again these days.

Statistics on the differences between Percona Server 5.6 and 5.5 I. Discard:1. SHOW [GLOBAL] temporary tables is disabled. Only TEMPORARY_TABLES and GLOBAL_TEMPORARY_TABLES can be used.2. The innodb_thread_concurrency_timer_based parameter is

Relationship between Oracle database view and base table I. What is a view first? A view is actually a query SQL statement used to display relevant data in one or more tables or other views. A view uses the results of a query as a table. Therefore,

Temporary tables, external tables, and partition tables in OracleTemporary table In Oracle, a temporary table is "static". It only needs to be created once like a common data table. Its structure is valid from creation to deletion. Compared with

Tinkerpop (1) graph Database console survey, tinkerpopconsole The original Article connection: http://blog.csdn.net/freewebsys/article/details/46348975 reproduced please indicate the source!1. About graph database Tinkerpop is a project under the

Record the troubleshooting and resolution of a deadlock, and record the troubleshootingThis is a sad reminder. I remember last week's busy schedule. The goal is to modify some bugs in the code left by another team. This project is used for OLAP

Common Redis commands and redis commands 1 Create-store or not-View-delete Set name maojun; exists name; get name; del name; 2. serialization record Set name maojun; exists name; dump name; the client is logged out, and exists name and name still

Causes of slow night dimension execution: Execution inquiry Let's take a look at the key release today. Two days ago, I worked with my colleagues to check whether the execution of the overnight program was abnormal and slow. This was a typical

6 Administering Backup and Recovery, backupandrecoveryOracle Database 2 Day + Real Application Clusters Guide11g Release 2 (11.2)E17264-136 Administering Backup and RecoveryOverview of Oracle RAC Database Backup and RecoveryNote:For the RMAN utility

MySQL Study Notes _ 7_MySQL common built-in functions and Study Notes _ 7_mysql MySQL common built-in functions Note: 1) it can be used in SELECT/UPDATE/DELETE and where, orderby, and having. 2) use the field name as a parameter in the function.

An example is provided to briefly introduce arrays in PostgreSQL and postgresql. PostgreSQL has many out-of-the-box data types, from standard digital data types, to geometric types, and even network data types. Although many people ignore these data

Common Database interview questions and database questions1. Foreign key candidates for primary key superkeys Primary key: A combination of data columns or attributes that are unique and fully identified for the stored data objects in the database

After and Instead of triggers, instead triggers L After triggers: these triggers are activated and executed only after the record has been changed. They are mainly used to record the processing or check After the change. Once an error is found, you

Hive simple instructions for use, hive simple instructions for use I usage: Hive: Start hive The command must end with a semicolon and tell hive to execute the command immediately, case insensitive. Show tables; View tables Desc tablename;

Unmount the Oracle database on Linux and the linuxoracle Database See the article Red Hat5 installing Oracle 11gR2 (http://blog.csdn.net/johnnysun2015/article/details/45022119. 1. Stop the Oracle database SQL> showdown immediate   2. Stop listening

Database migration (SQL SERVER imports data to MySql), sqlmysql Background: At the beginning of the project, the SQL Server database is used, and the database needs to be adjusted to MySQL. I collected some tutorials on the Internet and sorted out

Oracle log file location, oracle Log FileOracle log files include warning logs, trace logs, audit logs, redo logs, and archive logs.Warning log: the alert log, which corresponds to the background_dump_dest set in the system initialization parameter

Principles of SQL injection and SQL Injection After successful SQL injection, you may obtain all the information of the target database! First, find the target URL to test the vulnerability. Search in google: inurl: news. php? Id = 2 Enter a URL at

MongoDB Reading Notes (via3.0) (00) _ [Overview] (02) _ mongoDB3.0 mongod startup method test, _ mongodb3.0mongod Mongod startup I originally wanted to write the non-test mode cluster architecture of Replica, but it was really tricky to download 3.0