Database Administrator

The management framework includes: database instance, listener, and Management Interface (database control, management proxy, which is used by Grid control)Manage database control (Oracle provides a Database control console for databases that are

In Linux, the configuration of MySQL remote access settings is described a lot on the Internet, but the actual operation is still a lot of trouble, record it (Attention should be paid to the red area.). The first step is the same as configuring

The master-slave synchronization of mysql fails. the following error is reported in the log:120309 18:39:23 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000004 'at position 2207467, relay log'./mysqld-relay-bin.000011'

Stored Procedures and functions A subroutine stored in a database for calls by all user programs is called a stored procedure and a stored function. Create a stored procedure: UseCREATE PROCEDURECommand to create a stored procedure and a stored

Environment: MySQL Server 5.1 + Navicat for Mysql 8.2 Problem: A 121 error occurred while deleting the foreign key. Solution: Change the foreign key name to another name. For error information, refer: Error 121This is an error where the names

1. Execute database creation commands[Oracle@www.bkjia.com database] $ dbca-silent-responseFile/home/oracle/database/dbca. rsp 2. The reported template does not exist. The error message is as follows:Template General Purpose does not exist. Please

The configuration of ASM in Oracle RAC can be implemented in two ways: raw and asmlib. Raw is recommended for actual maintenance. There are two ways to use raw: multipath and UDEV. On the RedHat platform, refer: Redhat 5.4 + ASM + RAW + Oracle 10g

MySQL, a database generated by the Internet, is used by countless websites and games. It is said that google, tencent, and taobao are all using it. During the rapid development of the Internet, because of the needs of high-speed cache and the

I. Fault symptom: SQL> conn system/OracleERROR:ORA-28000: the account is locked Warning: You are no longer connected to ORACLE.SQL> Ii. Cause Analysis:Unable to log on because the system is locked Log on to the operating system using the sys user or

In the Oracl RAC 10.2.0.4 environment where the operating system is Linux, the local hard disk of a node server is suddenly damaged and stops running. The remaining node still works normally and continues to provide external database services. The

1. Install SQLite3 Sudo apt-get install sqlite3 2. Install the Toolkit required for Sqlite3 Compilation Install the Toolkit if necessary. It is just for the sake of experience. You can skip the installation. This item is optional. Apt-get

In Linux, allow external ip addresses to access your MySQL database: 1: Set the mysql configuration file /Etc/mysql/my. cnf Find bind-address = 127.0.0.1 and comment it out; // This will no longer allow local access only; Restart mysql:/etc/init.

Oracle SQL Developer 3.1.07.42 is installed in Linux Mint 12 (see). It feels good to connect Oracle, Mysql, and SqlServer ......., but there has always been a problem, that is, when the mouse is clicked, the mouse will be offset. Specifically, the

Toad for Oracle-Basic Edition It contains different features, from PL/SQL and SQL scripts, PL/SQL and SQL debugging suite to built-in knowledge basics: Knowledge Xpert for PL/SQL and Knowledge Xpert for Oracle Administration Stration. it allows you

For example, there is a shortage of hard disk space in a development library recently. A new disk is added to prepare to move all the data files to the new disk.First, list the data files to be moved. The data files belong to the tablespace. The

Database Synchronization Process, the strictest indicator, the first is efficiency, that is, the number of SQL records synchronized per second; the second is consistency, that is, the data generated by the master database, whether the data is

I. Applicable background There is a database named test, whose data is in the device test, and the log is in the device test_log; The test database has a table tab1 with 5 Records (1-5 ); Complete database backup: dump database test to

Brief description of PostgreSQL database operations PostgreSQL database version Psql -- versionPsql (PostgreSQL) 9.1.3 I. Database Backup 1. Backup database structure Su-postgresPg_dump-Fc-s-f testdbschema. SQL testdb 2. Back up database

The Flashback Drop flash-back deletion function of Oracle provides a convenient Recovery Method for deleting tables by mistake. The principle of this function is the RecycleBin function of Oracle. Note: If the table to be deleted is originally

For RAC, when an Oracle Instance fails, the application has several high-availability technologies to ensure availability. These technologies are transparent to the client, and the client may not be able to perceive the instance failure.1.