Database Administrator

Install MySQL in Ubuntu: Download the version you need from the MySQL official website. Generally, you can download the latest version directly. Address: http://www.MySQL.com/downloads/ You can download all the packages under the community server

After upgrading Ubuntu to 10.04, the following error occurs when connecting to mysql:Can't connect to local MySQL server through socket '/var/run/mysqld. sock' After reading this, mysql is not started. RunSudo start mysqlUnable to start, no

1. Select "Enterprise Manager Configuration Assistant" in "Configuration and Migration Tools "; Create "archive database ": (1) Configure local OMS; (2) create a new archive database; (3)★We recommend that you use the "Custom" method (no need to

The distinct keyword can only be used to filter all records in the query field that are the same (the record set is the same). If you want to specify a field, it does not work. In addition, the distinct keyword is sorted, Which is

1. A table field in Oracle is of the Date type. The error message "Incorrect format" is always returned when you insert data into the file. Solutions: 1. Temporary Modification SQL> alter session set nls_date_format = 'yyyymmdd '; This method

1. Install unixODBC and freetds in Linux Source code package: freetds-0.82.tar.gz?unixodbc-2.3.0.tar.gz 1. Install unixODBC Gunzip unixODBC-2.3.tar.gz Tar zxvf unixODBC-2.3.tar ./Configure -- prefix =/usr/local/unixODBC Make Make install 2. Install

1 Swingbench 1.1 Overview This was developed by an Oracle UK employee on the basis of a abandoned project. The current stable version is 2.2, the latest version is 2.3, based on JDK1.5. This tool is free of charge and can be freely downloaded from

1. Download the binary version. Many websites now have related downloads, which are about 384 Mb in size and about MB in decompression. My downloaded version is: mysql-5.1.45-linux-i686-glibc23 2. The glibc2.3 version is required from the file name.

A colleague deleted an important Oracle table and failed to run the project! Fortunately, a DBA friend suggested that the flashback table of oracle can restore data. After using the flashback table, the results will be good and we will learn it

Modify the database character set to ZHS16GBK.View server character setsSQL> select * from V $ NLS_PARAMETERS;Modify:$ Sqlplus/nologSQL> conn/as sysdbaIf the database server has been started, run SHUTDOWN IMMEDIATETo shut down the database server,

Install Quick Installation Guide 10g Release 2 (10.2) for Linux x86. Problems encountered during installation: Start Oracle Universal Installer/tmp/OraInstall from the following address. please wait... [oracle @ nj15 database] $ Exception in thread "

// Overview// Basically, when you want a PLSQL (or java or c) program as a data source rather than a table,// You may use the pipeline function ).// The pipelined function operates like a table.// A pl/SQL function may be used in the database of the

When testing Oracle, I would like to test the performance of using asynchronous IO. But asynchronous IO requires special configuration, otherwise, it is easy to encounter a very famous "ORA-01578: ORACLE data block parallel upted (file #202, block #2

In JUnit, foreign keys are generally not required. However, the foreign key has been created during the database generation process, which is troublesome for adding, deleting, and modifying data. Follow these steps to invalidate or take effect of

1. Different identifiers. The identifier of the FUNCTION is FUNCTION and the process is PROCEDURE. 2. In a function, variable parameters are generally not used, and function values are directly returned using the function name. If a return value

Oracle does not have a hexadecimal to binary function. For ease of work, I wrote Create or replace function hex_to_bin (hex varchar2) return varchar2 isV_hex varchar2 (10000 );V_len number;V_var varchar2 (10000 );V_result varchar2 (10000): =

Environment: Oracle 11gr2 + dataguard 128 GB memory +-core cpu + high-performance storage server Uname- Linux dbhost 2.6.18-238. el5 #1 SMP Sun Dec 19 14:22:44 EST 2010 x86_64 x86_64 x86_64 GNU/Linux Symptoms: During rman backup, the system memory

When using a data pump to export data, sometimes we need to filter out some data that does not need to be exported according to the conditions. In this case, we need to use the parameter query. The following is a small example of simple query. In

Trigger There are two common types: Row Trigger and Statement Trigger) There are also: Instead of Trigger and Event trigger. Example 1-Row Trigger: Create or replace trigger client afterinsert on tt1 for each

1. Check whether the rpm is completeRpm-q -- qf "% {name}-% {version}-% {arch} \ n" binutils compat-libcap1 compat-libstdc ++-33 compat-libstdc ++-33. i686 elfutils-libelf-devel gcc-c ++ glibc. i686 glibc-common glibc-devel glibc-devel.i686