Database Administrator

I have been listening to my tutor's lecture about Oracle these days. I always wanted to install one, but I didn't install it on my Fedora7. I tried it some time today. Refer to the online method, the installation is successful. Here are the specific

Most of these problems occur in the Federo version. a friend on the previous Forum used this version of Linux but was unable to deploy MySQL in the LAMP environment. Later, the installation of MySQL had many problems. Today, I replaced the system

1. Remove the original MySQL database 2. restart the computer; 3 In windows:Open the command line window and stop MySQL service: Net stop mysqlStart MySQL, usually to the installation path of MySQL, find the mysqld-nt.exeRun: mysqld-nt --

It's just a simple configuration. Weblogic configures the data source in Linux, which is the same as that in windows. It may be a problem only for those who have just switched from windows to Linux. Step 1: copy the database connection file (My

The official MySQL 5.1 version has not been released yet. I am waiting for it to wait for its table partition function. With this function, a table will be easily solved because of the large amount of data that seriously affects the speed. Table

MySQL cannot be startedToday, there is another problem with MySQL on the server. If there is no exception, no error is reported. After mysql is started in the service, no error is reported, but the startup is not successful. It is not like a 1067

To install MySQL in Linux, I only install the SERVER Installation Package and CLIENT installation package. This is sufficient for normal use, but it is necessary to open and release the database in Linux, you also need to install a software package:

When installing mysql-connector-odbc in Linux AS5.0, the following message is displayed: # Rpm-ivh mysql-connector-odbc-3.51.12-2.2.i386.rpmWarning: mysql-connector-odbc-3.51.12-2.2.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186Error:

A friend has a friend a few days ago. Due to project implementation, how long does it take to start Oracle on Linux? Their requirement is less than 10 seconds. Because the system may frequently lose power. At that time, I considered how to implement

Sqlplus/nolog SQL> conn system/password @ oraname as sysdba First, close the database: SQL> shutdown normal Or SQL> shutdown immediate; View the current status: SQL> archive log list; Conversion Mode SQL> startup mount; SQL> alter database

As part of Oracle's smart infrastructure, Oracle's 10 Gb automatic load database can work with the automatic database diagnostic monitor to help database administrators diagnose and fix performance problems. In the description of smart

The system uses minimal installation, and the installation steps are not detailed. 1. Install the RPM package: # Rpm-ivh glibc-headers-2.5-12.i386.rpm # Rpm-ivh glibc-headers-2.5-12.i386.rpm # Rpm-ivh libaio-0.3.106-3.2.i386.rpm # Rpm-ivh libgomp-4.1

Said a website evaluated the performance of a series of desktop software on the Linux kernel, using a series of pure kernels from the Ubuntu company without patching, from 2.6.24 to 2.6.29, other software is standard Ubuntu 8.10, including X Server 1

A one-to-multiple table is usually associated with the primary key of another table. However, there are also some unusual situations, that is, two tables are not joined by the primary key of one of the tables. For example: Create table t_team(Tid

Recently, some netizens are not very clear about the automatic memory management feature of Oracle SGA, probably because the automated management of Oracle 10g SGA translated at that time was quite cool, the following is still a description of this

Oracle 10.2.0.1RAC (not Using asm) with a full set of raw disks (including crs and voting disks and database files) (titles written in asm are used by many comrades, I can modify the ASM method here) To test my software, we need two sets of the same

I. Requirements MongoDB version: 2.4.3Ubuntu version: 13.04Ii. Description 10gen provides MongoDB's. deb package version, making it easy to install on ubuntu. Although Ubuntu also provides a MongoDB package, the MongoDB version managed by its

Restoration of Oracle log files and control files corruption: Recovery steps: 1. Add _ allow_resetlogs_appsuption = true, _ uploupted_rollback_segments = true, _ offline_rollback_segments = true, start to nomount 2. Use the backup of the control

A control file is a small binary file that is part of the Oracle database. It is used to record the database status and physical structure.Each database must have at least one control file, but it is strongly recommended that more than one control

Percona_Toolkit Percona Toolkit Introduction: (from the official introduction) Percona Toolkit for MySQL is a collection for advanced command-line tools userd by Percona MySQL staff to perform a variety of MySQL server and system tasks that are too