Database Administrator

During MySQL installation using source code compilation in Fedora, various errors may occur, mostly because no dependency package is installed and the rpm command is used for installation, which may cause less trouble: Required software:

I. Switching users To control and manage Oracle, you must first switch to the Oracle user. The following command is generally used: Su-oracle Ii. Start the listener To remotely connect to the database, you must start the listener by using the

The following process is a step-by-step installation step. 1. Install the RPM packageRpm-aq | grep libgcc // check the package fileRpm-Uvh * // install all package filesBinutilsCompat-dbCompat-libstdc ++Control-centerGccGcc-c

The MySQL database in Linux has three functions:1. Create a folder named by date to store mysql Database backups.2. If the folder named by date exceeds 30, it is automatically deleted to save server space3. Go to the/var/lib/mysql directory and pack

Notes for installing Oracle 11G in Ubuntu 9.04:(1) Oracle does not support Ubuntu and is related to the Linux kernel version,(2) Pay attention to conflicts between Oracle and local JDk and Chinese garbled characters.Local parameters:(1) Ubuntu

At the recent Oracle OpenWorld 2009 Conference, Oracle released the latest server virtualization product Oracle VM 2.2, they also said that their users will be able to use this product to accelerate deployment and simplify the management of

The authoritative eWeek test shows that MySQL 4.0.1 is comparable to Oracle 9i. EWEEK Labs/PC Labs can be said to be the leader in Benchmark Testing. As early as October 1993, their sister Magazine PC Magazine did the same test. This cooperation

Ubuntu has unixodbc. To connect to MSSQL or SYBASE, you need to install it first. To compile freetds, you need to install the packages unixodbc, unixodbc-bin, and unixodbc-dev. After installation, you can use tools such as ODBCConfig and DataManger.

Today, we need to use this SQL statement: group by first, use the aggregate function count or sum for calculation, and display other auxiliary information. In the MySQL environment, I simulate the following environment: Create table 'room '( 'Rid'

1. Perform all replication operations in the foreground where the Master node is not offline Basic Steps for recall:1. premise: the Master opens the binary log file and sets server-id = 1.2. account required to establish a slave service connection

Use dbv and rman blockrecover to repair bad Oracle Database blocks. (1) alert. log reports the following error during rman backup: Fri Jul 2 12:41:36 2010 Hex dump of (file 12, block 2718618) in trace

Modifying db_recovery_file_dest causes flashback off. Error reported during startup [Oracle @ node3 dbs] $ srvctl start instance-d momorac-I momo1 PRCR-1013: Failed to start resource ora. momorac. db PRCR-1064: Failed to start resource ora. momorac.

The default installation path of the mysql database is/var/lib/mysql. However, in practice, we often need to customize the installation path, such as/data/mysql, or/opt/mysql is usually a separate disk or partition, which is conducive to performance

Because of the sudden power failure in the office, the database was not restarted after the server was restarted, so I found that all the databases were not set to automatically restart after the boot, in order to prevent the server from restarting

1. How Does Oracle determine the new and old control files?1. Under normal circumstances, the control file seq # (controlfile_sequence #) is greater than or equal to the control file seq recorded in the data file header # (fhcsq) the control file

Oracle 11g new collection function listparts implements column forwarding First, the syntax is as follows:Listparts (column | expression,Delimiter) within group (order by column | expression) is a clustering function. Use an example to describe its

1. More processes than single-instance databases in RAC: LMS-Gobal Cache Service Process global Cache Service ProcessLMD-Global Enqueue Service Daemon Global query Service DaemonLMON-Global Enqueue Service Monitor Global query Service monitoring

Note: The database should be supported in the archive mode. 1. Back up the SYSTEMG tablespace.[Oracle @ bys001 ~] $ Rman target/Recovery Manager: Release 11.2.0.1.0-Production on Tue Sep 17 10:42:18 2013Copyright (c) 1982,200 9, Oracle and/or its

How to view the definition of tables, views, indexes, stored procedures, and triggers in Oracle View table definitions: Sets long 999999 Select dbms_metadata.get_ddl ('table', upper ('& table_name') from dual; View the view definition: Select

Arraysize defines the number of rows returned to the SQLPLUS client at a time. After scanning the arraysize row, stop scanning, return data, and continue scanning. This process is the SQL * Net roundtrips to/from client in the statistics. Because