Oracle Team

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.

Using Oratcptest

By Mouhamadou Diaw Last day I did some tests with Oratcptest. This a command line tool which can be used to measure network bandwidth and network latency between client and server. In this blog I am going to show(…)

MERGE JOIN CARTESIAN: a join method or a join type?

By Franck Pachot . I'll present about join methods at POUG and DOAG. I'll show how the different join methods work in order to better understand them. The idea is to show Nested Loops, Hash Join, Sort Merge Join, Merge(…)