Database Administrator

A few days ago, when operating the database, you needed to execute SQL statements that took a long time. However, at that time, the LAN network was not good and frequent disconnection occurred. In this case, you need to add the statement to the

Keywords: Hongqi Asianux3 + Oracle 10g R2 for Linux x86-64 1. Receive a consulting phone number in the morning: Oracle cannot be started in Linux. We will try to solve the problem at the site in the afternoon. 2. After arriving at the site, learn

Installing Oracle on the Linux platform requires a lot of preparation. For example, create a user, modify the environment variables, and set oracle parameters. Now it is compiled into a shell script to facilitate installation.1. Create an

The system crontab is used to regularly execute Backup files and save the backup results by date to achieve the purpose of backup. 1. Create a path to save the backup file # Mkdir/opt/databack/mysql 2. Create a backup script file #

There are three types of connections between Oracle tables: 1. inner connection (natural connection) 2. External Connection(1) left Outer Join (the table on the left is not restricted)(2) Right Outer Join (the table on the right is not restricted)(3)

Download sqlite-3.3.6.tar.gzDecompress and copy to the directory where you want to install it. What I chose is/usr/local/sqlite-3.3.6.Then in the terminal:# Cd/usr/local/sqlite-3.3.6#./Configure# Make# Make install# Make doc An error is prompted

1. What is an elastic domain? FlexValue is a field composed of child fields or segments. It is displayed as a pop-up window containing prompts of each segment on the form. Each segment has a name and a valid value set. For example, Guangdong mobile

Oracle has three main file types: control files, data files, and log files. Log Files record all operation records on the database and provide a recovery mechanism, before writing data to a data file, oracle needs to write the modified content to

First, declare that, in general, you need to have the root permission in MySQL to modify the mysql password and grant permissions.User: bkjia user database: bkjia.com 1. Create a user.// Log on to MYSQL@> Mysql-u root-p@> Password// Create a

The set operator is used to merge the results of multiple select statements, including UNION, union all, INTERSECT, and MINUS. When using the set operator, make sure that the number of columns in Different queries matches the data type. The set

The process of cross-compiling the SQLite-3.3.8 (or SQLite3.3.12) and porting to ARMS3C2410: To port SQLite3.3.8 (or SQLite-3.3.12) to the ARM2410 Development Board, in addition to the support of the underlying operating system, you must also have

The source code version of ghost, so far there is no ubuntu installation source, I am not very familiar with rpm, so I can only compile the source code to install, refer to the online compilation and installation options, tried several times,

The remote_listener cannot be enabled due to a problem in the settings. The alert Log is as follows: Starting up:Oracle Database 11g Enterprise Edition Release 11.2.0.2.0-64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data

Oracle Data Table CompressionCompression principle: store the repeated column values of all rows in the same Block in the header area. This region is called a symbol table ). If the value of a column in the row is equalThe value stored in the symbol

How to Write high-quality SQL statements in Oracle databases and diagnose and adjust SQL statements with performance problems in Oracle databases is an inevitable challenge for DBAs in ORACLE Database practice. Next let's analyze how we can start

When using Oracle SQL * PLUS, SPOOL is really easy to use. How can we implement it in MySQL? The following is an experiment description. In MySQL, the tee parameter can be used in three methods: First, add the tee parameter to the my. cnf parameter

Environment Description:OS: CentOS6.5 _ X64MASTER: 192.168.0.202BACKUP: 192.168.0.203VIP: 192.168.0.2041. Configure two Mysql master-master Synchronization[Root @ master ~] # Yum install mysql-server mysql-y[Root @ master ~] # Service mysqld

I. Environment Description 1. Working logic diagram 2. Advantages and Disadvantages of MySQL-MMM Advantages: high availability, good scalability, automatic failover in case of faults. For master-master synchronization, only one database write

Fault symptom:Go to the slave server and run:Mysql> show slave status \ G.......Relay_Log_File: localhost-relay-bin.000535Relay_Log_Pos: 21795072Relay_Master_Log_File: localhost-bin.000094Slave_IO_Running: YesSlave_ SQL _Running:

Today is, and the learning progress is also in full swing. Today, I will record a small part of the experiment. We know that the RAC network has a private network and a public network. The public network provides customer access requests and the