All articles

Getting started with Greenplum – 4 – Backup & Restore – databases

This is the fourth part of the Greenplum blog series, the previous ones are here: Getting started with Greenplum – 1 – Installation, Getting started with Greenplum – 2 – Initializing and(…)

Getting started with Greenplum – 3 – Behind the scenes

If you followed part 1 and part 2 of this little blog series you now have a running Greenplum system. There is one coordinator host and there are two segment hosts. In(…)

Migration from Non-CDB to Multitenant : CDB is using local undo, but no undo tablespace found in the PDB

During a past migration test from on-premises to ExaCC, I faced a pdb violation, stating, CDB is using local undo, but no undo tablespace found in the PDB, after having run noncdb_to_pdb.sql script. Explanation The problem comes from the fact(…)

Migration from Non-CDB to Multitenant : Wallet Key Needed

I have been recently able to make several migration tests from On-Premises to Exadata, and during some of my tests I faced a PDB_PLUG_IN_VIOLATIONS with cause been “Wallet Key Needed” when converting a migrated Non-CDB to PDB. Explanation This violation(…)

Getting started with Greenplum – 2 – Initializing and bringing up the cluster

In the last post we’ve configured the operating system for Greenplum and completed the installation. In this post we’ll create the so called “Data Storage Areas” (which is just a mount point or directory) and initialize(…)

Getting started with Greenplum – 1 – Installation

Because PostgreSQL is fully open source there are many forks of it. One of them is called Greenplum which describes itself as “an advanced, fully featured, open source data warehouse, based on PostgreSQL”. Sounds interesting, so(…)

Monitor Kubernetes with Zabbix

Zabbix might not be the first monitoring tool that comes in mind when you want to monitor a Kubernetes cluster (Did you say Prometheus? 🙂 ). Nevertheless, as an open-source project, Zabbix have affinities with others open-source projects. In this(…)

SQL Server: Manage large data ranges using partitioning

Introduction:  When it comes to moving ranges of data with many rows across different tables in SQL-Server, the partitioning functionality of SQL-Server can provide a good solution for manageability and performance optimizing. In this blog we will look at the(…)

Kubernetes Networking by Using Cilium – Intermediate Level – Traditional Linux Routing

Discover a DevOps technology that is about Kubernetes Networking by using Cilium.

Physical Online Migration to ExaCC with Oracle Zero Downtime Migration (ZDM)

A while ago I had been testing and blogging about ZDM, see my previous articles. And I finally had the chance to implement it at one of our customer to migrate on-premise databases to Exadata Cloud @Customer. After having been(…)