Database Administrator

DataGuard: troubleshooting of non-real-time update small problems in the logical standby database of the DG Series I. Overview DataGuard is increasingly becoming an important tool for disaster recovery and pressure-sharing in databases. As the

Whether the DML operation affects the exported data during EXP Export I. Overview With the upgrade of the database version and the increase of business testing, database or data migration has become one of the common tasks of database managers. If

Mysql kernel: nf_conntrack version 0.5.0 When I want to check the mysql database today, the messages log contains a large number of mysql kernel: nf_conntrack version 0.5.0 connection information. Now I will record the solution and hope to help

Oracle trigger troubleshooting example Routine checks on the AWR Report of the database. An update statement is executed multiple times for over 30 seconds each time. This SQL statement is very simple, that is, modifying data based on primary key

ORA-00600 event resolution When the Oracle database is started, close it directly to view the alarm log: Errors in file/opt/oracle/diag/rdbms/orcl11g/orcl11g/trace/orcl11g_mmon_3749.trc (incident = 65276 ):ORA-00600: internal error code, arguments: [

Ohasd failed to start: Inappropriate ioctl for device, ohasdinappropriate Today, my colleague encountered a problem when installing GI. Let me take a look. The following record is as follows: Symptom: When installing gi, run root. sh and report the

Mysql Access denied for user 'root' @ 'localhost' (using password: YES), deniedlocalhost [Symptom description] C/S program remote access is normal, local access reports the following exception MySql.Data.MySqlClient.MySqlException (0x80004005):

Database Table Design for Mysql optimization and database table Optimization for mysql Separation of Fixed Length and Variable Length Separation of common and uncommon Columns For example: This table is not good enough and can be optimized.

Oracle databases cannot be accessed using localhost and 127.0.0.1. oraclelocalhost I recently learned about Oracle databases and installed Oracle 10g (Version: oracle_10g_10.2.0.20.win32) in Windows XP SP3 on a virtual machine ). After the

Use the kettle component to import an excel file to the database, kettleexcel Use the kettle component to import an excel file to the database 1. Goals Import the excel file content to the target table. Then, use java to call kettle conversion. The

SQLServer ----- use jTDS to connect to the SQLServer database, sqlserver ----- jtds 1. Introduction to jTDS JTDS is an open-source JDBC3.0 driver implemented in Java 100%. It is used to connect Microsoft SQL Server (6.5, 2012,) and Sybase (10, 11, 12

[MongoDB] From getting started to mastering the mongdb series learning book, if you want to learn mongodb, please come in, mongdbmongodb I have been studying MongoDB for some time and have compiled more than 40 blogs. Download the mongodb software

Oracle-stored procedure exercises, oracle-Stored Procedure -- ==================================================== Stored Procedure = ========================================================== =======/ ** scm_iss.test_imit_pro1 * No parameter Stored

Install MySQL and Ubuntu tumysql1. Verify that MySQL is installed on the original host:Run the sudo netstat-tap | grep mysql command to check whether the MySQL port exists. If sudo is not added, the execution fails because of the permission: $

Mysql load data infile usage, mysqlinfile The load data infile statement reads a table from a text file at a high speed. 1. Basic syntax LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE] INTO TABLE tbl_name

[MongoDB] mongodb sharded cluster (6) on windows platform, mongodb Cluster In this blog, we mainly discuss blog management. Since we have already written detailed examples in the previous five articles, we will not illustrate them here. I.

Oracle 11g new virtual column partition, oracle11g There is a need: a document table should be partitioned by month. If it is on Oracle 10 Gb, only one field can be added. It will be different after the Oracle 11g. You can use virtual column

Configure ORACLE 11g adg and oracle11gadg I installed 10 Gbit/s in the past without taking notes. I used the duplicate method to install an 11 Gbit/s ADG yesterday. The process was hard and I recorded the following:   I. Environment

SQLSever: how to generate different random numbers for each row in the select statement ?, Sqlseverselect The random function of the select statement is a bit false, maybe because it is based on time. In the same select statement, random numbers are

MySQL series: Memory Management for innodb Engine analysis, mysqlinnodb Innodb implements its own memory pool system and memory heap allocation system. In the innodb memory management system, there are roughly three parts: basic memory block