Database Administration & Monitoring The scripts of my DOAG 2015 session: Automated GI/RAC staging with Cobbler and VirtualBox 18.11.2015 by Daniel Westermann I promised to upload the scripts of my session to our blog. So, here they are: create_12102_gi_rac_project.sh: This one creates the 12.1.0.2 GI/RAC project on the cobbler server finish_ora_12102_gi_rac_project.sh: This one does the configuration of the GI/RAC on(…)
Database Administration & Monitoring, Oracle In-Memory synchronous population with hidden parameters 15.11.2015 by Oracle Team By Franck Pachot . By default, In-Memory Column Store population is done in background, asynchronously. There are two hidden parameters that can change this behavior, let's see how it works.
Database Administration & Monitoring Instance fails to start automatically 13.11.2015 by Oracle Team 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(…)
Database Administration & Monitoring, Oracle Cloud Control 12c on your laptop 13.11.2015 by Oracle Team 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(…)
Database Administration & Monitoring, Oracle Interested in a deep dive of logical replication? 11.11.2015 by Oracle Team 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(…)
Database Administration & Monitoring, Oracle set “_rowsets_enabled”=false 11.11.2015 by Oracle Team 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(…)
Database Administration & Monitoring Oracle DBA Essentials Workshop – Patchset 11.2.0.4 Available 10.11.2015 by Oracle Team 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(…)
Database Administration & Monitoring GoldenGate – Error during a register extract 06.11.2015 by Oracle Team 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(…)
Database Administration & Monitoring, Oracle AWR when ASH CPU >> DB CPU 05.11.2015 by Oracle Team 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(…)
Database Administration & Monitoring, Oracle RMAN channels in RAC 05.11.2015 by Oracle Team 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(…)