Infrastructure at your Service

All posts by Daniel Westermann

Daniel Westermann
Senior Consultant and Technology Leader Open Infrastructure

Daniel Westermann has more than 10 years of experience in management, engineering and optimization of databases and infrastructures. He is specialized in Oracle Technologies as Performance Optimization and Tuning, Standardization, Backup & Recovery, in High Avaibility solutions as Oracle Real Application Clusters (RAC), Oracle Data Guard, Oracle Grid Infrastructure, as well as in storage technologies as Oracle Automatic Storage Management (ASM). Daniel Westermann is Oracle Certified Professional 10g/11g/12c. He is also a PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. Prior to dbi services, Daniel Westermann was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper & Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel Westermann holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery, telecommunications.
Daniel Westermann

You do use the Oracle Trace File Analyzer, don’t you?

By | Database Administration & Monitoring | One Comment

When you do not know what the Oracle Trace File Analyzer (tfa) is or you have heard about it but you don’t know what it is for then you probably should read this, especially when you are working in clustered Oracle environments. You know, Oracle loves to create plenty of trace files in various places (yes, this got much better with the Automatic Diagnostics Repository(ADR)). Now imagine you have a cluster and something goes wrong,…

 
Read More
Daniel Westermann

Replicating from Oracle to PostgreSQL with EDB Replication Server – 1 – A simple replication setup

By | Database Administration & Monitoring | 2 Comments

When you want to offload reporting stuff from Oracle to PostgreSQL there are several solutions you can go for. There most widely known probably are Oracle GoldenGate and SharePlex. EnterpriseDB has its own solution for this which is called EDB Replication Server. As soon as you have one subscription from EnterpriseDB this tool is included and can be used to offload from Oracle to PostgreSQL. Lets do a simple replication setup and see how it…

 
Read More
Daniel Westermann

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

By | Database Administration & Monitoring | No Comments

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. All rights reserved. Oracle Home : /disk00/app/12.1.0/grid_2_4 Central Inventory : /disk00/app/oraInventory from : /disk00/app/12.1.0/grid_2_4/oraInst.loc OPatch version : 12.2.0.1.8 OUI version : 12.1.0.2.0 Log file location : /disk00/app/12.1.0/grid_2_4/cfgtoollogs/opatch/opatch2017-05-17_15-44-20PM_1.log Lsinventory Output file location : /disk00/app/12.1.0/grid_2_4/cfgtoollogs/opatch/lsinv/lsinventory2017-05-17_15-44-20PM.txt ——————————————————————————– Local…

 
Read More
Daniel Westermann

PostgreSQL on a Pure Storage All Flash Array – Populating PostgreSQL

By | Database Administration & Monitoring | No Comments

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 to get a feeling on what is possible. In the last post we explained on how we did the setup for connecting a PostgreSQL server to the Pure Storage array. In this post we’ll actually…

 
Read More
Daniel Westermann

Testing new PostgreSQL features before alpha/beta/rc releases

By | Database Administration & Monitoring | No Comments

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 git to get the latest sources and build PostgreSQL from there. Everything which was committed will be available to test. Btw: A great way to stay up to date is to subscribe to the mailing list just referenced. You’ll get a…

 
Read More
Daniel Westermann

PostgreSQL on a Pure Storage All Flash Array – Preparations

By | Database Administration & Monitoring | No Comments

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 box and then pay the usual maintenance costs but you pay for a storage subscription which should keep your storage up to date all the time. The promise is that all the components of the array get replaced…

 
Read More
Daniel Westermann

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

By | Database Administration & Monitoring | 2 Comments

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 Control using the GoldenGate plugin you’ll have to install the JAGENT on the host where GoldenGate is running on and the documentation is not quite clear on what you have to do exactly (at least when…

 
Read More
Daniel Westermann

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

By | Database Administration & Monitoring | No Comments

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; BANNER —————————————————————- Oracle8i Enterprise Edition Release 8.1.7.4.0 – Production PL/SQL Release 8.1.7.4.0 – Production CORE 8.1.7.0.0 Production TNS for Solaris: Version 8.1.7.4.0 – Production NLSRTL Version 3.4.1.0.0 – Production  

 
Read More
Daniel Westermann

Save the date: Swiss PGDay 2017

By | Database Administration & Monitoring | No Comments

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 you can expect that to happen next week. What we can say already is that we will be there and that you can expect these sessions from dbi: How to migrate data from MongoDB to Postgres with ToroDB Elking…

 
Read More
Daniel Westermann

Does the wal segment size matter in PostgreSQL?

By | Database Administration & Monitoring | 4 Comments

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 wal segments is usually 16MB. Although 16MB seems very low you don’t need to worry about that in most of the cases, it just works fine. However there are cases where you might want to adjust this,…

 
Read More