Database Administrator

Bug During MySQL installation in CentOS 6.4 Install MySQL in CentOS 6.4 and download a source code package. It feels very simple, tar ,. /configure, make, and make install are four classic steps. This is not the first time, but today is an old error.

Aix hacmp system error -- NODE synchronization configuration error Environment: Operating System: AIX 5300-08 Cluster software: CRS 10.2.0.1 Database: Oracle 10.2.0.1 Fault symptom: The following error occurs when synchronizing the hacmp

Oracle Data Pump details Comparison Between Data Pump and conventional method: Oracle introduces Data Pump at 10 Gb. Compared with traditional exp/imp, data pump can separate jobs, and can suspend and resume Import and Export tasks, you can restart

Install MySQL 5.5 in Linux source code This article describes how to install mysql5.5 in the source code. The system used is CentOS6.5. 1. Install the corresponding development environmentYum install-y ncurses-develYum install-y libaioYum install-y

Oracle backup and recovery Series Tutorial Environment Introduction:Create a test user snow. The user has a table and a stored procedure. A task takes effect easily by simulating a user inserting a timestamp every minute like a database to generate

ArcGIS Engine Q & A: Why cannot the element class of the same name be generated in the geographical database? arcgisengine The reason for such a problem is that no matter whether a element class is directly put in the blank question of work or a

SQL JOIN and sqljoin When the charging system of the data room is restructured, many functions need to query matching information in another table based on the information in one table in the database. We use the view, but have you noticed the

Xin Xing talks about mysql's data fragmentation and operations under MyISAM engine, Data fragmentation in mysql is closely related to data deletion. When deleting data, it will inevitably lead to discontinuous blank space in the data file. for

Oracle Database startup failure caused by a vm time backflow, vmoracle Oracle Database startup failure caused by a vm time Backflow This article is an original article. If it is reproduced, please indicate the

Mongodb master-slave configuration: replica set, mongodbreplica1. Replica setThe master-slave deployment of mongodb, usually in the replica set mode. Replica set is a group of multiple mongod instances, including one primary and multiple slave

About rac crs automatic start and raccrs startAbout CRS auto-Restart ExperimentI. Check ASM[Root @ rac1 ~] #/Etc/init. d/oracleasm statusChecking if ASM is loaded: yesChecking if/dev/oracleasm is mounted: yes[Root @ rac1 ~] #/Etc/init. d/oracleasm

Solve the problem that the Oracle11g empty table cannot be exported. The deferred_segment_creation parameter is added to Oracle11g. The default value is true when the database is created, which means delayed loading. When no data exists in the table,

Oracle 11g adds not null fields faster than 10g-new feature, oracle11g Adding a not null field before 11g is very slow, and it is very fast after 11g. We will first perform a test and then explore the principle. SQL> select * from v $ version;BANNER

Python for sqlserver and pythonsqlserver# Coding = gbkImport sysImport pymssql# Try database connectionTry:Conn = pymssql. connect (host = "192.168.1.43", user = "sa", password = "sa01! ", Database =" master ")Failed t pymssql. OperationalError, msg:

Mysql performance debugging tool profile, mysqlprofile I have been looking for mysql tools similar to Oracle 10046. I can see the time consumption of SQL Execution. I finally found a profile on the Internet. I think it is good to use it. Mysql>

ORA-31693, ORA-02354 and ORA-01555 with Export Datapump, ora-31693ora-02354SymptomsORA-31693: Table data object "YXFUND". "MF_NOTTEXTANNOUNCEMENT" failed to load/unload and is being skipped due to error:ORA-02354: error in exporting/importing

Create a new user and modify the maximum number of connections at oracle11g, and create at oracle11g Create user test identified by root; grant create session, resource to root; alter user test account unlock; grant create view to test; grant any

Common ORACLE commands and oracle commands 1. ORACLE startup and Shutdown1. In a single-host environmentTo start or shut down the ORACLE system, you must first switch to the ORACLE user, as shown below:Su-oracle A. Start the ORACLE SystemOracle>

Basic Summary of MySql (1), basic summary of mysql I have read MySql for the second time. The main purpose of this time is to sum up the MySql system. I used to write my notes on MySql before, but I don't want to always take it with me in the future,

[Database] basic usage of the ROW_NUMBER () OVER function, row_numberover (1) ROW_NUMBER () OVER (order by column) Generally, developers and administrators use temporary table and column-related subqueries in a query to calculate and generate row