Install Oracle 11g Release 1 on RHEL 5
This is a quick step by step guide, which I usually use to install Oracle 11g Release 1 on Red Hat Enterprise Linux 5.
Upgrade Oracle 10g Release 2 to Oracle 11g Release 2
This article is a step by step guide to upgrade Oracle 10g Release 2 (10.2.0.4) to 11g Release 2 (220.127.116.11) on Red Hat Enterprise Linux 5.4.
Oracle 11g Release 2 Pre Upgrade tool utlu112i sql
This article shows what to do for different warnings and cautions reported by Oracle 11g Release 2 Pre-Upgrade tool that is utlu112i.sql during 11gR2 upgrade.
Change or switch undo tablespace in Oracle database
A frequently asked question on different Oracle forums is; How do I change the UNDO tablespace for my database and drop the old one? This post shows how.
Oracle 11g DBMS_FLASHBACK TRANSACTION_BACKOUT
This article shows how to perform a Flashback Transaction manually using DBMS_FLASHBACK.TRANSACTION_BACKOUT in the absense of Oracle Enterprise Manager.
Oracle 11g Flashback Transaction in OEM LogMiner Interface
Oracle 11g introduces a new feature called Flashback Transaction that can be used to rollback a whole transaction. This article explains how this works.
Upgrade Oracle 10g Release 2 from 10201 to 10204
This post demonstrates a step by step guide to apply oracle patchset 10.2.0.4 (patch number 6810189) on 10.2.0.1 database hosted on 32-bit RHEL 5.4.
Oracle 11g Using LogMiner to analyze redo log files
Oracle 11g LogMiner has been incorporated into Oracle Enterprise Manager to analyze the redo log files. This article shows how it works with example.
TDE in Oracle 11g and Transparent Tablespace Encryption
Oracle 11g introduced transparent tablespace encryption feature in Oracle advanced security. This post explains how it works with its performance improvements.
Oracle 10g Transparent Data Encryption examples
Oracle 10g transparent data encryption (TDE) is a powerful feature to hide sensitive data. This post shows how to use TDE along with performance considerations.