Database Administration & Monitoring

How to rename listener target in EM Cloud 12c ?

Sometimes it is necessary to rename targets in Enterprise Manager Cloud Control 12c. In my case I have listener targets discovered by EM12c with the hostname at the end of the target name: TESTDBA_LSN_dbserver1 As I work in a Veritas(…)

Upgrading the Grid Infrastructure from 12.1.0.1 to 12.1.0.2 on the command line

A lot of people use the graphical way to upgrade Oracle software from one version to another. While there is nothing to say against that the same can be done without any graphical tools. This post outlines the steps to(…)

Oracle Compliance Standard

In Enterprise Manager 12c, using the compliance standard results might be a good solution for DBA’s to detect security incoherences (for example a lambda user who has the sysdba role …) for their various targets. From the 12.1.0.3 version, a(…)

The scripts of my DOAG 2015 session: Automated GI/RAC staging with Cobbler and VirtualBox

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(…)

In-Memory synchronous population with hidden parameters

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.

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(…)