As Oracle annouced that new Oracle Enterprise Manager 13.4 release is now available for download! To download it, you can either visit the Oracle Enterprise Manager downloads page or visit the Oracle Software Delivery Cloud. We are going to upgrade from OEM 13.3 to OEM 13.4 with repository database 12.2.0.1. Prerequisites for Upgrading to Enterprise Manager Cloud Control […]
Articles Tagged: Upgrade
Manual upgrading Oracle database 11gR2 to 19c
Manual upgrading Oracle database 11gR2 to 19c If you want to know how we upgrade an 11.2.0.4 database to 19.0.0.0.0 using DBUA, click here. This article explains how to upgrade 11.2.0.3 and above, and 12.1.0.1, 12.2.0.1, 18c to 19.0.0.0.0 manually. Manually upgrading to 19c There are many DBAs who don’t want to follow the recommended […]
Upgrade Database from Oracle 11gR2 to Oracle 19c
Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) database to Oracle 19c (19.2.0.0.0) on the same server. This upgrade process was done on Oracle Linux 7.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 for you. You should be able to […]
Refreshing Materialized Views (mv_refresh)
To upgrade from Oracle 11gR2 to Oracle 18c/19c, we need to refresh materialized views. Oracle recommends that all materialized views (MV’s) are refreshed before upgrading the database because this will clear the MV logs and the sumdelta$ table, and make the UPGRADE process faster. SQL> declare num_failures integer(3) :=0; begin DBMS_MVIEW.REFRESH_ALL_MVIEWS(num_failures,’C’,”, TRUE, FALSE); end; / PL/SQL procedure successfully […]
Upgrade and Patch Application in Application Container
In previous article we have seen Installing Application and Synchronizing it with Application PDB. Introduction to Application Container Application Container Creation and Installation of Application In this article, we will see upgrading Application and Patching Application. 1. Upgrade Application in Application Container : Before starting application upgrade you need to know the current version of […]
Using DBMS_ROLLING to Upgrade the Oracle Database
We know the pain of Upgrading Database, taking hours of downtime. But, Oracle comes with a new feature called DBMS_ROLLING from 12C Release 1. If you are having a license for Active Data Guard this method will minimize your downtime for upgrade or patching. This method is well automated. You just need 90 seconds 120 […]
Upgrade Grid Infrastructure to 18.2 by applying RU
Database 18c Patch As of the Release date (17-Apr-2018), the only Oracle Database 18 software that is available is 18.1.0 for on-premise Exadata. Therefore, the following patches for Oracle Database 18 are only for on-premise Exadata systems that are running Oracle Database 18.1.0. More Info: Database 18 Proactive Patch Information (Doc ID 2369376.1) OPatch Utility Information You must […]
Patching (or Updating) home and database to 18.2 from base release by applying RU
Database 18c Patch As of the Release date (17-Apr-2018), the only Oracle Database 18 software that is available is 18.1.0 for on-premise Exadata. Therefore, the following patches for Oracle Database 18 are only for on-premise Exadata systems that are running Oracle Database 18.1.0. More Info: Database 18 Proactive Patch Information (Doc ID 2369376.1) OPatch Utility Information […]
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 […]
Upgrading Oracle Grid Infrastructure 11gR2 to 18c
Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) Grid Infrastructure to Oracle 18c (18.0.0.0) on the same server. This upgrade process was done on Linux 7 (x86_64). Before the GI upgrade backup the OCR manually. This could be used in downgrading the GI from 18.0.0.0 to 11.2.0.4 later one. If you want […]