Database Administrator

Use pt-table-checksum to verify data consistency The consistency check of Master/Slave Data is a headache. It is frustrating to be occasionally complained about inconsistency between master and slave data or data inconsistency between several slave

Oracle lock table troubleshooting instance One time a developer directly runs the delete table operating system on the database server during peak hours, resulting in no response for a long period of execution. Then, the SQLPLUS client is closed and

Oracle 11gR2 Database and Active Data Guard migration case The customer's core system is composed of an Oracle Database 11.2.0.3.4 single machine and an Active Data Guard, which run on two PC servers respectively. The Oracle Linux 5.8 x86_64bit

ORA-00600 [kqlInvObj: user] Processing Today, our brother called us to say that after I installed 11.2.0.1.0 on the Development Database (win7 64bit), I had a problem with the Data Pump derivative, which was hard to solve. Then I ran the SQL

Four Redo loss situations and Solutions I. Description:1. The CURRENT log indicates that the log status is CURRENT and ACTIVE, and the non-CURRENT log indicates that the log status is INACTIVE.2. You do not need to consider the archive and

B-tree index usage rules optimized by MySQL B-tree index usage rules optimized by MySQL Start with a question: Suppose a table has a joint index (c1, c2, c3, c4). Only c1, c2, and c3 parts of the joint index can be used.A where c1 = x and c2 = x and

Oracle 11gR2 Active Data Guard adjustment case [1] The customer's environment is Oracle RAC Database 11.2.0.3 for Linux x86_64bit + Oracle Database 11.2.0.3 for Linux x86_64bit (ADG slave Database). RAC uses ASM and the slave Database uses the file

About gpdb password md5, gpdbmd5 Gtlions = # alter user gtlions password 'gtlions'; ALTER ROLEgtlions = # select * from pg_shadow; usename | usesysid | usecreatedb | usesuper | alias | userepl | passwd | valuntil | useconfig --------- + ---------- +

C # connect to the mysql database, 1. Driver required Download MySQLDriverCS-n-EasyQueryTools and select the version as needed. 2. Project import driver 1) Add in reference Select Light color in the figure, OK. 3. Code Block Add header

Oracle-SQL_TRACE use, oraclesqltraceSelect sid, serial # from v $ session where schemaname = 'Scott ';Select p. spidFrom v $ session s, v $ process pWhere s. paddr = p. addrAnd s. sid = & 1And s. serial # = & 2;Exec dbms_monitor.session_trace_enable

When a windows client is added to a domain, an error occurs: the DNS name does not exist. When a windows client is added to a domain, an error is reported: the DNS name does not exist. The specific error is as follows: -------------------- Note:

Notepad ++ changes the font size and color and notepad font size Many of my friends are new to notepad ++ and do not know where to set the font or how to set it.Tools/Raw Materials Notepad ++ Method/step Click Settings and select language

Common memcache monitoring methods: memcache monitoring Common memcache monitoring methods 1. graphical mode: Reference: http://jingyan.baidu.com/article/6525d4b11f482bac7d2e94da.html Download memcache in http://pecl.php.net/package/memcache,

Alex's Hadoop cainiao Tutorial: 6th Sqoop2 installation tutorial, hadoopsqoop2Install sqoop on the server and client. Install the server first. $ sudo yum install sqoop2-server Then install the client $ sudo yum install sqoop2-client Server

Mysql number generation, mysql number 1. Serial Number Generation Method DELIMITER $ create definer = 'root' @ 'localhost' FUNCTION 'get _ workno' () RETURNS varchar (45) CHARSET utf8BEGINDECLARE newWorkNo varCHAR (45 ); DECLARE currentDate varCHAR

At the beginning of oracle, Scott's account was locked. scottlock 1. First, you need to unlock the Scott account and enter alter user scott account unlock. Then, a prompt is displayed, indicating that the scott account has expired and the password

If the Java language in the backend JSP file operates the JGeometry object provided by Oracle Spatial, spatialjgeometry Write down a flow account and record how to solve this problem that has plagued you for a long time. At that time, I thought I

[MongoDB] Seven major implementation skills of MongoDB and seven major mongodb skillsTip 1: using the correct type to store data with the correct type is of great benefit. The data type affects the data query method, data storage sequence, and

Blue growth note-chasing DBA (11): After going home, I woke up and went home.   Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be

Ing SQL server database users to login users, sqlserver Recently, a friend of mine accidentally shot the SQL server database. After several twists and turns, the data restored the database to the new environment. After recovery, there will be a user