The following mind map highlights the key steps to install Oracle Database 19.24 on Oracle Linux 9.4 Please note that installation of Oracle database 19.3 on Oracle Linux 9.4 is a little bit different.As the base release 19.3 is a little-bit old compared to Oracle Linux 9.4, then we have to apply the release update … Continue reading Oracle Database 19.24 Installation on Oracle Linux 9.4 Mind Map
[DBT-20052] Database upgrade is not supported from Oracle Home with Oracle Home User “dbuser” to an Oracle Home with Windows Virtual Account.
Background: A customer has an Oracle Database version 12.2.0.1 on Windows server. He asked to upgrade this database to 19c (19.17) on the same server. Procedure: I installed Oracle 19c (19.3) on a new oracle home on the same server.(During the installation I selected "Windows Virtual Account" as the Oracle Home owner) I applied the … Continue reading [DBT-20052] Database upgrade is not supported from Oracle Home with Oracle Home User “dbuser” to an Oracle Home with Windows Virtual Account.
opatch version failed with error: Java (1.7) could not be located. OPatch cannot proceed!
BackgroundI asked one of my colleagues to download the latest opatch patch, in preparation to patching one oracle database 19c home on Oracle Linux platform (8.8).The old utility has version: 12.2.0.1.17 The latest downloaded utility has version: OPATCH_VERSION:12.2.0.1.40 Usually, I start by renaming the old OPatch directory, then extracting the new version under Oracle Home.This … Continue reading opatch version failed with error: Java (1.7) could not be located. OPatch cannot proceed!
Oracle Database 21c Creation via DBCA hangs at 36%
Background I installed Oracle Database 21c on Windows 10 successfully. See the following video for the detailed installation steps: https://www.youtube.com/watch?v=QFovPSi8FKw After that I tried to create a sample database using the dbca (Database Configuration Assistant), but it hangs at 36%, as indicated in the following screen shot: If we examined the dbca log file: We … Continue reading Oracle Database 21c Creation via DBCA hangs at 36%
Oracle Database 19c Release Updates (RUs) and Release Update Revisions (RURs)
Following is a list of all RU (Release Updates) and RUR (Release Update Revisions) issued for the Oracle Database 19c (19.3) since Apr-2019 till today 24-Jun-2021. Please zoom-in to see the above picture clearly, or see it partitioned below: Please note that:– Both RUs & RURs are released quarterly (Jan, April , Jul & Oct).– … Continue reading Oracle Database 19c Release Updates (RUs) and Release Update Revisions (RURs)
opatch error \QuickTime\QTSystem\QTJava.zip was unexpected at this time.
When trying to run opatch on windows, I got the following error: \QuickTime\QTSystem\QTJava.zip was unexpected at this time. After some research, I found that this error is due to spaces in the value of the CLASSPATH variable. Here, we have a couple of solutions: Solution #1 Remove "C:\Program Files (x86)\QuickTime\QTSystem\QTJava.zip" from the CLASSPATH, we don't … Continue reading opatch error \QuickTime\QTSystem\QTJava.zip was unexpected at this time.
Oracle Database 12.2.0.1 Release Updates (RUs) and Release Update Revisions (RURs)
Following is a list of all RU (Release Updates) and RUR (Release Update Revisions) issued for the Oracle Database 12cR2 (12.2.0.1) since Jul-2017 till today 20-Jun-2021. Please zoom-in to see the above picture clearly, or see it partitioned below: Please note that: - Both RU & RUR are released quarterly (Jan, April , Jul & … Continue reading Oracle Database 12.2.0.1 Release Updates (RUs) and Release Update Revisions (RURs)
OPatch error : “Unable to lock Central Inventory”
While applying Patch 31210848 "Microsoft Windows 32-Bit & x86-64 Bundle Patch 12.2.0.1.200714" on database 12.2.0.1on Windows platform I got the following error: Unable to lock Central Inventory. OPatch will attempt to re-lock. Solution: I opened another command window as Administrator, and applied the patch again. This time, it completed successfully without errors: For Windows platform, … Continue reading OPatch error : “Unable to lock Central Inventory”
Ahmed AbdelFattah Blog ! 