Database Administration & Monitoring

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

Oracle Linux 7 – How to audit changes to a trusted file such as /etc/passwd or /etc/shadow

Linux auditing is quite powerful and a lot of different use cases might be handled via the auditing framework. However, in this blog I would like to show you, how to audit changes on trusted files, like /etc/passwd or /etc/shadow.

PostgreSQL 10 Beta 1: Native Table Partitioning

By Mouhamadou Diaw The Beta 1 version PostgreSQL 10 is now released with lot of new features. One of the most popular is the native support of table partitioning. In this blog we are going to see how we(…)