Database Administration & Monitoring

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

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

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

Catching interface state changes with Network Manager

Sometimes it is required that you can react on state changes of your network interfaces. Maybe you want to get notified by mail or you want to execute a script that does something in case an event is trapped. As(…)

When does PostgreSQL create the table and index files on disk?

A question that pops up from time to time is: When we create a table or an index in PostgreSQL are the files on disk created immediately or is this something that happens when the first row is inserted? The(…)

Upgrade Oracle Grid Infrastructure from 12.1.0.2.0 to 12.2.0.1.0

The following blog will provide the necessary steps to upgrade the Grid Infrastructure from 12.1 to 12.2, for a Standalone Server. One of the new features of GI 12.2 is the usage of the AFD (Oracle ASMFD Filter Driver).

Patching ODA lite to 12.2.1.4.0

Here is how to apply the latest patch for your ODA. As usual the Oracle documentation is not 100% accurate. I applied this patch on 2 ODAs X7-2M previously deployed in 12.2.1.2.0, no intermediate patch was needed. 1) Download the(…)

ODA, network interface and configure-firstnet

Deploying new Bare Metal ODA X7-2S or 2M, I have been curious how configure-firstnet would interact with the fiber and copper ethernet network interfaces. Reading documentation on the web, I could not clearly understand if it is mandatory to have(…)

How to shrink tables with on commit materialized views

Usually it is not possible to shrink tables which are used by on commit materialized views. The result is an ORA-10652 “Object has on-commit materialized views” error, for which in action section nothing is suggested. There is a workaround for(…)

Running SQL Server containers on K8s Docker for Windows CE stable channel

The release of Docker for Windows Stable version 18.06..0-ce-win70 comes with some great new features I looked for a while including the K8s support! That’s a pretty good news because this support has existed on Edge channel since(…)