Daniel Westermann

opatchauto and “java.lang.UnsatisfiedLinkError”, Topology creation failed when applying 12.1.0.2.170418 PSU

Yesterday I had fun with Opatch again. We wanted to apply the latest PSU (12.1.0.2.170418) on top of a 12.1.0.2 GI without any patches applied: xxxxx@xxxxx:/disk00/app/12.1.0/grid_2_4/diagnostics/ [+ASM2] opatch lsinv Oracle Interim Patch Installer version 12.2.0.1.8 Copyright (c) 2017, Oracle Corporation.

PostgreSQL on a Pure Storage All Flash Array – Populating PostgreSQL

Just be clear this is not a performance test as we had to connect the Pure Storage box through 1GB/s interfaces. Basically it is more about how you can interact with the storage system (command line & web interface) and(…)

Testing new PostgreSQL features before alpha/beta/rc releases

A long time ago I blogged on how you can use the PostgreSQL development snapshots to test new PostgreSQL features before alpha/beta/rc releases are officially released. Another way to do this is to use(…)

PostgreSQL on a Pure Storage All Flash Array – Preparations

Yesterday we got a Pure Storage All Flash Array for testing. As the name implies this is all about Flash storage. What makes Pure Storage different from other vendors is that you don't buy just a storage(…)

Oracle OGG JAGENT 12.2 installation for GoldenGate monitoring using the Cloud Control plugin

This post is mainly for self documentation as I have to search my old notes every time I want to do this (I am faster by searching on our blog :) ): If you want to monitor GoldenGate with Cloud(…)

A new OGG challenge: Migrate an Oracle 8.1.7.4 instance to 10.2.0.5

Yes, these beasts still exist in production: [/u01/appl/ora817]$ sqlplus /nolog SQL*Plus: Release 8.1.7.0.0 - Production on Thu Apr 27 09:54:20 2017 (c) Copyright 2000 Oracle Corporation. All rights reserved. SQL> connect / as sysdba Connected. SQL> select * from v$version;(…)

Save the date: Swiss PGDay 2017

The 30th of June is not too far away and if you want to learn more about the “World’s most advanced open source database” you should register soon. The sessions are not yet officially announced but(…)

Does the wal segment size matter in PostgreSQL?

In PostgreSQL you configure the size of the wal (write ahead log) segments when you compile from source. If you use an installer or if you use the packages provided by your OS distribution the size of the(…)

OGG: Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2

Another GoldenGate 12.2 one: Some days ago I had this in the GoldenGate error log: 2017-04-12 14:56:08 WARNING OGG-02901 Oracle GoldenGate Capture for Oracle, extimch.prm: Replication of UDT and ANYDATA from redo logs is not supported with the(…)

Listing the extensions available in PostgreSQL

When you follow this blog regularly you probably already now that PostgreSQL is highly extensible. There are quite a couple of extension which ship by default and are ready to use. How can you know what is(…)