The purpose of this article is to provide a brief introduction to virtualization, without getting too bogged down in technical detail, or vendor-specific politics.
A deadlock occurs when two or more session are waiting for data locked by each other, resulting in all the sessions being blocked. Oracle automatically detects and resolves deadlocks by rolling back the statement associated with the transaction that detects the deadlock. Typically, deadlocks are caused by poorly implemented locking in application code. This article shows the steps necessary to identify the offending application code when a deadlock is detected. Continue reading
Storage vendors offer endless amounts of performance data on their products, but the information doesn’t necessarily reflect how the storage will perform when it is used by an Oracle database. This article outlines two easy ways to test the performance of your storage systems using utilities provided by Oracle. Continue reading
RAID is an acronym for Redundant Arrays of Inexpensive Disks. These provide a mechanism for load balancing and securing your data across
multiple disks. In this article I’ll give a brief explanation of the most commonly used RAID levels and how they should be used with Oracle. Continue reading
This post will cover basic installation and configuration of Oracle 11g Express Edition (XE) on CentOS. We will also take a quick look at configuring Application Express (APEX) for 11g XE.
Basic installation is straight forward.
If you just want to get up and running, you can just do steps 1 to 4 below (and 10 and 11 for Apex). The remaining steps (5 to 9) cover basic backup, recovery, and performance configuration. Continue reading
This article describes the installation of Oracle Database 11g release 2 (11.2 64-bit) RAC on Linux (Oracle Enterprise Linux 5 64-bit) using VMware Server 2 with no additional shared disk devices.
Diego E. Aguirre, octubre 2008
Esta instalación fue realizada en el siguiente escenario:
2 Dominios físicos de two servidores Sun Fire 25K, cada uno con: