Database Administrator

Installation of MySQL automated O & M MySQL is usually installed using RPM or source code.RPM installation is fast and convenient. the disadvantage is that the installation directory cannot be customized. if you need to adjust the storage location

Procedure for configuring a Shared Server in Oracle Oracle configuration sharing Server:1. Configure the second listenerNetca/manualManual: listener. oraLSNR_2 =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP) (HOST = Demon) (PORT = 1526

Common Oracle System packages and common methods 1. dbms_metadata.get_ddl: generate the ddl information of the database object: 2. dbms_stats is used to collect, view, and modify the optimization statistics of database objects. Exec

Test MySQL performance using sysbench 0.5 In view of my recent interest and passion for OpenStack, I want to ensure that I can perform proper system performance evaluations. I mainly started to switch to sysbench because it brings a series of tests

MongoDB operating factors and data models The data of the MongoDB modeling application depends on the data itself, which is also related to the characteristics of MongoDB. For example, different data models may increase the query efficiency of

ORA-28000: the account is locked user locking troubleshooting Today, my colleague reflected a problem, a test database modified the password, and changed the password used by the relevant application, still appear after a while the account is locked,

Analysis of PostgreSQL pg_cmd.conf File I recently tried PostgreSQL 9.04 and shared my experiences with pg_mirror.conf configuration. Pg_cmd.conf is the configuration file for client authentication, which defines how to authenticate the client. The

Automatic Backup of asm disk header after Oracle 10.2.0.5 Before Version 10.2.0.5, the ASM disk header was not automatically backed up. You must manually run kfed read or dd to back up the disk, From 10.2.0.5 onwards, the ASM disk header will be

Git is used in linux and Gitlinux * Initialize the git repository and use the git init command * Add a file to the git repository in two steps: 1. Use git add filename. You can use it multiple times and add multiple files to the temporary storage

EM 12c: OMS Failed to start After restarting the Repository Database or reboot of the server, omsrestartingEM 12c: OMS Failed to start After restarting the Repository Database or reboot of the server This problem was found when Oms was started today

Tranlogoptions rawdeviceoffset, tranlogoptions Today, we will introduce the tranlogoptions rawdeviceoffset parameter in ogg. this parameter is not described in the ogg official documentation. This parameter is used when you use a bare device. Let's

Check the empty rows in the kettle data stream.Zookeeper Check for empty rows in the kettle data stream   During ETL processing, sometimes data needs to be generated but data is not input, which may cause some problems. Therefore, ETL data streams

IReport + jasperreport: how to create a sub-table (1), ireportjasperSubtables are essential in the process of creating reports. Today I have studied several ways to create subtables. 1. Create a sub-table by connecting to the database Take MySQL as

Install mysql5.5.17 source code and mysql5.5.17 source code1. Download the source code packageSOURCE code package is often compressed tar.gz, the name only contains version information, the size is much smaller than the RPM package, Binary Package,

Use DbUtils to add, delete, modify, and query the implementation class of the ResultSetHandler interface. In the previous article "use DbUtils to add, delete, modify, and query", we found that when executing the runner. query () line of code, we

Use an SQL statement that has been running for a long time in the mail, and send an SQL statement in the mail ALTER proc [dbo].[usp_EmailLongRunningSQL]asbegindeclare@LongRunningQueries AS TABLE( lrqId int IDENTITY(1,1) PRIMARY KEY, spid int NULL,

Database Connection sorting and database sorting Connections can be divided into internal connections, external connections, cross connections, and self-connections.1. Cross join 1) supported databases: ORACLE, MYSQL, SQL Server, and DB2. 2)

Optimization of SQL statements in ORACLE notes, oraclesql statements SQL statement optimization is summarized as follows:   To optimize SQL statements, follow these six steps: Rational use of Indexes Avoid or simplify sorting Eliminate scanning

Cainiao database (6)-enabling and disabling Oracle services conveniently and quickly Background: As a programmer, in daily work, our computer often needs to run many programs at the same time, such as Eclipse, browsers, and instant messaging

ORA-00600: [kfgFinalize_2], Environment: OS: OEL5.6 RAC: 10.2.0.1.0 [Root @ rac2 ~] # Crs_stat-t Name Type Target State Host ------------------------------------------------------------ Ora... B1.inst application ONLINE rac1 Ora... B2.inst