Rolling Upgrade Oracle 11.2.0.2 database to Oracle 12.1.0.2 using Standby with No Downtime

It is possible to use Standby database to upgrade a database with near no downtime. Application may experience a failover/switchover but no real downtime window that really interrupt the continued availability of application. This is using Oracle Logical standby feature as that allows application to connect to the database with read/write capability. This is no-RACRead more about Rolling Upgrade Oracle 11.2.0.2 database to Oracle 12.1.0.2 using Standby with No Downtime[…]

Upgrading Oracle Databases from 11.2.0.1 to 11.2.0.2

This discussion is about performing an upgrade from 11.2.0.1 databases to 11.2.0.2. This is an out-of-place manual upgrade from 11.2.0.1 to 11.2.0.2. 11.2.0.2 Patch set is a full release. It cannot be installed on top of existing 11.2.0.1 ORACLE_HOME. Note the following steps 1. Install 11.2.0.2 into a separate ORACLE_HOME. 2. Take a full backupRead more about Upgrading Oracle Databases from 11.2.0.1 to 11.2.0.2[…]