Oracle patch installation failed with error: Prerequisite check "CheckRollbackable" failed

Products

• Data Loss Prevention Oracle Standard Edition 2

Issue/Introduction

Oracle patch installation failed with error: Prerequisite check "CheckRollbackable" failed

Environment

DLP 16.0.1 and Oracle 19C Standard

Cause

Directory missing: C:\oracle\product\19.3.0.0\db_1\.patch_storage\36195566_Mar_31_2024_22_17_10

Resolution

1. Checked and got below error in patch logs:

[Oct 1, 2024 6:37:04 PM] [INFO]     OPatch cannot find cached file under C:\oracle\product\19.3.0.0\db_1\.patch_storage\36195566_Mar_31_2024_22_17_10\unchanged_files.txt:
[Oct 1, 2024 6:37:05 PM] [INFO]     Patch 36195566:
                                    Delete Action: Directory "C:\oracle\product\19.3.0.0\db_1\.patch_storage\36195566_Mar_31_2024_22_17_10" does not exists or is not readable. 
                                    'oracle.jdk, 1.8.0.201.0': Cannot copy file from 'api-ms-win-core-console-l1-1-0.dll' to 'C:\oracle\product\19.3.0.0\db_1\jdk\bin\api-ms-win-core-console-l1-1-0.dll'
                                    Delete Action: Directory "C:\oracle\product\19.3.0.0\db_1\.patch_storage\36195566_Mar_31_2024_22_17_10" does not exists or is not readable. 

Files needed to rollback existing subset patch (es) are missing from $ORACLE_HOME/.patch_storage.
OPatch is unable to find C:\oracle\product\19.3.0.0\db_1\.patch_storage\36195566_Mar_31_2024_22_17_10\ directory.

2. Checked if existing backup of the ORACLE_HOME directory exists (C:\oracle\product\19.3.0.0\db_1) before installing this patch for the first time.

3. If yes then the missing directories(C:\oracle\product\19.3.0.0\db_1\.patch_storage\36195566_Mar_31_2024_22_17_10\ directory) and files can be restored from the backup of the ORACLE_HOME and once that is done.

4. Restored above missing folder from backup, and patch got installed successfully