Database Administrator

The MySQL table is structured as an InnoDB type and restores data from the ibd file. The customer's machine system is shut down abnormally. After the restart, the mysql database cannot be started normally. After the system is reinstalled, the

How to delete an Oracle 11g cluster node in a Linux and UNIX environment step by step Deleting a Cluster Node on Linux and UNIX Systems 1. Check whether the node to be deleted is active or pinned. $ Olsnodes-s-t If pinned, crsctl unpin css-n

Batch export table data from Oracle to CSV files Requirement: Import multiple NTS that meet the conditions in the oracledata database into a csv1_file and store them with the table name. CSV as the file name. Implementation: It is implemented

How to bypass the password settings of the Oracle listener How to bypass the password settings for Oracle listening: 1. Find the pid of the listening process and kill it.Ps-ef | grep tns [Oracle @ lixora admin] $ ps-ef | grep tnsRoot 9 2 0 Jul11? 00:

How to obtain the Oracle 11g RAC asm spfile location How to obtain the Oracle 11g RAC asm spfile location Method 1:[Root @ vmrac1 ~] # Su-grid[Grid @ vmrac1 ~] $ Sqlplus/as sysasm SQL * Plus: Release 11.2.0.3.0 Production on Thu Jul 3 09:36:27

MySQL myisam solution for concurrent read/write Mysql myisam solves the problem of concurrent read/write. MyISAM is very efficient when reading operations are dominant. Once a large number of read/write concurrency occurs, the efficiency of MyISAM

Install MySQL 5.1.69 on CentOS Install MySQL 5.1.69 on CentOS I. Uninstall the old version Run the following command to check whether MySQL Server is installed. Rpm-qa | grep mysql If yes, run the following command to uninstall it: Rpm-e mysql //

In Linux, Oracle11G RAC reports an error: file not found in the case of oracle software installation, oracle11grac In Linux, Oracle11G RAC reports an error: file notfound is reported when oracle software is installed.1. symptom Everything has been

Oracle initialization parameter files pfile and spfile, pfilespfileDifferences between pfile and spfile Pfile: Before Oracle 9i, ORACLE used PFILE to store initialization parameters. This file is a text file and can be modified at the operating

[MySQL Case] mysql local logon-S is invalid, mysql-s 1.1.1. The-S parameter is invalid when mysql is logged on to the local machine. [Environment description] Mysql5.5.14 [Problem description] Multi-instance Configuration   Instance 1

For example, four aspects of Websphere Optimization Websphere Optimization I. Introduction Environment Name Version Server Operating System Centos 1, 5.6 Application Server Operating System Windows 7

3. Database paradigm The database three paradigm is certainly not unfamiliar to everyone. The official explanation is very abstract and difficult for beginners to understand. I forgot to read this knowledge. Whenever someone asks me, you must first

A series of tutorials-"13 days for you to learn Redis" Hot registration, redisThe Learning target is 2 hours a day and 13 days for you to learn Redis.This course is intended for beginners of Redis and even students who have never heard of anything

SQL table connection, SQL tableBackgroundIn the last self-study subject database system principles, I have gained some knowledge about database table connections. Recently, I used database table connections, let's take a look at it again.Graph

How to obtain the oracle dbid and oracledbid1. query v $ database to obtainBecause DBID has records in the control file and data file, you can query the v $ database view if you can mount the database.SQL> alter database mount;Database altered.SQL>

Hive command line, videohiveHive command lineHive command line example • execute the specified SQL statement from the command line• $ HIVE_HOME/bin/hive-e 'select a. col from tab1'• Run the specified SQL statement with the specified hive environment

Solving ORA-02395: exceeding call limits for I/O use, ora-02395The PROFILE file of ORACLE is a method to restrict the resources used by database users. For example, you can control the CPU that can be used by sessions or SQL statements, and control

[Translated from mos] prohibit log writing to Sqlnet. log, Listener. log, and sqlnet. logWriting logs to Sqlnet. log and Listener. log is prohibited.Reference Original:How to Disable Logging to the Sqlnet. log and the Listener. log (Doc ID

Oracle column merge, oracle Column In many cases, we need to use oracle column merge. oracle provides some methods to merge multiple rows of data in a column into one row.   1. Use WMSYS. WM_CONCAT before 10 GBWmsys. wm_concat separates the field

PostgreSQL code analysis, query optimization, pull_ands (), pull_ors (), pull_andspull_ors PostgreSQL code analysis and query optimization. Here, we have finished sorting out the part of the regular expression. The reading order is as follows: I.