All articles

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

Bringing up your customized PostgreSQL instance on Azure

The Azure cloud becomes more and more popular so I gave it try and started simple. The goal was to provision a VM, compiling and installing PostgreSQL and then connecting to the instance. There is also a fully(…)

Documentum – Silent Install – D2

In previous blogs, we installed in silent the Documentum binaries, a docbroker (+licence(s) if(…)

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

Documentum – Silent Install – Docbases/Repositories

In previous blogs, we installed in silent the Documentum binaries as well as a(…)

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

Backing up and restoring EDB containers in MiniShift/OpenShift

This blog refers to an older version of EDB's Postgres on Kubernetes offering that is no longer available. The last blogs in the series are already some days old: Setting up MiniShift,(…)