All articles

Querying the Oracle Management Repository

The Enterprise Manager Cloud Control 12c is an amazing tool allowing the DBA to display a lot of informations from the console . But there are also a lot of repository views that may be consulted by the DBA to(…)

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

Trying AppDynamix – monitoring application from user to database

By Franck Pachot . I like to come upon new monitoring software that help to go quickly from user response time to root cause. And I love applications that can be installed easily and at which I can give a(…)

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

Real life audience vs. Twitter audience

By Franck Pachot . I was looking at twitter analytics showing my top tweets in November and that puzzled me because tweets with the most 'impressions' and 'engagement' are related to events that had low audience in real. Any comment(…)

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

Oracle Data Integrator – The EL-T tool from Oracle

Oracle Data Integrator is the ETL tool that Oracle has developed to enter into the world of Business Intelligence. Taking advantage of its incredible experience in database managing, Oracle has created an ETL tool that is flexible to use, powerful(…)