Database Administrator

Relationship between MySQL mysqld file generation permission and UMASK Today, because of the binlog File Permission issue, the final tracking is that the MySQL installation initialization specifies the permission for the MySQL user to generate the

Configure Statspack in Oracle RAC Environment Statspack is a product of the Oracle 9i era. It has a cross-milestone significance for monitoring and analyzing database performance and is the predecessor of AWR. After 10 Gb of Oracle, AWR replaces

Oracle data comparison (DBMS_COMPARISON) A data comparison package (DBMS_COMPARISON), but this package is less than used. So let's talk about the use of this Toolkit today. For friends who often finish data migration, after data migration, the most

Oracle cancel-based Incomplete recovery Experiment: Oracle cancel-based Incomplete recovery View lab environment Lsnrctl statusSelect open_mode from v $ database;-- Monitoring and database status Show parameter recovery;Select flashback_on from v $

Silent Installation of Oracle 11g R2 in CentOS 5.10 I found many articles about installing Oracle 11g R2 silently in Linux on the Internet, which are messy and varied! Come to the literacy class! Install Oracle 11g R2 in CentOS 5.10 *****************

Oracle 11g R2 (GI) Startup Process 11gR2 cluster management software (GI) startup sequence and diagnostic methods In this article, we will introduce the Starting sequence of 11gR2GI and introduce common problems and corresponding solutions during GI

Install and deploy the Galera Cluster for MySQL Cluster under CentOS 6 Galera Cluster for MySQL is a multi-master MySQL Cluster solution based on synchronous replication. It is easy to use and has no single point of failure (spof) and has high

Introduction to MySQL Binlog Basic definition of binlog: Binary logs are also binary logs that record SQL statements that have occurred or potentially changed data and are saved in the disk in binary format; Role: MySQL is similar to Oracle archive

Common Methods for Solving oracle deadlocks (tried and tested) and oracle deadlocks -- 1. query the locked status Select object_name, machine, s. sid, s. serial # From v $ locked_object l, dba_objects o, v $ session s Where l. object_id = o.

ORA-00265: instance recovery required, cannot set ARCHIVELOG mode, restorearchivelogSymptom: I reported an error ORA-00265 after executing the open archive command SQL> alter database archivelog; alter database archivelog * ERROR at

SQL hierarchical summary and SQL Classification -- Test Data create table tb ([DB-ID] varchar (10), ENTITY varchar (10), DATE varchar (10), [CUST-NO] int, AMOUNT decimal ), TAX decimal (2004) insert tb select 'rchq', '001', '2017-11-10 ', 200000,100.

Installing 11.2.0.3 or 11.2.0.4 db sofrware on rhel6 reports a lack of "elfutils-libelf-devel-0.97" And "pdksh-5.2.14 ", Installing 11.2.0.3 Or 11.2.0.4 (32-bit (x86) or 64-bit (x86-64) On RHEL6 Reports That Packages "elfutils-libelf-devel-0.97" And

MySQL system variables (system variables), mysqlvariables MySQL system variables are actually some system parameters used to initialize or set the database's occupation of system resources and file storage location. These System variables can be

Configure statspack and racstatspack in Oracle RAC Environment Statspack is a product of the Oracle 9i era. It has a cross-milestone significance for monitoring and analyzing database performance and is the predecessor of AWR. After 10 Gb of Oracle,

[Oracle] OPatch upgrade, oracleopatch During the PSU upgrade, opatch prereq CheckConflictAgainstOHWithDetail-phBaseDir./12419378 Detection Error: Invoking prereq "checkconflictagainstohwithdetail" The location "./9352164/README.html" is not a

The mysql transaction rollback is invalid. A strange thing happened to the Payment Service recently. When a transaction fails, you call rollback and find that only the last SQL statement is rolled back. After a long time of development check, it

Modify the parameter file spfile and disable the database startup. Since the parameter file spfile is a binary file, you cannot directly use a text editor to modify it. We can start the database and then use the SQL command to modify it: alter

[MySQL] using Profiles to view the execution time consumption of the create statement, profilescreate  1. view the status value of profiles1. Check whether profiles is enabled. By default, profiles is disabled.Mysql> show profiles;Empty set (0.02

ORA-01548 in Oracle: active rollback segment '_ SYSSMU1 $' found, ora-01548_syssmu1 ORA-01548 in Oracle: active rollback segment '_ SYSSMU1 $' found Oracle Undo tablespace recovery (no backup) http://www.linuxidc.com/Linux/2014-06/103779.htm Undo

Basic functions in MysqlThe time function select curdate (); returns, excluding the hour, minute, and second select curtime (); returns 14:13:22, excluding the year, month, and day select now (); returns 10: 46: 17 select unix_timestamp (now ();