Oracle Team

A tribute to Natural Join

By Franck Pachot . I know that lot of people are against the ANSI join syntax in Oracle. And this goes beyond the limits when talking about NATURAL JOIN. But I like them and use them quite often. Why(…)

The size of Oracle Home: from 9GB to 600MB

By Franck Pachot . This is research only and totally unsupported. When building docker images to run Oracle Database in a container, we try to get the smallest image possible. One way is to remove some subdirectories that we know(…)

Oracle 18c DataGuard : Rman RECOVER STANDBY DATABASE

By Mouhamadou Diaw With Oracle Database 18c, we can now refresh a standby database over the network using one RMAN command, RECOVER STANDBY DATABASE. The RECOVER STANDBY DATABASE command restarts the standby instance, refreshes the control file from the primary(…)

Oracle Database on OpenShift

By Franck Pachot . In a previous post I described the setup of MiniShift on my laptop in order to run OpenShift for test purpose. I even pulled the Oracle Database image from the Docker Store.

Upgrade EM 13.2 to EM 13.3

As the last Enterprise Manager Cloud Control 13.3 is out since a few days, I decided to test the upgrade procedure from the Enterprise Manager Cloud Control 13.2 You have to follow some pre-requisites: First you copy the emkey :(…)

Licensable targets and Management Packs with EM13c

When you add a new target in Enterprise Manager 13c , the management packs are enabled by default. This could be a problem in case of a LMS control, and to avoid any problem, you have to  manually disable those(…)

ORACLE_HOME with symbolic link and postupgrade_fixups

By Franck Pachot . Here is a quick post you may google into if you got the following error when running postupgrade_fixups.sql after an upgrade: ERROR - Cannot open the preupgrade_messages.properties file from the directory object preupgrade_dir DECLARE * ERROR(…)

18c runInstaller -silent

By Franck Pachot . You find two different 'runInstaller' under an Oracle Home. The old one, the Oracle Universal Installer, in $ORACLE_HOME/oui/bin. And the new one, in $ORACLE_HOME directly. They have the same name but are completely different. The old(…)

TRANSPORT_CONNECT_TIMEOUT and RETRY_COUNT

By Franck Pachot . When you have a Data Guard configuration, you want the application to connect to the right server, where the primary is, without taking too much time. The default TCP timeout is 1 minute which is too(…)

ATP vs ADW – the Autonomous Database lockdown profiles

By Franck Pachot . The Oracle database has always distinguished two types of workloads: transactional (OLTP) and datawarehouse (VLDB, DWH, DSS, BI, analytics). There is the same idea in the managed Oracle Cloud with two autonomous database services.