Database Administrator

1. Install MongoDB Mongodb home http://www.mongodb.org/ 1, download the required version, address: http://www.mongodb.org/display/DOCS/Downloads (Take windows as an example, linux should be relatively simple), can refer to the official document:

Previously, all the systems installed in the virtual machine were Ubuntu. Later, my colleagues said that the general servers were CentOS, so they reset the centos system. Of course, you must first build a PHP environment. The downloaded source code

When the Oracle database is shut down normally, the committed transaction has been written into the data file, and the uncommitted transaction has been rolled back, the data in the control file, log file, and data file is consistent. You do not need

Sometimes, database faults and data loss may inevitably occur in the enterprise due to disk damage. At this time, data backup is particularly important. In this section, we will focus on loading data files,RedoLog File,ControlfileDisk damage data

An error message is generated in alert. log during manual RMAN backup on Sunday.Sat Jun 25 16:39:08 2012Errors in file/home/Oracle/app/oracle/admin/XXX/udump/XXX_ora_22899.trc:Sat Jun 25 16:39:08 2012Errors in

Due to the lock mechanism, when execution of a DML or ddl SQL statement is blocked, you need to find out why the SQL statement is blocked. The following describes the common diagnostic methods: Suppose there is a table: table t (id int primary key,

This article provides a simple example of Oracle 11g row/column conversion for beginners. The existing problems are as follows: Problem description:Table1Id Name1 Taylor2 JimTable 2FId value attr1 23 age1 boy sex2 26 age2 boy sex Table1 Id is the

MySQL does not support directly writing SQL statements to implement the Circular insert function. You can use other languages to manipulate MySql or use stored procedures to implement this function. 1. Implementation of Stored ProceduresA. Create

Oracle table Creation Create table BI_MLK_SEARCHKEYWORD ( Id number (30) primary key,KEYWORD varchar2 (30 ),Times number (30) not null,Inputdate date,PINYIN VARCHAR2 (50 ),FIRSTPINYIN VARCHAR2 (30 ),ENGLISH VARCHAR2 (50) ); Oracle creation

Although the latest MySQL installation files contain MySQL Workbench, which facilitates modeling and database generation, the best database modeling tool is Sybase's PowerDesign, which allows us to easily build a model at a time, A Sihai

Diagnose and resolve ORA-04031 errors When we try to allocate large blocks of continuous memory in the Shared Pool, Oracle first clears all the objects currently not used in the pool to merge idle memory blocks. A ORA-04031 error occurs if the

Sometimes a lot of SQL statement data needs to be inserted. However, PL/SQL tools are often used for a long period of time. Recently, PL/SQL tools are used frequently and are sorted out to facilitate future reference. The code is simple: Batch

A series of problems occurred during the installation of the Oracle database. When it was finally ruled out that it was difficult to install the database, a small software connected to the database encountered an error, PL/SQL Developer, a

View User PermissionsShow grants for your usersFor example:Show grants for root @ 'localhost '; Mysql has five permission levels: global level, database level, table level, column level, and routine level. High-level permissions cover low-level

Today, I developed a java interface program to insert values from the mysql database to an Oracle database. I think it is quite simple. mysql's query SQL is written, so there is no difficulty. The code for JDBC operations on the database in java has

1. Use the mysql built-in command mysqldump Usage:Mysqldump [OPTIONS] database [tables]Mysqldump [OPTIONS] -- databases [OPTIONS] DB1 [DB2 DB3. ..]Mysqldump [OPTIONS] -- all-databases [OPTIONS] You can see that you can back up all the databases, the

Requirement: Count the total number of tickets in the WAIT_ORDER table, the total number of unprocessed tickets, the total number of completed tickets, and the total number of incomplete tickets. Table Structure: For the convenience of the example,

Oracle Data Guard is used to protect Oracle Data and provides the highest level of Data protection and availability while maintaining the best performance for Oracle databases. Its operation follows the principle of transmitting redo data and then

// Input the txt file to the databaseLoad data infile 'data.txt 'into table table2Fields terminated ','; // Export the empty database table structureMysqldump-d-u xxx-p resin_log>/temp/dump. SQL // View the MYSQL configuration. The information is

Content Oracle Data Pump technology allows you to quickly move Data and metadata from one database to another. Data Pump Component How to move Data Pump References Data Pump Component Oracle Data Pump consists of three different parts: Command