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

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 | No 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
Daniel Westermann

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

By | Database Administration & Monitoring | No Comments

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 Oracle compatible parameter setting. Using fetch instead. 2017-04-12 14:56:08 ERROR OGG-02912 Oracle GoldenGate Capture for Oracle, extimch.prm: Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later. Seemed pretty obvious that…

 
Read More
Daniel Westermann

In-core logical replication will hit PostgreSQL 10

By | Database Administration & Monitoring | No Comments

Finally in PostgreSQL 10 (expected to be released this September) a long awaited feature will probably appear: In-core logical replication. PostgreSQL supports physical replication since version 9.0 and now the next step happened with the implementation of logical replication. This will be a major help in upgrading PostgreSQL instances from one version to another with no (or almost no) downtime. In addition this can be used to consolidate data from various instances into one instance…

 
Read More
Daniel Westermann

8 + 1 = 9, yes, true, but …

By | Database Administration & Monitoring | 2 Comments

Btw: If you really would do that (the screen shot is from 12.1.0.2): SQL> alter system set sga_target=210m scope=spfile; System altered. SQL> alter system set sga_max_size=210m scope=spfile; System altered. SQL> alter system set pga_aggregate_target=16m scope=spfile; System altered. SQL> select banner from v$version; BANNER ——————————————————————————– Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production PL/SQL Release 12.1.0.2.0 – Production CORE 12.1.0.2.0 Production TNS for Linux: Version 12.1.0.2.0 – Production NLSRTL Version 12.1.0.2.0 – Production SQL>…

 
Read More
Daniel Westermann

Failed to set logmining server parameter MAX_SGA_SIZE to value XX

By | Database Administration & Monitoring | No Comments

When you see something like this in your GoldenGate error log when you try to start an extract: 2017-04-12 14:51:38 ERROR OGG-02039 Oracle GoldenGate Capture for Oracle, extxxx.prm: Failed to set logmining server parameter MAX_SGA_SIZE to value 24. 2017-04-12 14:51:38 ERROR OGG-02042 Oracle GoldenGate Capture for Oracle, extxxx.prm: OCI Error 23605. 2017-04-12 14:51:38 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, extxxx.prm: PROCESS ABENDING. … then you should increase the streams_pool_size (maybe you need to increase…

 
Read More
Daniel Westermann

Can I do it with PostgreSQL? – 14 – optimizer hints

By | Database Administration & Monitoring | No Comments

This is a question that comes up quite often: How can I use optimizer hints in PostgreSQL as I can do it in Oracle? Well, you cant, and the reasons are this: Poor application code maintainability: hints in queries require massive refactoring. Interference with upgrades: today’s helpful hints become anti-performance after an upgrade. Encouraging bad DBA habits slap a hint on instead of figuring out the real issue. Does not scale with data size: the…

 
Read More