Upgrade OEM 12cR5 to 13cR2

Let’s have a quick introduction of Upgrade in Oracle. As we go in depth of this article we have mentioned about the steps of an upgrade OEM from 12cR5 to 13cR2. Thanks to my fellow DBA Kellyn Pot’Vin-Gorman who gave me idea to write on OEM 13c. Day by day technologies get change and advanced technology […]

Read More

Upgrade Oracle Grid and Database (11.2.0.1 to 11.2.0.4)

This article is about upgrade of oracle database 11.2.0.1_to 11.2.0.4).

Download the 9413827 or 9706490 patch from oracle support and get apply

Below are attachment to findout patch steps. Now we can update the grid home and oracle home from 11.2.0.1 to 11.2.0.4 .

1) check the pre-req before upgrading the grid home […]

Read More

Oracle Upgrade Grid and Database Home to 12.1.0.2 with GUI

What is Upgration? It is the process of replacing your existing software with an advance version of the identical product.Upgrading your applications usually do not require special tools. Your existing reports should look and behave the same in both products. For Example: Replacing Oracle 9i release to Oracle 10g release, SQL Server 2005 to SQL Server 2008 etc. Why […]

Read More

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

2. Now check the current timezone.

3. Now run the “upg_tzv_apply.txt” file. […]

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