Database Administrator

Verification checkpoint SCN during Oracle Database startup SCN (System Change Number) is an important mechanism for Oracle databases. SCN is used when the database is started, read consistency, data recovery, and FLASHBACK operations. 1. the SCN

Install and configure apsaradb for Redis in Linux I. Redis Configuration 1. Download and install $ Wget http://download.redis.io/releases/redis-2.8.17.tar.gz$ Tar xzf redis-2.8.17.tar.gz$ Redis-2.8.17 cd$ Make$ Make install Redis executable files

Export MySQL user permissions When migrating a MySQL database, you sometimes need to migrate the users and permissions in the source database. For this migration, we can obtain the user's related permissions from the mysql. user table to generate

Install the full version of MySQL source code in Linux Install MySQL in Linux, usually by using RPM and source code. For the production environment, you need to customize the installation path, data file location, Character Set, and supported

Oracle bug solved: ORA-20446 Error I downloaded an Oracle 11g and want to see what new features are available. After the installation, enable EM and find that the feature is excellent. It is used to import data from another database. Set to import

Database Design-semi-structured storage and database structured storage Business scenario: the user fills in some documents, reports them, and approves them. There are several fields in the document that need statistics, and the business is not

Virtual Box cannot open a new task for the Virtual machine, virtualbox When you create a shared disk on two nodes today, you can only open one of the two virtual machines. When you open another task, you are prompted that you cannot open a new

MySQL bin-log analysis method, mysqlbin-log Author: Echo Chen (Chen Bin) Email: chenb19870707@gmail.com Blog: Blog.csdn.net/chen19870707 Date: September 9th, 2014 Some time ago, when the game server was suspended, it was always slow.

Database ----- Common Database Connection Methods, ----- database connection Oracle Driver oracle. jdbc. driver. OracleDriver URL jdbc: oracle: thin: @ loaclhost: 1521: orcl // orcl indicates the database SID. MySQL Driver com. mysql. jdbc.

Mysql database server adjustment, mysql Database Server Make a database server adjustment to the customer the day before yesterday, discard the previous host, promote the master from the database, and then add the new slave. Here, record the

Ssdb master-slave synchronous replication configuration detailed steps, ssdb detailed steps The SSDB configuration file is a hierarchical key-value static configuration file, which uses a TAB indent to represent the hierarchical relationship. The

Mysql master-slave replication, mysql master-slave1. mysql master-slave replication Principle For the master server, the information generated in the current database will be recorded in the binary log. If the server receives a Statement on the

One ORA-600 [13011], one ora-60013011SunOS 5.10 Oracle 10.2.0.2.0 development environment a database has a ora-600 error.Alert. error message in log: Thu Nov 13 15:11:43 2014 Errors in file/oracle/admin/sun/bdump/sun_j000_29589.trc: ORA-00600:

Mysql installation (Using Generic Binaries), genericbinaries Mysql is Mysql 5.6.21 and is installed in common Linux. That is, most Linux platforms can install Mysql in this way. 1. Installation Steps 1. installation environment 1) Centos 7.0.1406 X86

Disable Clusterware to automatically start after the system starts. Disable clusterware The following describes how to disable and enable Clusterware to automatically start with system startup.   Use the following method for 10 GB: Disable

Temporary table, oracle temporary tableTemporary tables allow users to operate only their own data without interfering with each other, so they do not have to worry about damaging or affecting data of other sessions/transactions. Temporary tables

Mysql stored procedures and common functions, mysql stored procedures I. Functions 1. mathematical functions CEIL () into one integer Select ceil (1, 1.2); 2 FLOOR () Rounding Select floor (1, 1.9); 9 MOD remainder (Modulo) Select mod (3,8); 3-3

Hive non-interactive mode and hive Mode Run $ HIVE_HOME/bin/hive on a linux terminal to enter the interaction mode; $ HIVE_HOME/bin/hive-e or-f is in non-interactive mode. 1. Execute HQL statements in non-interactive mode $HIVE_HOME/bin/hive -e

How to get an execution plan and an execution plan How to get an execution plan from oracle 1. Get a common execution plan. The effect is similar to executing set autot on exp first and then executing SQL. Explain an plan for your_ SQL; select *

Rac _ report version too high when installing software, rac report Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally