ArKZoYd - The Online Community

Rolling forward physical standby databases using RMAN incremental backup

If having a data guard solution makes us confident with a straightforward backup solution in case of failure of the primary, it is required in the counterpart …

Handling high OLTP workload with RAC

Recently I had to face a high OLTP workload with RAC. This workload was a massive insert with high concurrency in one table. When used RAC, the performance …

Oracle Standard Edition and SQL Developer 4.1

SQL Developer is still on his way, growing every day ! It’s last free release is now 4.1.2 dated October 24th 2015. You can read what is the new stuff …

TNS-04414: File error when using dbca silent

When hurriedly using a set of silent database creation scripts on 11gR2 I stumbled several times across an error where dbca was failing after about 15s, and …

Managing partitions in Oracle Enterprise Linux 7

There a quite a few new changes in OEL 7 (and its twins CentOS7, RHEL7, etc.), one of them is the default filesystem is now xfs instead of ext4. Well, …

Use Oracle Preinstallation RPM on RHEL (non UEK)

With Oracle’s “Preinstallation RPM” you can easily prepare Oracle Database 12c and 11g installations on Oracle Linux. But these RPMs will not …

The Standard Edition 2 is available

The Standard Edition 2 is available! It is now official, the Oracle Database 12.1.0.2 Standard Edition 2 is available (it can be downloaded here: …

Flashing back Databases in a Dataguard Broker Configuration after a Switchover

This paper talks about the various technologies associated with the Oracle flashback database features in a dataguard broker configuration where multiple …

How to shrink your Oracle Virtualbox virtual machines

After playing a few time with a virtual machine, installing and un-installing Oracle software on Oracle VirtualBox, I realised that the vdi disk files of some …