Database Administrator

Oracle Tutorial: ORA-25153 temporary tablespace is empty, ORA-01652 cannot pass 128 I wrote a complex select statement, and suddenly Oracle reported: ORA-25153 temporary tablespace is empty, this error, so I checked online, found the following

OS X compilation and installation of MariaDB The MariaDB database management system is a branch of MySQL and is mainly maintained by the open-source community. The purpose of using GPL to authorize MariaDB is to be fully compatible with MySQL,

Connection to MySQL database (driver not loaded) with QT5.5 in CentOS7 (64-bit) To connect to MySQL using qt, you need to share the driver of libqsqlmysql. so. The path is under the plugin/sqldrivers directory. At first glance, it is available, but

Oracle TDE transparent data encryption technology From ORALE 10GR2, Transparent Data Encryption technology (TDE) emerged ). TDE is used to encrypt data. Generally, the application logic executed by SQL statements does not need to be changed and can

A simple test of orion Orion is a small I/O testing tool that can test random read/write and simulate mixed loads. This tool is already included in Oracle 11g, and does not need to be installed any more. It has brought a lot of convenience for I/O

Oracle 10g rac ip/VIP address modification exampleI. Preparations 1. Database Information Operating system version: OEL5.4 x64Database Version: Oracle 10.2.0.5 x64 RAC2. IP address information Note: The server host name cannot be changed. If you

Oracle password expired the password has expired Solution Oracle encountered the password has expired problem. Today, it suddenly found that the project could not be accessed. If it could not be used, it could not be accessed. This problem was

MySQL query database size Step 1: First open the Mysql Command line and choose Start Menu> program> MySql-Command line client, as shown in Figure 1-1: Figure 1-1 Step 2: Enter use information_schema 1-2 in the command: Figure 1-2 Step 3: view the

Solution for installing Percona Xtrabackup in CentOS 6.5 Solution for installing Percona Xtrabackup in CentOS 6.5 1. download the latest version of Xtracbackup 2. Installation Yum install perl-DBIYum install perl-DBD-MySQLYum install

MongoDB replica set: installation and deployment PreparationsSoftware Environment OS: Oracle Linux 6.5 MongoDB: mongodb3.2.3   Deployment Architecture Three servers are simulated. 10.1.5.123: 28001 master node From node 10.1.5.123: 28002 10.1.5.123:

Navicat for MySQL connection error, error code 1045 Solution Navicat for MySQL Solution: reset the root user password. Method 1: Open "start" -- "program" -- "MySQL" -- "MySQL 5.0" -- "MySQL Server Instance Config Wizard" and click "Next

Notes on installing MongoDB using yum in CentOS 6.5 Recently, I want to try Intel's WebRTC-based collaborative communication development kit. CS_WebRTC_Conference_Server_MCU depends on MongoDB. What is MongoDB? MongoDB is a distributed file

Install MySQL 5.6.26 source code MySQL 5.6.26 source code installation package and cmake installation package link: http://pan.baidu.com/s/1eRsF4noOperating system version: CentOS release 6.3 (Final)Installation Process: (remember to mount the image

MySQL5.6 5.7 user temporary table comparison Session-based temporary tableThe structure and content of the temporary table generated by default in MySQL5.6 are all in tmpdir5.6 The temporary tablespace without ibtmp1 is placed under tmpdir. Of

MySQL multi-instance Configuration Lab environment: RHEL6.4 for minimal installation, mysql installation package for general binary installation package, version for mysql-5.6.26 1. Create a mysql user # Useradd-M-s/sbin/nologin mysql # Yum-y

What are the types and features of database indexes? It effectively optimizes the VPS performance and increases the running speed of the VPS server. In addition to configuring the WEB Server properly, we need to be able to optimize our website

PostgreSQL recursive query for tree structure query and postgresql Recursion A very interesting feature found during Postgresql's use is that recursive queries can be used for results that require a tree-like structure. For example, the data

Mysql environment configuration query and Mysql environment Configuration Mysql environment Query 1. View All engines A) Show engines or go to information_schama to view the ENGINES table. 2. view the current user A) Select user () can be used

CentOS MySQL Database Export and Import, centosmysql You can use the database backup tool mysqldump to import and export mysql databases. Mysqldump is a handy tool that comes with mysql. the/usr/local/mysql/bin (CentOS) Directory of mysql

Check whether the SQL server has repeated values. Check whether the SQL server has repeated values.A string is "1; 2; 1; 1; 1 ".Excuse me:How to implement the following functions in SQL SERVER:1. check whether there are repeated numbers in the