Disclaimer: The following recovery scenario is for a very specific case. It requires a comprehensive knowledge of the application schema design and the relationship between the different tables. It is not by any means valid for all block corruption cases. It not by any means a replacement for the regular database backups. Having a good … Continue reading Fully Recover Oracle Database from Block Corruption without backup
Blog
Oracle Enterprise Manager 13c R5 Disk Full Issue
I have a client who recently installed Oracle Enterprise Manager 13c R5 on Windows Server 2019. All OEM components are installed on the same server (Database, OMS, Agent,..etc)The space consumed by all OEM components should't exceed about 40 GB.The installation was done on 400GB disk. Within couple of days, my client complained that the disk … Continue reading Oracle Enterprise Manager 13c R5 Disk Full Issue
The file name(s) would be too long for the destination folder
While copying 40GB folder on Windows 10 from partition E:\ to partition F:\, and after copying most of the files, I received the following error message: I checked this folder and I found that its path name is too long.So, the problem is not in the folder name, it is the path name length who … Continue reading The file name(s) would be too long for the destination folder
Oracle Linux 7.7 Installation on Oracle VirtualBox
How to upgrade Oracle VirtualBox to the latest version?
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)