Database Administration & Monitoring Oracle OGG JAGENT 12.2 installation for GoldenGate monitoring using the Cloud Control plugin 03.05.2017 by Daniel Westermann 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(…)
Database Administration & Monitoring A new OGG challenge: Migrate an Oracle 8.1.7.4 instance to 10.2.0.5 27.04.2017 by Daniel Westermann 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;(…)
Database Administration & Monitoring Migrating from oracle to postgresql with ora2pg 26.04.2017 by Oracle Team By Mouhamadou Diaw PostgreSQL is one of the most used Rdbms. In this blog we are going to talk about migrating from oracle to postgresql using ora2pg. A previous blog about this topic can be found(…)
Database Administration & Monitoring Save the date: Swiss PGDay 2017 26.04.2017 by Daniel Westermann 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(…)
Database Administration & Monitoring Oracle 12.2 tables, indexes new features 26.04.2017 by Oracle Team The Oracle 12.2.0.1 version has some interesting new features concerning tables or indexes. The first new feature is about the online table move. In 12.2 version Oracle offers now the possibility to move non-partitioned tables without blocking any DML operations. To(…)
Database Administration & Monitoring Does the wal segment size matter in PostgreSQL? 25.04.2017 by Daniel Westermann 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(…)
Database Administration & Monitoring SQL Server 2017 AlwaysOn AGs and new read-scale architectures 21.04.2017 by Microsoft Team As you probably know Microsoft announced an official name for SQL Server vNext during the last Microsoft Data Amp event on April 19 2017. It becomes officially SQL Serve 2017. In my first(…)
Database Administration & Monitoring OGG: Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 18.04.2017 by Daniel Westermann 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(…)
Database Administration & Monitoring Welcome to M|17, part 2 17.04.2017 by Open source Team Welcome to the second day of the MariaDB’s first user conference On the 12th, at 09:00, started the first-ever experimental MariaDB Associate certification exam and I was glad to be among the first and participate(…)
Database Administration & Monitoring In-core logical replication will hit PostgreSQL 10 13.04.2017 by Daniel Westermann 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(…)