Blog

Setup Oracle Database Link to MySQL

Johannes Ahrends  10

This Blog describes how to set up a Database link from an Oracle Database to a MySQL Database. As an (…)

read more

Who is SYSTEM?

Johannes Ahrends

In many companies the DBAs – and not only them – are working with the user “SYSTEM“. Is that wrong? (…)

read more

Are Database Templates useful?

Johannes Ahrends

If you create a database using dbca (Database Configuration Assistant) step 3 allows you to select one of two templates (…)

read more

Read-Only Oracle Home

Johannes Ahrends  1

Since Oracle 18 (with some restrictions) it’s possible to set the Oracle software installation directory <ORACLE_HOME> into read only.  And (…)

read more

Standard Edition High Availability

Johannes Ahrends  4

On May 7th Oracle released “Standard Edition High Availability” (SEHA). There has been a high availability gap so far because (…)

read more

Oracle 12.2.0.1 Support Extended

Johannes Ahrends

April 15th was patch day again. New security patches, patch sets, release update and whatever they are named became available. (…)

read more

Data loss with Database Services

Johannes Ahrends

In one of my projects we had a disaster most recently: An application was connected to two databases simultaneously and (…)

read more

Multitenant for Everybody

Johannes Ahrends

At the Openworld conference 2019 Oracle announced that Oracle 19c will allow up to three pluggable database per database on (…)

read more

Cloning with RMAN is easy!

Johannes Ahrends

In this blog I will show you how to use an RMAN backup to create a database clone. In my (…)

read more

Recovery with RMAN is easy!

Johannes Ahrends

In this blog I will show you how easy it is to restore a corrupted tablespace or datafile using RMAN. (…)

read more

What can CarajanDB do for you?