Blog


Move to the Cloud – Webinar

Get the slides from the webinar “Move to the Cloud – not only for techies”. Also, you can find the missing part on transportable tablespaces, and information about a recording.

Migration Strategies

We did a webinar today on Migration Strategies – Tips and Tricks and Insights and Secrets. Here is a wrap-up and link to the slides.

Debut on the Big Stage

In mid-October you can join our two webinars on database migration. One of them is exclusively about cloud migration – for techies only.

TDE from a Non-Security Guy

TDE Tablespace Encryption is a must-have in the cloud and something that most of us have to learn. I recently gave a presentation on the basics and what you will need to learn to survive in the cloud.

Zero Downtime Migration

Zero Downtime Migration is a cool and free tool that you can use to migrate into OCI. This blog post introduces the tool and gives you a good overview of the process and all the details.

Why Aren’t You Using SQLcl?

SQLcl is the modern CLI for Oracle Database and it offers a ton of cool features and productivity boosts. Yet, still a lot of users are stuck in the last millennium aka SQL*Plus.

Upgrading in the cloud – VM DB Systems – What about downgrade?

What will you do if things go south? On a VM DB System in OCI you can’t do a database downgrade unless you make special preparations in the new release CDB. In this post I will discuss why it is so, and what you can do to have the option of downgrading.

Upgrading in the cloud – VM DB Systems – 12.2.0.1 PDB to 19c

In this blog post I will show you how to upgrade a 12.2.0.1 PDB to 19c when it is running in a VM DB System. I have a PDB called SALES and it is running Standard Edition 2 (yes, this procedure works for Standard Edition 2 as well). In a previous blog post I went over the restrictions that apply to VM DB System and having those in mind I can create a high-level plan for the upgrade

Upgrading in the cloud – VM DB Systems

This is the first post in a series on the entry-level database system in OCI – being Virtual Machine DB System (VM DB System). You don’t get the same specs as with Exadata DB Systems and Bare Metal DB Systems, but it is much more affordable and still a very good platform. There is good tooling that allows most operations to be fully automated. But there are some limitations that you must be aware of that makes upgrading slightly different.