Overview of blog
In this blog post, we will explore a comprehensive solution to resolve the issue of ‘oracle.rdbms.deconfig, 19.0.0.0.0’: Cannot delete file ‘/usr/local/oracle/19.3.0.0/suptools/tfa’ and the subsequent ‘CheckApplicable’ prerequisite failure. This problem emerged while attempting to apply the GI RU (35319490) patch for the ORACLE_HOME environment in July 2023.
Purpose
To initiate the GI RU patch application process, we employed the following command, keeping in mind the requirement to set an ORACLE_HOME as GRID_HOME within the root user environment:
export ORACLE_HOME=/usr/local/oragrid/19.3.0.0
export PATH=/usr/local/oragrid/19.3.0.0/OPatch:$PATH
#ORACLE_HOME/OPatch/opatchauto apply /usr/local/oracle/35319490
Error occurs: –
However, as we began applying the patch to the oracle_home while the cluster services were offline, a new challenge emerged, leading to the subsequent error.
After verified mentioned log file’s it shows the below error.
Resolution: –
To tackle this, our initial approach was to grant read/write permissions or remove the files mentioned in the earlier error message. This allowed the patch to proceed with the necessary removal of files in the TFA directory.
Upon confirming this, a new error surfaced:
‘oracle.rdbms.deconfig, 19.0.0.0.0’: Cannot delete file ‘/usr/local/oracle/19.3.0.0/suptools/tfa’ Prerequisite check “CheckApplicable” failed.
Understanding the nature of this error, we proceeded by granting full read/write permissions to the “/tfa” directories.
With this adjustment in place, we reinitiated the patching process using the following command:
#<ORACLE_HOME>/OPatch/opatchauto resume.
This command allowed the patching process to resume within the same session, resulting in the successful application and completion of the opatch procedure in both the Grid_home and Oracle_home environments. By following these steps, we effectively addressed the ‘CheckApplicable’ prerequisite error and successfully applied the Oracle GI RU July-2023 patch.
