Database Administrator

Recently suddenly discovered oracle10g in sqldeveloper in the discovery of ORA-12514: TNS: listening process can not parse in the connection descriptor error, but can log on normally under sqlplus. Solution: 1. Open the /network/admin/listener. ora

In the process of maintaining GoldenGate, various problems are inevitable due to various accidents. It is necessary to master some common GoldenGate Fault Diagnosis and error analysis methods, and master these error analysis tools to further deepen

Project Introduction: The Amoeba for Mysql software is designed for the MySQL Distributed Database Front-end proxy layer. It acts as an SQLRouting function, focusing on Database Proxy at the distributed Database Proxy layer) development. It is

1. When the data in the database is accidentally deleted or deleted, you can use the following statement to query the data that has been deleted for a limited period of time: Note: Use the Administrator to log on to the system: Select * from table

ORACLE session count and connection count Configuration ORACLE session count and connection count Configuration ORACLE session count and connection count parameter configuration Log On As sysdba Sqlplus sys/xxxx as sysdba; View the

Some people in the QQ Group said that their database recovery mode was automatically modified, but no JOB was modified. They asked me if I could find out what happened. In fact, the SQL Server Error Log records the information about the database

Today, I suddenly found that the mysql database is down. InnoDB database problems, but cannot determine which database the problem is. Later, according to The searched content, rename ibdata1 under/var/lib/mysql to ibdata to solve the problem. 03:59

AIX is a UNIX System developed by IBM. It is a dedicated operating System used on an IBM computer of the 6000 or later. It has been rated by the industry as the best commercial UNIX System for many times. AIX is short for Advanced Interactive

Centos 5.6 x86_64 First, you need to install the required package: Yum install gcc-c + + gcc-g77 autoconf automake zlib * fiex * libxml * ncurses-devel libmcrypt * libtool-ltdl-devel * make cmake-y Then add the user: # Groupadd mysql #

Set TCP/IP on most UNIX systems, such as ifconfig and route, and then permanently enable the configuration by editing the initialization file. This can also be done in AIX, but it is best to use SMIT for all configurations. This ensures that

1) Start When you enable the system by enabling the power switch or using the reboot and shutdown commands, the following events may occur before the system is available: 1, ROS kernel initialization stage The ROS kernel resides in the

During the mysql exercise, the table is backed up in advance because the table is to be deleted, but the following ERROR is always prompted during restoration: ERROR 1046 (3D000) at line 22: no database selected The backup command is as

I recently encountered this exception when I used hibernate. I went to some forums and looked at it. Some bloggers did not publish answers to earn popularity, which led to a group of birds. Today I also encountered this exception, I also solved the

I. Hard Disk Structure 1. Basic hard disk structure The most basic component of a hard disk is a disk coated with magnetic media made of hard metal materials. The number of disks varies with the disk capacity. Each disk has two sides, and each side

Online MySQl incremental ETL because the source table does NOT have last_modified_timetimestamp not null default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP), it is more difficult to add up online ddl although there are tools, however, these

Detailed explanation of Binlog format as ROW 1. Row Replication Based on RBR is related to the record location. The binlog records only the data of Columns with changes in the relevant table, and introduces four events: table_map, Write_rows, Update_

1. Mount the Linux system CD Mount/dev/cdrom/media 2 switch to/etc/yum. repos. d/ Cd/etc/yum. repos. d/ 3. modify the configuration file Cprel. debuginfo. repoyum. repo. bak (Backup) Cpyum. repo. bakyum. repo rename) Vimyum. repo

1Attach a Linux system CD Mount/dev/cdrom/media 2Switch to/etc/yum. repos. d/ Cd/etc/yum. repos. d/ 3Modify configuration file Cprel. debuginfo. repoyum. repo. bak (Backup) Cpyum. repo. bakyum. repo rename) Vimyum. repo configuration file)

Count (*) Why is an "empty table" very slow? Why does it take 300 ms to select xxx from table limit 1 with dozens of rows of data? Will select min (pk) fromtable be slow? See the following example: Dba @ localhost: test 18:14:32> show create table

1.7 zset Structure First, introduce the concept of skip list, and then analyze the implementation of zset.1.7.1 introduction to Skip List 1.7.1.1 ordered linked List 1) Searching a key in a Sorted linked list 650) this. width = 650; "src ="