All of us have faced ORA-03297 when shrinking a datafile post a cleanup activity. Shrinking a datafile sounds pretty straight-forward but it depends if the purging did reduced the high watermark on the datafile or the high watermark is still at the end of the datafile and you have chunks of free space below the…
Oracle recently released its April 2021 Release Update for 12cR2 (Patch 32507738). This post is to cover patching of Oracle 12cR2 database with this latest RU. (For 19.11 RU please read How to Apply Release Update 19.11.0.0.0 (Patch 32545013)). Step-1: Install Latest OPatch First Step of Any Patching Process is to download and install…
Oracle / oracle 19c / Oracle 21c / Patching
After writing article How to Upgrade OPatch to Latest Version, a few reader raised concerns that they got following error when calling opatch binaries. Even after ensuring that java is installed and all relevant environment variables were also set correctly. The OPatch utility’s md5sum was compared and there was no corruption. To fix this we…
This article covers the process of applying the Oracle Release Update 19.11 (Patch 32545013) on a 19c Database. Step-1: Install Latest OPatch First Step of Any Patching Process is to download and install the latest version of OPatch. You can follow How to Upgrade OPatch to Latest Version post to quickly upgrade OPatch to latest…
This is a quick article to upgrade OPatch to latest release as its always recommended to use the latest version of OPatch before patching your database or grid. This would also be base reference for future posts on Applying latest Release Updates (RUs) and Release Update Revisions (RURs). Download the latest copy of Opatch from…
In this article, we’ll perform an upgrade from 12cR2 Non container database to a 19c pluggable database using autoupgrade. If you are not aware of this autoupgrade utility, I would recommend to read my blog post on this topic Oracle 19c AutoUpgrade Utility which explains the workflow, stages and modes in autoupgrade utility. For 11gR2…
In this article we will upgrade 11gR2 DB to 19c DB using Autoupgrade utility which will not only upgrade the DB but also convert the non-CDB to PDB. This article assume that you have basic understanding of Autoupgrade utility and its different modes and stage, if not then go through a quick read of Oracle…
The AutoUpgrade utility introduced with Oracle 19c identifies issues before upgrades, performs pre- and postupgrade actions, deploys upgrades, performs postupgrade actions, and starts the upgraded Oracle Database. In this article we’ll see how this new autoupgrade utility almost completely automates the database upgrade process including pre & post upgrade tasks. The autoupgrade.jar file is available…
From 19c Oracle can be installed on Oracle Linux OS using an RPM. In this article we’ll perform an RPM installation of Oracle Database 19c 64-bit on Oracle Linux 7 (OL7) 64-bit. Step 1: Download the RPM from OTN Download the oracle-database-ee-19c-1.0-1.x86_64.rpm file from Oracle Technology Network required for performing an RPM-based installation to a directory of your choice.…
During a recent troubleshooting, we came across a requirement where we wanted to know what all locations does Oracle searches tnsnames.ora ? So writing this quick post for the analysis that we did and the results we reached during this exercise. You might already aware of tnsnames.ora in path defined by TNS_ADMIN variable and default…
Below is the query to detect the REDO Log switch frequency for any Oracle Instance:
Cause: The foreground process doing instance recovery died. Action: Check the foreground trace file for the cause of recovery failure.
Cause: A clone database open forces logfile renaming to avoid overwriting the primary logfiles Action Rename the logfiles manually or using the log_file_name_convert initialization parameter
Cause: The specified process did not start. Action: Ensure that the executable image is in the correct place with the correct protections, and that there is enough memory.
Cause: It has been detected that an online log that is being archived has been reused Action: Cannot archive the logfile anymore since it has been overwritten
Oracle Database Internal Mechanism 