Oracle 11g

Resource FAILOVER dans Grid Infrastructure

Dans le cadre d’un cluster Oracle Grid Infrastructure 11g R2 utilisé pour gérer des bases de données en mode FAILOVER, j’ai été amené à me pencher sur l’algorithme de basculement d’une ressource et des paramètres le régissant. On trouve dans(…)

Scripts to duplicate an Oracle database virtual machine: step one

In my last posting of November 9, 2012, Manage templates manually with Oracle Virtual Box, I have presented a solution to duplicate virtual machines using Oracle/ Virtual Box. I did not show the scripts in this first publication, but(…)

Unable to resize tmpfs on Oracle Enterprise Linux 6 versions

I recently helped to create a lab dedicated to a training about Oracle backup and recovery, with Oracle 11g databases. While creating several databases on an Oracle Enterprise Linux 6.1, I wanted to resize the tmpfs to allocate more memory(…)

“ORA-01665: control file is not a standby control file”: what can I do?

You have certainly also received this error once in you Oracle DBA career: “ORA-01665: control file is not a standby control file” while trying to create a standby database with RMAN through a full database backup. In fact, the feature(…)

Adding new tables to an existing Oracle GoldenGate replication

Once a replication environment is set up, it’s rarely forever. Adding tables to an Oracle GoldenGate replication group with minimal impact to the current replication is quite a difficult operation. This posting should help you with this task. In the example below,(…)

ORA-03113 caused by Database Vault Rule Sets

Database Vault solution allows to create rules that manage access to database. Among these rules there is what is called in Database Vault “Rule Sets”. These logic components are written as PL/SQL(…)

Replace a voting disk is so easy with Grid Infrastructure 11.2 & ASM!

For a few day we had a quick request at a customer which was to replace a voting disk in an ASM disk group. The current ASM disk group (redundancy normal) had 3 disks : two located in one data(…)

Protecting an Oracle database from block corruption

Data can be corrupted in different ways, for example an I/O issue when reading data from the storage or a memory issue when updating data. The db_block_checking parameter allows to change the behavior of an Oracle database concerning block checking.

HA with Oracle Fusion Middleware Forms & Reports 11g R2

In this post, I will explain how to install Oracle Fusion Middleware Forms and Reports 11g R2 for a high availability architecture on a Windows platform. For the Linux platform, it’s approximately the same even though the node manager is(…)

Configuration of tmpfs on SLES 11 for Oracle 11.2 and AMM

This post presents the configuration of the tmpfs filesystem size on SLES 11 in order to use the Oracle 11.2 Automatic Memory Management feature (AMM) through the Oracle instance parameter memory_target.