Upgrading Oracle Grid Infrastructure 11gR2 to 12cR2

Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) Grid Infrastructure to Oracle 12cR2 (12.2.0.1) on the same server. This upgrade process was done on Linux 6 (x86_64). 1. Before the GI upgrade backup the OCR manually. This could be used in downgrading the GI from 12.2.0.1 to 11.2.0.4 later one. If you […]

Read More

RDBMS DST Upgrade

After upgrading to Oracle 12.2, we face the issue of RDBMS DST timezones.Then either check support id 1585343.1 or else follow the below step 1.Connect to “sqlplus” and run the “upg_tzv_check.txt” file. If you want to download the content of upg_tzv_check [oracle@oracle122 admin]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Sat Mar 4 […]

Read More

Manual upgrading Oracle database 11gR2 to 12cR2

Manual upgrading Oracle database 11gR2 to 12cR2 If you want to know how we upgrade an 11.2.0.4 database to 12.2.0.1 using DBUA, click here. This article explains how to upgrade 11.2.0.2 and above, and 12.1.0.1 to 12.2.0.1 manually. Manually upgrading to 12c There are many DBAs who don’t want to follow the recommended way of upgrade […]

Read More

Upgrade Oracle 11gR2 (11.2.0.4) database to 12cR2 (12.2.0.1)

Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) database to Oracle 12cR2 (12.2.0.1) on the same server. This upgrade process was done on Linux 6 (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 […]

Read More