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

Oracle upgrades from 10g to 11g detailed stepsold Database version: 10.2.0.4Database new version: 11.2.0.2OS Version: Solaris 10Reference Documentation:Complete Checklist for Manual upgrades to 11GR2 [ID 837570.1]Part I-Installing 11GR2 softwareHere

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

With the extension of the new version of the database ASM will certainly be more and more attention, the recent preparation of the system to learn the ASM, in case of unexpected needs, this is the ASM in-depth study of the first, reference: DD copy

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

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

*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

Because of the recent international go to Oracle on MySQL, this inevitably involves time zone and timestamp issues. Do an experiment and summarize.OracleFirst look at the definition of Oracle Concepts for timestamp:The TIMESTAMP data type is an

Removeipc=yes RHEL7.2 will crash the Oracle ASM instance and Oracle database instance, and the problem will also be in the use of the shared Memory Segment (SHM) or semaphores (SEM) Occurs in the application.From:Alert:setting Removeipc=yes on

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,

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 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

Document directory 2. 1. Export data from the table to a file (using trusted connections) 2. export data from the table to a file (using Hybrid Authentication) 2. 3. Import the data in the file to the table 0. References: SQL Server BCP usage

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