This article presents some basic techniques for creating Windows batch files and UNIX/Linux shell scripts that connect to SQL*Plus and RMAN. Continue reading
Some of the typical naming conventions used for objects in Designer and the database. Nothing is carved in stone, but these are the sort of rules I follow: Continue reading
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
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 installing GlassFish 3.1 on CentOS or RHEL.
We’ll also see how to run GlassFish as a service, how to access the Admin Console, and how to run GlassFish under a minimally privileged user.
GlassFish 3.1 is the latest release and is available as GlassFish Server Open Source Edition 3.1 (free) and Oracle GlassFish Server 3.1 (supported and requires paid subscription). 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
Clonedb is a new Direct NFS (DNFS) feature introduced in the 184.108.40.206 database patchset. Rather than using the traditional RMAN database duplication, clonedb uses dNFS technology to instantly Continue reading
RMAN Continue reading