Upgrading to Oracle Database 12cR2 Using Transient Logical Standby Method

Rolling upgrade with Transient Logical Standby is known as a MAA (Maximum Availability Architecture) technique, to minimize downtime during upgrade of Oracle database.  This note will document the steps for performing the Advanced Data Guard method of Transient Logical Rolling Upgrade. The following picture provides the general flow for an example migration of on-premise database […]

Read More

Upgrade Database from Oracle 11gR2 to Oracle 18c

Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) database to Oracle 18c(18.0.0.0.0) on the same server. This upgrade process was done on Linux 7 (x86_64). I used DBUA (Database Upgrade Assistant) to perform this upgrade. DBUA is also a recommended way to perform the upgrade as it would automate almost everything for you. You should be able to use the […]

Read More