Database Administrator

Requirements for installing Oracle 11.2.0.4 on RHEL7 or OEL7 Requirements for Oracle 11.2.0.4 db installation on RHEL7 or OEL7Source:Requirements for Installing Oracle 11.2.0.4 RDBMS on RHEL7 or OL7 64-bit (x86-64) (Document ID 1962100.1) Applicable:

Oracle linesize command You can use the linesize command to set the number of characters that a row can accommodate. The default value is 80. If the value of linesize is small, one row of data in the table will be displayed in multiple rows on the

Conditions in Oracle databases where a datafile can be dropped Refer to the mos article:Unable to Drop a Datafile From the Tablespace Using Alter Tablespace Command (Document ID 1050261.1) This datafile cannot be dropped because of any of the

Restore an offline drop datafile in Oracle archive Mode Reference:How to recover offline dropped datafile in archivelog mode (Document ID 286355.1) The following experiment is completed based on Oracle 11.2.0.4 linux x86-64bit. [Oracle @

DBD: mysql: dr: imp_data_size unexpectedly error Solution The latest MHA verification encountered the error DBD: mysql: dr: imp_data_size unexpectedly. The DBD package has been installed. The following describes the problem and solutions. 1. fault

Uninstall MySQL Enterprise Monitor in Linux MySQL Enterprise Monitor is an Enterprise-level monitoring designed specifically for MySQL databases. It can be well integrated with various MySQL features, including: mySQL's key performance indicators,

Oracle start command The start command can read the content in the file to the buffer, and then run the content in SQL * PLUS. the syntax of the start command is as follows:Start {url | file_name}The url is used to specify a url address, such as

Highlights of CentOS MySQL operations How to operate MySQL on CentOS: 1. The problem [root @ rekfan mysql] # service mysql restart occurs.MySQL server PID file cocould not be found! [Failed]Starting MySQL... The server quit without updating PID file

Spring MVC link PostgreSQL The previous article has shared the following steps to build Spring MVC: This article links to the database PostgreSQL 1. Add several dependencies in pom. xml org. postgresql postgresql 9.3-1102-jdbc4 org. apache.

MySQL MHA configuration details MySQL environment: Master: 192.168.202.129: 3306 Slave: 192.168.202.129: 3307,192.168 .202.129: 3307,192.168 .202.130: 3306,192.168 .202.130: 3307,192.168 .202.130: 3308 MariaDB-10.0.13 MHA environment: Manager: 192.16

ORA-38301, ORA-00604, purge dba_recyclebin is not good, ora-38301ora-00604 An error ORA-38301, ORA-00604, purge dba_recyclebin is encountered during alter/drop tablespace Applicable:Oracle Database-Enterprise Edition-Version 10.2.0.1 and

Atitit. disadvantages of orm and market share of orm framework, selection attilax summary, ormattilax Atitit. disadvantages of orm and market share of orm framework, selection attilax Summary   1. Requirements of the attilax orm framework 1 2. orm

The Oracle database server uses an aix midrange computer and is used as the level-1 mount point of the nfs client. You must master one knowledge point: In the aix operating system (this problem occurs only in aix, but not in other operating systems),

SQL Server's C # connection and object existence judgment,C # connect to SQL Server This article provides a comprehensive overview of C # database connection. Http://blog.csdn.net/candy1232009/article/details/7654927 For C # connection to ms SQL

JDBC: Use the DBUtils tool class, jdbcdbutils Jar package: commons-dbutils-1.6.jar DbUtils class 1. DbUtils: Provides tools such as shutting down connections and loading JDBC drivers. All the methods in the tool are static. The main method is as

Different definitions of disk size in v $ asm_diskgroup and v $ asm_disk, vasmdiskgroupThe size shown in v $ asm_diskgroup is the sum value of the size of each physical disk (raw or sdh3. The size displayed in v $ asm_disk is the size specified when

Graphic SQLite tutorial, graphic sqlite The following operations are successful on your own. No nonsense. SQLite3 download: http://pan.baidu.com/s/1o6jzyX0 Decompress sqlite3.exe and copy it to the desired directory. Note that the following

Mysql-one of slow query logs, Mysql-one of slow logsSlow query log1. When no results are returned after a certain period of time, the slow query log is recorded.2. Slow query logs can help DBAs find SQL statements with slow execution efficiency and

Use Innobackupex to quickly build (fix) the MySQL master-slave architecture, innobackupexmysql There are many ways to build MySQL Master/Slave databases. The traditional mysqldump mode is one of the choices of many people. However, this method is

Oracle three practical statistics SQL scenarios, oracle statistics SQL scenarios When using oracle for statistics, we often encounter the following scenarios: 1. Convert vertical columns to horizontal Columns 2. Group and merge a column as the