Oracle

Briefly describe the process of adding a node in the Oracle 10203 for Solaris SPARC Dual-node environment. Shared storage is already configured on a third node, which focuses on the configuration on the operating system and on Oracle. This article

Oracle data recovery from the recovery type, cast aside the specific files, the total can be divided into two major types of recovery, one is full recovery, one is not full recovery. In fact, once you are familiar with the Oracle architecture, there

In the serious study of goldengate enterprise-level operation, the focus is on the understanding of the Ogg several processes, combined with the understanding of the principle, in the whole experiment nearly two days, after repeated configuration

This weekend, when the Lord Bo was in his own Windows host, the Oracle database in the virtual machine was connected with Pl/sql, and there was a problem of approximately more than 10 seconds to log in to succeed. It's a strange phenomenon because I

There are several modes of locking in Oracle:0:none1:null Empty2:row-s line Sharing (RS): Shared table locks, Sub share3:row-x Line Exclusive (RX): For row modifications, sub Exclusive4:share shared Lock (S): Prevents other DML operations,

Oracle Flash-back technology , here are 4 kinds of flash back technology, the Oracle Flash-back technology to do a collation summary. Overview: The flash-back technology is part of Oracle's powerful database backup recovery mechanism, which

1. static sqlsql and dynamic SQLOracle compiled PL/SQL program block is divided into two kinds: first, the previous early binding, that is, the SQL statement was established during the program compilation, most of the compilation is this type, and

This error frequently occurs in Oracle data after an illegal shutdown: Exp-00056:oracle Error 1033 appears Ora-01033:oracle initialization or shutdown in progress User: Password: This is obviously the database does not have the means to start,

Oracle Trace Files Oracle trace files are grouped into three types, one is the background alarm log file, which records the activity of the background process during startup, shutdown, and running of the database, such as table space creation,

I've often seen people ask this question, I've set up multiple indexes on the same table, why does Oracle choose one at a time and not use multiple indexes at the same time? Generally speaking, the common access to the same table more than two

On the itpub saw someone raise this question, can use the data pump to export a query result. In fact, the data pump really has this function. Establish a simple test environment: sql> CREATE TABLE T1 2 (ID number, NAME VARCHAR2 (30)); Table

This article discusses how to use ado.net to access Oracle stored procedures (called SQL programming Blocks) and functions (a programming block that returns a single value). You can connect to an Oracle database using the following managed data

http://blog.csdn.net/baidu_24256693/article/details/44863935Because both Tomcat and Oracle are installed on the computer, 8080 of the ports are conflicting.There are many articles on the web that introduce the modification of the Tomcat port,

First, hardware requirements1. Memory and Sweap: Memory 2G (above), Sweap 2G (above)Memory: 1-2g 2-16g 16G or moresweap:1.5 Memory 1 time times memory 16GCheck: # grep Memtotal/proc/meminfo# grep Swaptotal/proc/meminfo2. Disk: 20G or moreCheck:

This article from: http://www.cnblogs.com/yangxia-test/p/3922775.htmlA. DownloadHttp://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html the following two Web site source this official download page Web.Win 32-bit operating

1, http://www.oracle.com/technetwork/topics/winsoft-085727.html download the corresponding version of the Instanctclinet Zip package 34M decompression after 92M To select a non-32-bit operating system, find http://www.oracle.com/technetwork/database/

Introduction to 1.OCR Disks The problem with forgetfulness is that each node has a copy of the configuration information and the configuration information of the modified node is not synchronized. Oracle's solution is to put this configuration

Almost forgot. In my last tutorial, I-tell-you-to-save Image/photo into Oracle database. But, there are another problem, how do I read and view it from Oracle database? Don ' t worry, it's very easy-to-do. Just follow these steps and you'll able to

The small partners who develop Oracle applications under the. NET Platform are sure to know that on the one hand, Oracle development and implementation is more complex than SQL Server to install Oracle clients (XCopy, extract related files

I encountered the following problems:1. The mount control file is abnormal. Replace the file and use pfile to mount the file.2. open reported the following error:Fri Jul 04 20:03:23 2014Alter database openBeginning crash recovery of 1