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 184.108.40.206. Prerequisites for Upgrading to Enterprise Manager Cloud Control […]
Manual upgrading Oracle database 11gR2 to 19c If you want to know how we upgrade an 220.127.116.11 database to 18.104.22.168.0 using DBUA, click here. This article explains how to upgrade 22.214.171.124 and above, and 126.96.36.199, 188.8.131.52, 18c to 184.108.40.206.0 manually. Manually upgrading to 19c There are many DBAs who don’t want to follow the recommended […]
Here I would be discussing how to upgrade Oracle 11gR2 (220.127.116.11) database to Oracle 19c (18.104.22.168.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 […]
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;
DBMS_MVIEW.REFRESH_ALL_MVIEWS(num_failures,'C','', TRUE, FALSE);
PL/SQL procedure successfully completed.
SQL> SQL> select count(1) from sumdelta$;
Stay tuned for more articles on Oracle 19c Thank you for giving your valuable […]
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 […]
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 […]
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 […]
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 […]
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 […]
Here I would be discussing how to upgrade Oracle 11gR2 (22.214.171.124) Grid Infrastructure to Oracle 18c (126.96.36.199) 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 188.8.131.52 to 184.108.40.206 later one. If you want […]