All articles

Migrating the Oracle 12cR1 sample schemas to PostgreSQL Plus Advanced Server 9.4

This post takes a look on how to migrate the Oracle 12cR1 sample schemas to PPAS 9.4 (PostgreSQL Plus Advanced Server 9.4). I’ll not dig into how to install PPAS as this was described in detail(…)

With Oracle Goldengate take care of additional column creation on the replicated database

This week I worked on a GoldenGate 12.1.2.1.10 POC setup and was facing an issue which for me is a serious drawback of the Oracle GoldenGate product.If you want to create additional columns on the target database online in a(…)

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

SQL Server 2016 CTP3.0: Stretch Database enhancements

Some months ago, my colleague Nathan explained you the bases of the new Stretch Database functionality via two blogs here and here. With the new SQL Server 2016 CTP 3.0, Stretch Database now includes new features and(…)

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