Database Administrator

In Ubuntu 7.04, the following error will occur when using mysql-gui in the following version, which is my reference on mysql official, with the address of the following http://bugs.mysql.com/bug.php? Id = 28959. Here we provide a solution, that is,

SQL * Loader is a data migration tool provided by the Oracle database system. It provides a command line method that allows you to load a large amount of data into the Oracle database in batches. Although both the Oracle database and the SQL Server

Hardware preparation environment: Hard drive: 16 SAS 15 k raid 5 with 512 MCache CPU: AMD 4-core two Memory: 16 GB Software environment: Operating System: RedHat AS4.6 2.6.9-67. ELsmp Mysql: 5.0. Performance Tuning based on different scenarios is as

Supported platforms Supported Oracle Database versions The following Oracle Database versions are supported in the current Oracle GoldenGate 10.4 Oracle 8i (DML support only) Oracle 9.1 and 9.2 (DML and DDL support) Oracle 10.1 and 10.2 (DML and DDL

Recently, I have dealt with some Oracle character data types. I want to learn from them as follows: 1. First, compare the char and varchar2 types: Differences: 1. the length of CHAR is fixed, while the length of VARCHAR2 can be changed. For example,

1. recover database using backup controlfile 2. recover database until cancel 3. recover database using backup controlfile until cancel; 4. recover database until cancel using backup controlfile; Differences: 1. If the current control file is

First of all to ensure that the correct installation of mongodb, Installation Reference: http://docs.mongodb.org/manual/tutorial/install-mongodb-on-debian-or-Ubuntu-linux Then download the mongodb driver of nodejs Npm install mongodb Compile a test

The alert log Changes after Oracle reaches 11 GB. The oracle database provides the Alert log in two formats: XML and traditional text. The new log location is determined by the Automatic Diagnostic Repository (ADR) storage directory. You can control

Assume that the two redis servers have ip addresses 192.168.1.101 and 192.168.1.103 respectively. How can I access redis on redis 101 through redis-cli on redis 103? Before remotely connecting to redis 103, let's talk about several key parameters of

This morning, I received an email indicating that the job failed to be executed. (The job still runs properly a few days ago. I do not know why the error occurred today) The mail shows that the third step of the job reports an error. Step 3:

17.3. Making User-Managed Backups of Offline Tablespaces and DatafilesPay attention to the following guiding principles when backing up offline tablespaces:(1) tablespaces that cannot be offline system tablespaces or active rollback segments(2)

The second part was intended to test whether the master server was suspended and the slave server was upgraded. However, an accident occurred. Instead, it was used to test how to recover a slave server when it was suspended. Put the failure of the

In 10 Gb, Oracle launched its own auxiliary SQL optimization tool: SQL optimizer (SQL Tuning Advisor: STA), which is a new DBMS_SQLTUNE package. To use the STA, make sure that the optimizer is in CBO mode. However, I think this tool is only suitable

Steps: 1. backup database TestMirror on Pricipal server 2. backup database log of TestMirror on Pricipal server 3. copy db and log backup files to Mirror server 4. restore db with norecovery 5. restore log with norecovery 6. create endpoints on both

We are all familiar with the recycle bin in windows. After a file is deleted and put into the recycle bin, it can be restored. The Oracle recycle bin works exactly the same, but there are some differences in implementation details.. In addition, the

Enter sqlldr. If no parameters are followed, a simple description of all command line parameters and their default values are displayed. (You can also query some parameters quickly when you forget them ): Valid Keywords: Userid -- Oracle

For most applications, access to hotspot data exists, namely:The Access Frequency of some data in a certain period of time is much higher than that of other data..Common hot data includes "the latest news", "the most popular news", and "movies with

In this five-minute tutorial, we will teach you how to quickly get started with MongoDB in a Windows environment. This article describes how to connect to the MongoDB server and how to use the MongoDB shell. First, you need to download the 64-bit

Finally, Nosql products are used. We are using MongoDB, which is currently popular. Of course it is not just a large stream, but a product that uses geospatial indexes. This is my configuration process in Gentoo Linux: 1, download the version you

Today, in the log file of a server, the following information is found: It seems to be an error, but it does not affect the operation of the database. However, after all, the error is reported. If you look uncomfortable, study it. Fatal NI connect