Database Administration & Monitoring

Instance fails to start automatically

Recently at a customer I was confronted with a problem of restarting the Oracle Database 12c automatically on a Windows Server 2008 R2 x64. I installed Oracle 12.1.0.1.0 with a user of service in a domain who has member(…)

Cloud Control 12c on your laptop

By Franck Pachot . Today every DBA should have a lab on his laptop. This is where I reproduce most of cases before opening a SR, or to investigate something, to demo, to learn new features, or to prepare an(…)

Interested in a deep dive of logical replication?

By Franck Pachot . It's next week at #DOAG2015 Interested in a deep dive of logical replication? Let's try it. The best way to learn is to try it and this is the idea of #RepAttack where you can quickly(…)

set “_rowsets_enabled”=false

By Franck Pachot . This 12c 'wrong results' issue is thoroughly described by Mike Dietrich (https://blogs.oracle.com/UPGRADE/entry/switch_off_rowsets_enabled_in) and I've nothing to add. This blog post is there to be used as a reference for the comment in(…)

Oracle DBA Essentials Workshop – Patchset 11.2.0.4 Available

We have Upgrade our Environment Oracle DBA Essentials Workshop of release 11.2.0.3 to 11.2.0.4. From now on, you can operates the various subjects on the new release. In this article, I present you the procedure to be followed for(…)

GoldenGate – Error during a register extract

This week, I tried to install a GoldenGate environment to make some test. The installation was good and simple. Firstly I tested the normal capture mode and all worked correctly. In a second time, I wanted try to use the(…)

AWR when ASH CPU >> DB CPU

By Franck Pachot . I'll present How to read an AWR report next month at UKOUG TECH15 and the first recommendation after checking Average Active Sessions is to verify that we are not in a CPU starvation situation. Here is(…)

RMAN channels in RAC

By Franck Pachot . When you want to minimize the backup or restore duration, you can parallelize RMAN operations by allocating multiple channels. If you are in cluster, you can open channels from several nodes. Let's see why, how, and(…)

Dbvisit replicate allows DDL replication even when source and destination have different structure

By Franck Pachot . I've tested a little thing for a customer, and as usual I spool the result into a blog post in case it helps others. Not all replication software - at least in their current version -(…)

IBM Bluemix Database Cloud Service – My first trial

By Franck Pachot . Remember my first try of Oracle cloud when Larry Ellison announced the Cloud in june? This week at OOW15 Larry Ellison announced that IBM is not a competitor anymore for them, then(…)