Database Administrator

1. Download the mysql database Official Website: www.mysql.com to register a mysql user MySQL For Windows V5.2 Alpha http://www.skycn.com/soft/1262.html updated on: 2. Download the mysql database driver.

Oracle announced the release of the complete data integrity (data integrity) Test of open source code, so that users in the Linux community can obtain more comprehensive protection during data transfer. At present, 2.6.27.Oracle, the core of Linux

This article introduces how to diagnose node restart problems in the RAC environment. Applicable to 10gR2 and 11gR1.First, we will introduce the CRS process that can cause node restart.1. ocssd: its main functions are Node Monitoring and Group

Recovery Based on backup control file (unsing backup controlfile) Applicable:Recovery Based on backup control files is applicable to the following situations: the tablespace is accidentally deleted; all control files are damaged.   1. Close the

I. Master-slave replication process of mysql: The dump process in the master node reads binary files and has the replication client and replication slave permissions on the slave server's I/O threads.Read the binary file of the master server and

MongoDB is one of the most popular NoSQL databases today. During the summer vacation, I finally had time to read some articles about it from the MongoDB authoritative guide and NoSQL Fan, below I will briefly summarize some interesting things of

I just got started with DB2, but I am not very familiar with the Backup recovery mechanism of DB2, and I am not familiar with the relevant information, so I have to explore it myself. Requirement Online compression and backup of the production

Before Oracle 10 Gb, when we connect to the database in SHELL or JDBC, we need to enter the user name and password, and both are in plain text. Starting from 1OGR2, ORACLE provides the wallet tool to log on to the database without entering the user

Environment: MySQL Sever 5.1 + MySQL command line tool Problem: the current time of the MySQL datetime data type is set to the default value. Solution: Method 1: Because the default value of the current MySQL field does not support functions, it is

The installed mysql database is: mysql-5.6.4-m7, which is installed with the cmake tool. CMake is a cross-platform installation (Compilation) tool. You can use simple statements to describe the installation (compilation process) of all platforms ).

1. Download A performance problem occurs in the customer system. The database version is 9.2.0.4 32-bit. Because the 32-bit database has a maximum memory limit of GB, physical memory cannot be fully used even if a new machine is used, we plan to use

I. Environment Description Source database: Operating System: LINUX 32-bit Database: Oracle 10.2.0.4.0 32-bit   Target database: Operating System: LINUX 64-bit Database: ORACLE 10.2.0.4.0 64-bit   Ii. operation instructions Cross-platform

Oracle 10g UPDATE 11g Training Project 1. Project Process:1. Install 11.2.0.3 database software on the server where the Oracle 10.2.0.5 database is located2. Execute dbua in the environment variable 11.2.0.3 and upgrade the Graphical Database.3.

Oracle Clusterware places the configuration information of the entire cluster on shared storage. The information includes the list of cluster nodes, the ing between cluster database instances and nodes, and the CRS Application resource information.

Preface The best way to learn is practice! Therefore, my learning is based on practice. The most basic SQL statement is the query statement. Therefore, I also learned from the select statement. (In fact, this part of the author) has been mastered,

You can add data to a table as follows:1. insert into table values (...)Write data according to the specified column in the table. If only the table name is given, the data is added in the column order.Insert into table (col1, col2) values (value1,

In the Oracle 10 Gb database, a materialized view is modified with a simple condition clause, deleted and rebuilt, but the creation fails, reporting that the ORA-00942 table or view does not exist. This is a strange question. Do I think this is a

SYS @ orcl # shutdown abort;The Oracle routine has been disabled.SYS @ orcl #Oracle @ oracle :~ /Product/10.2/db_1/dbs> rman target/ Recovery MANAGER: Release 11.1.0.6.0-Production on Wednesday June 5 23:13:10 2013 Copyright (c) 1982,200 7, Oracle.

1. Create the same directory as the 9i data file, control file, and redo file on the target server where Oracle 10g software is installed (the data files of the two databases must be in the same location, otherwise, you need to use alter database

This article mainly introduces the installation of Oracle 11g RAC and the creation and migration of 10g databases in the 11g RAC environment, and how to upgrade the database to the 11g version. The architecture of the 11g RAC and some new features