Upgrade 11gR2 (Non-CDB) to 19c (PDB) using AutoUpgrade

In this article we will upgrade 11gR2 DB to 19c DB using Autoupgrade utility which will not only upgrade the DB but also convert the non-CDB to PDB. This article assume that you have basic understanding of Autoupgrade utility and its different modes and stage, if not then go through a quick read of Oracle…

Oracle 19c AutoUpgrade Utility

The AutoUpgrade utility introduced with Oracle 19c identifies issues before upgrades, performs pre- and postupgrade actions, deploys upgrades, performs postupgrade actions, and starts the upgraded Oracle Database. In this article we’ll see how this new autoupgrade utility almost completely automates the database upgrade process including pre & post upgrade tasks. The autoupgrade.jar file is available…

Flashback PDB in Oracle 12cR2

After the introduction of multitenant architecture with Oracle 12cR1, the flashback database feature became irrelevant as it was limited to the root container which resulted in affecting all the PDBs associated with that root container. But with the new release 12cR2, flashback now supports pluggable databases as well. Now we’ll demonstrate how to flashback a…

Installing 12c RAC on Oracle Linux 7

Without further ado, following are the steps to construct your own lab with a 2 node 12c RAC on Linux 6 using Oracle Virtual Box. You can download the required software from below links:- Oracle Linux 7 Oracle VirtualBox Grid Infrastructure 12cR1 Oracle 12cR1 To give you an overview, this is what we are going to…