Database Administrator

Oracle Database transfer from server A to server B Sometimes we encounter such a situation where the existing database needs to be transferred from one machine to another. Generally, we use export and import. However, if the database contains a

Relationship between the server parameter file (spfile) in the Oracle 11g parameter file and instance startup When the database starts, it needs to read the parameter file to allocate the memory area and locate the location of the control file. The

Oracle cross-database query (database link) How to Create a database link for cross-database Oracle Query Grant permissions to the dbuser account on the local Oracle Database SQL> grant create database link to dbuser; Configure the tnsnames. ora

GoldenGate synchronizes Oracle Data to GreenPlum Source endOracle 11.2.0.4 RAC 2-NodesOracle Linux 5.8 x86_64 Oracle GoldenGate V11.1.1.0.0 for Oracle 11g on Linux x86-64.zip Oracle GoldenGate V11.1.1.0.0 For FlatFile on Linux 64-bit for OGG v11.1.1.

Configuration of innodb_memcache Before innodb_memcache is installed, You need to import the configuration SQL, which is located in the share directory of the installation directory, and the file name is innodb_memcached_config. SQL, which can be

[Oracle] Golden Gate-concepts and mechanisms Golden Gate (OGG for short) provides real-time capturing, conversion, and delivery of transaction data in heterogeneous environments. OGG supports the following heterogeneous environments: OGG features:

Password verification during Oracle user Creation We need to perform some performance tests in the test environment today. In order not to affect the original data, we need to create a temporary schema. However, the following error is reported

Powerful ORM tool: nhibloud (iii) Five cores + simple object CRUD + HQL, ormcrud In the previous two articles, we have a rough understanding of nhib.pdf. Introduction to ORM: nhib.pdf (1) the role of nhib.pdf solves the conversion problem between

[Translated from mos] When Weblogic AdminServer starts fail, the error is "unable to get file lock, will retry", mosadminserver When Weblogic AdminServer starts fail, the error "unable to get file lock, will retry" is returned" Reference

Database optimization tips and database optimization tipsDatabase TIPS ::1. When creating a table for record or data analysis: Use Id as the primary key, 1, 2, 3... indicates the number of messages. The user account id is used as a foreign key. A

DDL (Data Definition definitions ages) and ddldefinition I haven't written any SQL statement for a long time. Let's review it. DDL defines different data segments, databases, tables, columns, indexes, and other database objects. Common DDL

Retired Note 2 # MySQL = lambda SQL: SQL + 'source Code 4 innodb ', Macro UNIV_INLINE> univ. I Struts: MySQL Handler APi Embedded API Row/Cursor B + Tree Index Insert Buffer Manager: Transaction Lock Buffer Log Storage Resource Manager: File

PLSQL defines record records and plsqlrecord records 1. Basic use of PLSQL Note: 1. Three paragraphs declare Begin Exception End; 2. Declaration: emp. ename % type; is the same as the attribute of the field. 3. begin: select stores variables with

Record an analysis of RAC node restart failure caused by Nic heartbeat failure. rac Node Database and CRS version: 10.2.0.4Down Process Analysis Serial number Node Time Action Log Source 1 II Jul 22:48:15 XXdb2

Changes cannot be saved. You must delete and recreate the following tables. You have made changes to tags that cannot be re-created, or you have enabled the change to prevent table re-creation after saving. You are not allowed to save the changes.

MySQL SELECT statement and mysqlselect statement SELECT statement: The products table is as follows: A selects a column FROM a table: mysql> SELECT prod_name FROM products; B. Retrieve multiple columns FROM the table: mysql> SELECT prod_id, prod_

Experience on creating indexes in mongodb It has been nearly a year since I came into contact with mongodb, And I have accumulated a lot of experience in indexing it. On this dark night, I would like to summarize the mongodb index. I. Index

Query the username, psw, gname, and tel of all realnames today.Table Structure:Table t1Field name: t1_id, username, pswTable t2Field name: t2_id, gname, t1_id // here one t1_id corresponds to multiple t2_idT3Field name: t3_id, realname, tel, t1_id //

Anyone who has been using MySQL O & M should be clear that online MySQL usually uses source code compilation, because this allows you to select the function to be compiled based on your own needs, although the MySQL source code compilation is quite

1 download the installation package download tar.gzWget http://download.csdn.net/detail/mchdba/75450372. Install the cmake Software PackageYum install cmake-y3 create account of mysqlGroupadd mysqlUseradd-g mysqlAutoreconf -- force --