Oracle

Oracle 11g RAC, the oc4j and GSD services are found to be in the offline state, which is the Oracle 11g RAC default case. Even so, the use of the database is not affected, because oc4j is a resource for WLM, WLM is available in 11.2.0.2. GSD is an

Index is a powerful weapon to improve database query performance. No index, just like the library without book tags, find a book they want to book than Heaven is difficult. However, in the process of using the index, especially in the case of batch

This article will introduce some of the functions that are often used in everyday life, or that are very interesting, though they are rarely used. It is divided into two kinds of introductions, namely: Famous letters-functions that are often

A brief introduction of oracle| and tree The Developer 6.0 version provides the concept of hierarchy tree (hierarchy trees), the Htree control is very convenient, only need a small amount of programming to achieve the purpose of the display

Nocatalog way: With control file as a catalog, every backup to the controlling files to write a lot of backup information, control files will have more and more backup information, that is, Rman backup information written in the local control file

Os:redhat as 4 Oracle:oracle10gr2 The customer presents a request to demonstrate the recovery of RAC DB to single-instance, and their purpose is to verify the backup effectiveness of the production environment Here are the ideas and the main

Background:A colleague mistakenly deletes the online data. So you need to recover the data from the backup.Real house leakage of the rain overnight, the ship was late and the wind. The disk blocks that were backed up in the first two days are now

ScenarioThe columns in the original table are defined as VARCHAR2 types, and it is well known that the maximum support length for the VARCHAR2 type is 4000. Assume that because of business needs. To convert this column to the CLOB type, it is not

Oracle Data Pump (IMPDP/EXPDP) Import and Export summaryOracle Data Pump Import and export is one of the basic techniques commonly used in daily work, it is more efficient than traditional logic import and export, which is more suitable for the

*sql optimization based on ORACLE11GR2 reading notes * Third, cursor in OracleThe cursor in Oracle is a vector of SQL parsing and execution in an Oracle database and is a data structure for C (Oracle is written in C).There are two types of cursor in

Installed Ubuntu 12.04 64bit, want to install Oracle 11GR2 on the above, find a lot of documents on the Internet did not succeed, and finally fully reference the Mordicusetcubitus article.Key points for a successful installation: Install additional

Format reload system, only to think of Oracle 10g database did not do backup, began to think very troublesome, did not expect the database recovery is quite smoothRecovery method:1, the original database file backup,

Summary : Description: Linux server operating system: CentOS 5.8 32-bit (note: Please separate partition/data for installation of Oracle database) Linux Server IP address: 192.168.21.150 Oracle database version: Linux_11gr2_database wind

Objective:Morning to work, development to inform the database connection is not, say is reported memory overflow, check memory free space is really insufficient, then will high memory process end, but after the end is not connected, restart the

This article is not ready to introduce all of the Oracle functions, in the current situation, I do not have this time, need to learn too much, to spend most of the time on learning to use the technical aspects:), so if you are ready to learn all the

Oracle Cluster Concepts and principles (ii) Overview: write down the original intent and motivation of this document, derived from the Oracle Basic operating Manual of the previous article. The Oracle Basic Operations Manual is a summary

Oracle Data Integrator 12CR1 (12.1.3.0.0) installation process download installation filesOracle Data IntegratorCR1 (12.1.3.0.0) Http://download.oracle.com/otn/nt/middleware/12c/121300/fmw_12.1.3.0.0_odi_Disk1_1of1.zip Oracle Fusion Middleware

This article will introduce some interesting functions that trisi often uses in daily life, or which are rarely used. There are two types of introduction: Famous functions-frequently used functions Non-famous functions-although rarely used, they are

64-bit Windows 8/7 32-bit PLSQL connection 64-bit Oracle11g64-bit Windows 8/7 32-bit PL/SQL connection 64-bit Oracle 11gNote: Oracle's oci. dll is 64-bit after installation, while 32-bit application PL/SQL Developer cannot loadSolutionStep 1:

O & M DBAs reflect database storage faults, resulting in the loss of data files in two tablespaces of redo undo, and the database cannot be started open.A group's ebs system stores redo and undo on raid 0 due to insufficient disk space, and the