Database Administrator

When installing 64-bit Oracle 10 Gb in Oracle Linux, The ins_ctx.mk problem occurs. When 64-bit Oracle 10g is installed on Oracle Linux Server Release 5.7, the following problems are encountered: Error in invoking target 'install' of makefile'/u01/

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

Oracle RAC 10.2.0.5 Install For redhat 5.8 (use raw device) Because the customer's database needs to be patched, similar test environments are installed. You must first install Oracle RAC 10.2.0.1 and then upgrade it to 10.2.0.5. Because I have many

How to obtain MySQL help information When a MySQL-related fault occurs in the development or test environment, most of my friends may post on the Forum and discuss the problem with the QQ group. This method is one of the effective ways to get help.

[Translated from mos] The Alter Database Add Supplemental Log Data command is suspended, mossupplemental Alter Database Add Supplemental Log Data command suspendedSource:Alter Database Add Supplemental Log Data Hangs (Document ID

Terminating the instance due to error 481 causes the ASM to fail to start. terminatingasm1. symptom description When a RAC database is accidentally shut DOWN, the first node starts normally, but the second node cannot start ASM and CRS resources.2.

Redis Research (16)-publishing/subscription mode, redis subscription In the previous article, we wrote the Redis task queue. Http://blog.csdn.net/wtyvhreal/article/details/43112735 In addition to implementing the task queue, Redis also provides a

Oracle will you really use the ltrim/rtrim function ?, Ltrimrtrim The common usage is to remove spaces. How many people do not know that they can actually remove spaces? It has the ltrim () and ltrim (x, y) methods. ------- Remove spaces on both

Mysql HA-Install DRBD + HeartBeat + Mysql On Redhat 6.3, ha-installdrbd Configuration information: Primary：Name:zbdba1OS:redhat 6.3IP:192.168.56.220drbd:8.4.0heartbeat:3.0.4Standby:Name:zbdba2OS:Redhat

Oracle-specific index type resolution, oracle-index resolution2.1 B-tree index (default type)The B-tree index is a common index in Oracle. When creating an index, it is the default index type. The B-tree index can be a (simple) or composite

Simple tutorial on SQL statements in linux --- primary key, foreign key, and SQL Primary Key)Each item in is a unique value in the table. In other words, it is used to uniquely identify each row of data in a table. A primary key can be a column in

ORACLE 11G from scratch-20141208, 11g-20141208 Section 1.3.6 It is used to store all the data of an object with an independent storage structure defined in a tablespace. It consists of one or more zones. 1. Data Segment Used to store all data in

Mysql on linux reports Table 'xxx' doesn' t exist error solution, mysqlexistMysql on linux reports Table 'xxx' doesn' t exist error SolutionProblem: The program reports the error of Table 'xxx' doesn' t exist, but the database shows that the Table

Install MySQL in windows and MySQL in windows 1) double-click the MySQL Installation File mysql-essential-5.0.82-win32.msi to enter the welcome page. Click Next To Go To The installation type page. 2) on the installation type page, the first is the

Concurrent transaction processing and concurrent Transaction Processing Transaction protection is a must for the software industry. Many financial companies simply fail to handle transactions. As we all know, transactions have four major features:

DB2 "The transaction log for the database is full" problem and solution, db2transaction DB2 reports "The transaction log for the database is full .. "error. I checked the document because the DB2 log file is full. First, run the following command

SQL server's case when then statement, sqlcase -- Select DataName,-- Case Code---- When 'w01' then 'male'---- When 'w07 'then' female'---- Else 'others'---- End as Code-- From dbo. HistoryData Select DataName,(CaseWhen Code = 'w01' then 'male'When

Validate command --- rman for backup and reply verification, validate --- rman As an oracle backup and recovery tool, rman provides us with powerful functions, including physical and logical detection of data files and validity detection of backup

IT Ninja Turtles Oracle query tree structure, Ninja Turtles oracle The select statement in Oracle can use the start with... connect by prior clause to implement recursive queries. connect by is used in structured queries, The basic syntax is: Bytes -

How to solve sybase ASE log Overflow 1. Prepare the database environment -- Create a device disk init name = 'dat1', physname = '/opt/sybase/data/dat1', size = '1m' disk init name = 'log1 ', physname = '/opt/sybase/data/log1', size = '1m' -- the