Database Administrator

MySQL has become one of the most widely used databases on the network, especially for Web applications. It occupies the absolute advantage of Small and Medium applications. All of this comes from its small and easy-to-use, secure and effective, open

The purpose of this article is to show friends how to compile MySQL code. Some people may think that compiling MySQL code on Windows is complicated. If you have any questions about the knowledge mentioned in this article, you can seek help through

SQL Server itself has data import operations. However, if you want to import data from a backup file, you need to perform other operations. The following is an example. There is already a DOE database on the SQL Server and there is a large amount

Oracle 8.0 introduces recovery management (RMAN) and implements real Incremental backup for the first time. Before RMAN, the database output can also be incremental, but once any part of a table changes, the entire table needs to be overwritten.

Tora is a database tool similar to toad in unix/linux.In Ubuntu (Dapper Drake), Tora installed with apt-get has only one provider of PostgreSQL. Method to add Oracle Support to Tora. The general steps are as follows (there are several differences

This article describes how to optimize your Oracle in Linux through 12 procedures.1. Standard optimization: follow the instructions in the Oracle technical documentation to tune your Linux, such as shared memory. I will not go into details here,

This article describes in detail the initial settings after installing the MySQL database in Ubuntu.1. It should be easy to install MySQL, and I don't think there is much problem in the installation, so I will not talk about it much. Next let's talk

Database Oracle10202, memory 4G, adjust the database sga_target, initially sga_target is 160 M, ready to adjust it to 2147483648, the results of the error ORA-27102, after multiple experiments, it is found that the database is started when

I remember that because there was no network, I mistakenly wrote the root password as follows:Update user set password = "122" where user = "root ";Then mysql will not work.# Mysql-u root-p#123ERROR 1045 (28000): Access denied for user ''@

I use binaryto install the file named mysql-standard-5.0.18-linux-i686-glibc23.tar.gz. [1] decompress the above file to a certain place and change the directory name of MySQL to mysql. The result should be as follows:/home/jiang/mysql [2] INSTALL

HBase source code analysis-GET operation-to-scan Conversion 1. Let's look at the constructor first. Public Get (byte [] row ){This (row, null );} Public Get (byte [] row, RowLock rowLock ){This. row = row;If (rowLock! = Null ){This. lockId = rowLock.

Solemnly declare that BBED is an internal Oracle tool. If this database is not supported once you use oracle, exercise caution. 1. Create bbed (10 Gb test) [Oracle @ rac1 ~] $ Cd $ ORACLE_HOME/rdbms/lib [Oracle @ rac1 lib] $ make-f ins_rdbms.mk BBED

Solution to ORA-12520 errors The ORA-12520 listener cannot find the available handler for the requested server type: 1) The database is a dedicated server, but the connection mode is set to shared in the tnsname. ora configuration. In this case,

The Oracle9Dialect dialect has been deprecated; use either Oracle9iDialect or Oracle10gDialect insteadThat's because Dialect is undefined. Rewrite the class and register the undefined Dialect,And add it to hibernate. cfg. xml.Org. hibernate. dialect.

Experiment with SQL profile fixed execution plan Oracle has outlines before 10 Gb, and SQL profile after 10 Gb is one of the new features. Outlines is insufficient for SQL statements that are not bound to variables. The following is the experiment

RMAN backup refers to the method for backing up data files, control files, archiving logs and spfiles using Recovery Manager. In addition, because RMAN backup is completed by the Target Database server process, when RMAN is used for backup, the

When you use the dbca command to delete a database instance, for example: We can see that the column "delete database" is gray and cannot be deleted! Some people solve this problem: Windows 7, 10g 10.2.0.4 Find dbca. bat in bin and right-click

Eight Important Notes for Data Guard to deploy the physical standby database. These eight points are mainly for DG deployment after 10g R2. ① Set the master database to force logging Mode Idle> select force_logging from v $ database; Idle> alter

Oracle 7 v7.2 recovery outline Author: Andrea Borr & Bill Bridge Versions: 1 May 3, 1995 Summary This topic describes how to recover a database in Oracle 7.2. Readers of this article should be familiar with the management guide of Oracle 7.2.

Background: Now, I want to practice Incremental backup of rman. The original test database is in non-archive mode. After the shutdown instance is shut down, the open instance cannot start. Sys @ Oracle10> alter database open;Alter database