Database Administrator

MongoDB log Rotation MongoDB can use a standard method to rotate logs, that is, to obtain the current log and enable a new one. To achieve this, the mongod instance renames the current log file by adding a UTC (GMT) timestamp at the end of the file

ORA-32701 troubleshooting I. Version Information Operating system version: AIX 61009 Oracle Database Version: 11.2.0.3.11 (RAC) Ii. Error description Check found that a set of rac two instances Using ASM basically reported a ORA-32701 error every

Oracle and MySQL String concatenation I. MySQL In Java, we usually use the plus sign (+) to concatenate strings. in MySQL, we can also use the plus sign (+). For example: Add test data first Create table test (Id INT,Name VARCHAR (10 ),Score

MySQL master/dual Server Load balancer MySQL dual-host master architecture, coupled with Load Balancing Devices, can achieve high performance and high availability of mysql database load balancing, the server Load balancer device can divide the load

Alter system archive log current/all/switch logfile Alter system switch logfile;Force log switching is performed on the current instance in a single instance database or RAC to archive the current redo log. If automatic archiving is not enabled

Introduction to PL/SQL Program Design ① PL/SQL program design overview PL/SQL is an advanced database programming language used to access Oracle databases in various environments. Since the language is integrated into the database server, PL/SQL

Oracle compares two table structure differences and data differences. oracle differencesIn the work, we need to fulfill the following requirement: compare the two tables with the same structure and find the difference. Compare the two tables with

Oracle millisecond to time, oracle millisecond to time The date string for data inventory today is like this: 1.3377024E12. I wanted to use the program background to convert it and then display it on the foreground. After thinking about it, you can

[Password File loss-restore-1], password loss-1 Use oracle10g as the test version to delete the 10g password file: [Oracle @ oracle ~] $ Rm/u01/oracle/10g/dbs/orapwjadl10g Log on to the database remotely, and the password file will only take effect

Note When upgrading Oracle GoldenGate, oraclegoldengateThis article is the original article, reprint please indicate the source http://blog.csdn.net/msdnchina/article/details/42046205Oracle GoldenGate is being upgraded recently. refer to the

The error *** Please move GoldenGate to its own tablespace, movetablespace is reported when you run the GOLDENGATE ddl_setup. SQL script. SQL> @ddl_setup Oracle GoldenGate DDL Replication setup script Verifying that current user has privileges to

GPDB parallel loading test and gpdb parallel loadingTest File Information 10G Dec 12 14:10 A111G Dec 12 14:32 A210G Dec 12 14:10 B111G Dec 12 14:35 B2GPFDIST solution 1 Single Server drop table if exists host_1;drop EXTERNAL TABLE if exists exttable_

MySQL load data infile parsing, mysqlinfile Load data [LOW_PRIORITY] [LOCAL] INFILE'file_name.txt '[REPLACE | IGNORE] Into table tbl_name[FIELDS[Terminated by '\ T'][OPTIONALLY] enclosed by ''][Escaped by '\'][Lines terminated by '\ n'][IGNORE

An error is reported when a mysql-mmm environment is set up, and a mysql-mmm environment is reported. The following information is displayed when mmm_contorl show is executed after monitor is started. ERROR: Can't connect to monitor daemon!

MySQL [ERROR] Table 'mysql. user' doesn' t exist, mysql. userexist A newly installed mysql source code, because the my-default.cnf was not copied to the/etc/my. cnf location, when starting mysql encountered an error that could not open the mysql.

SQLite summary, sqliteZookeeper Generally, the static data type is fixed, while SQLite uses the dynamic data type, which is automatically determined based on the stored value. SQLite has the following five data types: 1. NULL: NULL.2. INTEGER: A

The weblogic service is inexplicably shut down and reports a segment error. weblogic is inexplicably Four weblogic nodes were released on site. the weblogic version was 10.3 and the jdk version was 1.6.0 _ 24. Services were inexplicably stopped at

Bug of rain and Oracle GoldenGate in Jinan, oraclegoldengateJinan is raining now (am). However, my mood is best described by Qi Qin's Song-"relentless rain, gently wake me up and make my tears ice like rain"I have just confirmed a bug of ogg in the

Solution to slow query caused by high water level line and water level line As we all know, with the continuous DML operations on table records, the high watermark line (HWM) of the table will be continuously improved. After the DELETE operation,

Mysql optimization: a deep understanding of the storage engine, index optimization, mysql Index Compare the storage methods of the two storage engines in the database: MyIsam: If you observe carefully, you will find that the database using this