Database Administrator

Best practices for MySQL upgrade MySQL upgrade is very necessary. We listed a variety of questions about MySQL upgrade best practices on Percona Support. This article recommends some methods to upgrade MySQL in different situations. Why is MySQL

ORA-21779: duration not active problem solution The user tells a RAC environment database to generate a large number of ORA-21799 error messages in the log, the alert Log part is truncated as follows: Mon Jan 06 10:27:24 2014Errors in file d: \

Solution to plsql Database Password Expiration: plsql expiration Recently, when logging on to plsql, the system prompts your password has experied, asking you to change the Database password. The solution is as follows: 1. When logging on to plsql,

Configure Eclipse Xdebug debugging tool in Ubuntu 13.04 + Firefox's easy Xdebug component, 13.04 xdebug Step 1: Install the php_xdebug extension and check whether the installation is successful. [Html]View plaincopyprint? Sudo apt-get install php5

How to create a new database instance for Oracle 10g XE?For Windows, first ensure that there is no important data in the current XE instance. Then, call oradim-delete-sid xe to delete the current system service (Windows Service ).Run XE. bat in D: \

[Test] database system principle-detailed explanation (Chapter 1), detailed explanation of legend monster Database I still remember the first time I read this book, it was very messy, especially the three or four chapters. I didn't understand this

Blue growth note-chasing DBA (5): Not talking about technology, business, annoying application systems, not talking about dba ************************************ Statement *************************************** Personal Growth records on the

Understanding of DRM in oracle 10g RAC, racdrmSummary of DRM1. What is DRM?Dynamic Resource Management (DRM) is a new feature of oracle 10 Gb. in oracle rac environment, ORACLE uses GRD (Global Resource Service) to record Resource information of

Mysql-views, stored procedures, triggers, and mysql-Views I. VIEW A view is a virtual table and does not store any data. Only the running time contains the dynamically retrieved data. Eg: SELECT sid, name, sex, s_num FROM student, school WHERE sid =

Introduction Database coffer (DBCoffer) is an Oracle data security enhancement product based on the Oracle extension mechanism, featuring high data security, completely transparent applications, and efficient ciphertext access. DBCoffer can prevent

Principles of database sharding and implementation method based on thinkPHP, database sharding thinkphp Why table sharding? database sharding: When the data volume and access volume of our data tables are large or frequently used, a data table

[Translated from mos] New asmcmd commands of 11gR1 version: cp, md_backup, md_restore, 11gr1 -- cpNew asmcmd commands of 11gR1 version: cp, md_backup, md_restoreReference Original:ASMCMD-New commands in FIG (Doc ID 451900.1)Applicable:Oracle

MySQL Data processing functions and mysql Data ProcessingData processing functions sometimes process the data obtained from database tables. For example, replace lowercase letters with uppercase letters. This process can be performed on the client

SQOOP is an open-source tool mainly used for data transmission between Hadoop and traditional databases. The following is an excerpt from the SQOOP user manual. Sqoopis a tool designed to transfer data between Hadoop and relational databases. you

Zookeeper Pre-11gR2: "crsctl check crs" command hangs at EVMD check (Document ID 1578875.1)Applies:Oracle Database-Enterprise Edition-Version 10.2.0.3 to 11.1.0.7 [Release 10.2 to 11.1]Information in this document applies to any platform.SYMPTOMSIn

Golden Gate (OGG for short) provides real-time capturing, conversion, and delivery of transaction data in heterogeneous environments. OGG supports the following heterogeneous environments: OGG features: Small impact on the production system:

Football and oracle series (3): oracle process rankings, the World Cup round is about to fight! Statement: This is not a technical document. Since I have learned a few tricks about oracle, I cannot afford to sell it to anyone. Just after a meal, I

Stored Procedure Overview The commonly used operating database language SQL statements must be compiled and then executed before execution. The Stored Procedure (Stored Procedure) is a set of SQL statements for specific functions, after compilation,

With the upgrade of the Oracle version, RMAN is also enhanced. RMAN in Oracle11g supports the use of different operating systems and different databases. For the compatibility of RMAN, refer: Oracle RMAN compatibility and FAQs between different

ORA-01000 is a common exception in development. This exception indicates the number of opened cursors in the program> the maximum number of opened cursors set in the database. This exception is usually caused by two reasons. 1. The maximum open