Database Administrator

MySQL configuration file The latest MySQL product actually exceeded the version carried by Red Hat Enterprise Linux. However, stability and open source code are very important factors, so it makes sense to use an earlier MySQL version on the

Oracle Database provides several data backup methods, but the most commonly used is logical Backup Using exp. Physical backup (including online backup and offline backup) is not used much. The main reason is that the physical backup process is

PostgreSql Procedure copy split string to table, postgresqlsplit In my scenario, there is a table with a field storing data using split string. Although Hibernate provides org. hibernate. annotations. Type annotations, You can implement org.

For beginners, there are always the following questions about the connection between client tools and database servers: Do I have to install the Oracle database on a local machine?If I have installed an Oracle database locally, why is it so stupid

Oracle (replace + substr) function used in combination, oraclesubstr select replace('33021622221111',substr('33021622221111',7,4),9527) from dual; How to Use the substr function in oracle SubstrTruncates string functions in

[MongoDB] The Regex Expression query of MongoDB, mongodbregex In the past two blogs, the topic mainly focus on the high query operation of mongodb. in this blog, we simply study the regex expression in the mongdb. mongoDB also support the regex

Environment: Operating System: windows xp Virtual machine: VMware 5.5.3 Linux: RHEL 5 Note: Since RHEL 5 is not supported in Oracle official documentation, the following configuration items are subject to Oracle requirements for RHEL 4.0. I. Check

How is Buffer Busy Waits generated? As an Oracle Dba, if you have never met Buffer Busy Waits, you cannot count as a real Oracle Dba. Buffer Busy Waits is a common wait for Oracle databases, especially in environments with frequent concurrent writes.

In this Document   Purpose   Scope   Details   Concepts & Overview   Administrator-managed Database   Basic Method   Preconnect

WebLobic Server is an industry-leading application Server developed by BEA. Is a pure java implementation of SUN J2EE. WebLogic has long been regarded as one of the best J2EE tools on the market. Like a database or email Server, WebLogic Server is

Next to Oracle Fusion Middleware I: database and RCU (SEE), this article describes the installation of Weblogic, UCM (WebCenter Centent), and WebCenter Portal. 1. Weblogic selects 10.3.6.0 and can be installed using the Installation File of

I. Overview I have written two articles about Oracle Data Pump before: Oracle 10 gData Pump Expdp/Impdp Oracleexpdp/impdp example These two articles describe the use of data pumps. In actual use, we will also encounter a problem where some ORA-xx

XML query in SQL SERVER: FOR XML specifies PATHPreface In SQL SERVER, you can specify RAW, AUTO, EXPLICIT, and PATH for XML queries. This article uses some examples to introduce the XML query of the specified PATH in SQL SERVER. PATH Parameter PATH

When the angel used Oracle, he found that the use of single and double quotation marks was different. Then he checked some information online and made some summary: Double quotation marks: when an object is created, the object name and field name

I checked the various versions of DB2. It is said that DB2 10 has come out and I don't know what the situation is, but it will definitely improve some functions, this article is my summary of the latest DB2 9.7 database version planning: DB2 Express-

The Data Pump was launched by Oracle from 10 GB and is used to replace the Data backup and restoration component of the traditional exp/imp tool. After the evolution and modification of several versions, Data Pump has become very mature and is

TNS-12541: TNS: no listenerThis error is summarized in three cases.1. The local listener is not enabled2. The network from the server network to the client is disconnected3. configuration problems in Hosts [Oracle @ his1 admin] $ tnsping crds3db2

1. recently, I used Oracle many years ago to import oracle dmp files. The technology I used was nearly forgotten over time. Now I mark it here, so as not to feel helpless when you encounter the same problem again. To import a dmp file, you need to

See Oracle BUG: error message about the alert of Rman backup.Symptom:During database backup, the alert Log prompts an error message and provides a trc file with detailed error information. Recommended reading: RMAN: Configure an archive log deletion

The mongoel DG technology uses redo log transmission and application to ensure consistent data on the standby end and the primary end. In this process, Redo Transport and Redo Apply are two core actions. Redo Transport transmits the Redo Log