All articles

OUD – Oracle Unified Directory 11.1.2.3, How to change the Java version of OUD 11.1.2.3 with Weblogic and ODSM

By William Sescu In this blog, I would like to show how to change the Java version used by OUD and WebLogic, in case you use the ODSM. The OUD (Oracle Unified Directory) is written purely in Java, not like(…)

12cR2 needs to connect with password for Cross-PDB DML

By Franck Pachot . In a previous post, I explained that Cross-PDB DML, executing an update/delete/insert with the CONTAINERS() clause, seems to be implemented with implicit database links. Connecting through a database link requires a password(…)

Getting Solaris 8 x86 up and running in Virtual Box

As this project is going to start soon and I learned that there is a x86 version of Solaris 8, today I thought it would be great if I can get a test setup up and(…)

Oracle 12cR2 – ORA-44777 – Pluggable database service cannot be started

By William Sescu Have you ever experienced the following error? SQL> alter pluggable database pdb2 open; alter pluggable database pdb2 open * ERROR at line 1: ORA-44304: service does not exist ORA-44777: Pluggable database service cannot be started. The error(…)

PostgreSQL 10 Beta 1: Logical replication

By Mouhamadou Diaw In a previous blog we talked about partition in postgreSQL 10 Beta 1. In this article we will talk about another new feature logical replication. Yes in postgreSQL 10, logical replication is(…)

History of Upgrading 9 Tb PostgreSQL database

Mouhamadou Diaw In this blog I am going share a history of PostgreSQL migration and upgrade from 9.2 to 9.6. Let me first explain the context We have a PostgreSQL environment with following characteristics. Note that real database name,(…)

You do use the Oracle Trace File Analyzer, don’t you?

When you do not know what the Oracle Trace File Analyzer (tfa) is or you have heard about it but you don't know what it is for then you probably should read this, especially when you are working in clustered(…)

SQL Server 2017 on Linux and some log shipping scenarios

In this blog let’s talk a little bit about the log-shipping feature from the SQL Server CTP 2.0. First of all, let’s say that as a Windows version, it is possible to create our own solution based on Linux (and(…)

Workaround for bug 19566227/20563128 doing Cross Platform Migration (MOS Note 1389592.1)

In a project I have to move an Oracle 11.2.0.4-DB (around 7TB in size) from Sparc Solaris (called Source in the remainder of this Blog) to Linux x86-64 (called Target in the remainder of the Blog). I.e. a platform migration(…)

Replicating from Oracle to PostgreSQL with EDB Replication Server – 1 – A simple replication setup

When you want to offload reporting stuff from Oracle to PostgreSQL there are several solutions you can go for. There most widely known probably are Oracle GoldenGate and SharePlex. EnterpriseDB has its own solution for this(…)