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…