opatch fail with distinct errors/warnings : Latest opatch Recommended (Doc ID 2363715.1)

1> Prereq "checkConflictAgainstOHWithDetail" failed.
     The details are:
     Please rebuild patch xxxxxx
     Subset patch xxxxx can't overlay superset patch xxxxx
     Summary of Conflict Analysis:
     There are no patches that can be applied now.

2> Unable to create Patch Object.
     Exception occured : Your Oracle Home has a constituent installed without having its prereqalso installed. This is an error condition and we exit.
     The installed patch that is out of order is: xxxxxxxxx

3> opatch fail as below :

  Verifying environment and performing prerequisite checks...
  All of the constituents of the composite patch are already installed in the Oracle Home. No need to apply this patch.

4> Prereq “checkConflictAgainstOHWithDetail” failed.
     The details are:
     Patch xxxxx is a composite patch which could not be rollback.

5> INFO:java.io.FileNotFoundException:
     $ORACLE_HOME\.patch_storage\<PATCH_ID>_Jul_05_2012_23_51_05\scratch\work\AlertDetailsDataObject.class (Access is denied)
     INFO: at java.io.FileOutputStream.open(Native Method)

6> Can't locate object method "get_abs_path" via package "Apply" at $ORACLE_HOME/OPatch/perl_modules/Apply.pm line 6368.

7> ERROR: Interim inventory update exception: Oneoff patch xxxxxx has no base/referencer components.
     Files on system are patched but Inventory Update has failed. Please run 'opatch lsinventory' to check if the patch has been recorded in Inventory.
     Update Inventory error
     ERROR: OPatch failed because of Inventory problem.

8> Datapatch fail with error “Queryable inventory could not determine the current opatch status”

9> While applying Windows BP, opatch fail with below error :

     [Aug 9, 2017 5:37:06 AM] [INFO] The following warnings have occurred during OPatch execution:
     [Aug 9, 2017 5:37:06 AM] [INFO] 1) OUI-67124:ApplySession failed but Oracle Home has not been modified.Bad version number in .class file
     [Aug 9, 2017 5:37:06 AM] [INFO] ——————————————————————————–
     [Aug 9, 2017 5:37:06 AM] [INFO] Finishing UtilSession at Wed Aug 09 05:37:06 EDT 2017
     [Aug 9, 2017 5:37:06 AM] [INFO] Log file location: ....\cfgtoollogs\opatch\opatch2017-08-09_05-36-40AM_1.log
     [Aug 9, 2017 5:37:06 AM] [INFO] Stack Description: java.lang.RuntimeException: ApplySession failed but Oracle Home has not been modified.Bad version number in .class file

10> Applying Patch 27338041 fails with error:

Verifying the update...
There are 1 copy files under ORACLE_HOME that are not patched.
Files check failed: Some files under ORACLE_HOME are not patched. Please see log file for details.
ApplySession failed in system modification phase... 'Verification of patch failed: Files are not updated completely.'
..
..
[Apr 18, 2018 5:10:45 PM] Failed file pair information (copy)::
[Apr 18, 2018 5:10:45 PM] Source file name is : ..../patches/p27338041_121020_Linux-x86-64/27338041/27338041/files/rdbms/admin/prvtash.plb , size is : 76570
[Apr 18, 2018 5:10:45 PM] Destination file name is : <ORACLE_HOME>/rdbms/admin/prvtash.plb, size is : 15384
[Apr 18, 2018 5:10:45 PM] verifying 61 archive files.

 

11> Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" is not executed.

The details are:
Unable to create Patch Object.
Exception occured : java.lang.RuntimeException: ..../april2018_ru/27674384/etc/config/actions.xml with Version field of the component "delete" in actions file cannot be <null> or empty. Please check patch metadata.

OPatch failed with error code 2

12> Latest Windows Bundle Patch may conflict with Older Windows bundle patch .

Example :

Patch version : 12.2.0.1.6
OUI version : 12.2.0.1.4
Conflicts/Supersets for each patch are:

Patch : 27426753
Bug Conflict with 26758841

Following patches have conflicts: [ 26758841 27426753 ]

13> datapatch fail with below error:

Queryable inventory could not determine the current opatch status.
Execute 'select dbms_sqlpatch.verify_queryable_inventory from dual' and/or check the invocation log .../cfgtoollogs/sqlpatch/sqlpatch_10555_2018_05_02_10_50_37/sqlpatch_invocation.log for the complete error.
Prereq check failed, exiting without installing any patches.

SQL> select dbms_sqlpatch.verify_queryable_inventory from dual;

VERIFY_QUERYABLE_INVENTORY
--------------------------------------------------------------------------------
ORA-20001: Latest xml inventory is not loaded into table

qopatch_log.log file: 
KUP-04095: preprocessor command <ORACLE_HOME>/QOpatch/qopiprep.bat encountered error "Inventory load failed... OPatch cannot load inventory for the given Oracle Home.

14> opatchauto apply -analyze fail with below message :

Exception: For input string: ""
java.lang.NumberFormatException: For input string: ""
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:59)
at java.lang.Integer.parseInt(Integer.java:481)
at java.lang.Integer.parseInt(Integer.java:510)
at oracle.opatchauto.gi.PatchVersionReader.main(PatchVersionReader.java:87)
Patch version not found

15> Opatch Apply Fails with Error Code 20 :

Verifying environment and performing prerequisite checks...
[ Error during Oracle Home discovery Phase]. Detail: OPatch failed: ApplySession failed to prepare the system. oracle/cluster/install/InstallException
Log file location: .../cfgtoollogs/opatch/16052165_Aug_12_2018_01_19_27/apply2018-08-12_01-19-27AM_1.log

Recommended actions: Please make sure no other OPatch or OUI processes is running. Try to run $ORACLE_HOME/oui/bin/runInstsaller.

OPatch failed with error code 20

16> opatch apply may error out at linking phase as below :

Make failed to invoke "/usr/ccs/bin/make -f ins_net_client.mk client_sharedlib ORACLE_HOME=<ORACLE_HOME>"....'<ORACLE_HOME>/bin/genclntsh: not found
make: The error code from the last command is 1. 

The following make actions have failed :

Re-link fails on target "client_sharedlib".
Re-link fails on target "ldapaddmt".
Re-link fails on target "ldapadd".
Re-link fails on target "ldapmodify".
Re-link fails on target "ldapmodifymt".
Re-link fails on target "client_sharedlib".
Re-link fails on target "liborasdksh".
Re-link fails on target "liborasdkbase".
Re-link fails on target "nmosudo".
Re-link fails on target "agent".
Re-link fails on target "clientonlyinstall".

17> opatch apply error as below :

[FINE] All the required patch(es) are present in the Oracle Home.
[FINE] Running prerequisite check "CheckMultipleTranslationPatches" 
[SEVERE] OUI-67073:UtilSession failed: null
[INFO]    Stack Description: java.lang.RuntimeException: null

18> opatch apply fail as below :

Start OOP by Prereq process.

Launch OOP...

<oracle_home>/OPatch/opatch: ORACLE_HOME=<oracle_home>: is not an identifier

19> opatch fail as below :

OUI-67200:Make failed to invoke "/usr/bin/make -f ins_precomp.mk proc ORACLE_HOME=<DB_HOME>"....'<GI_HOME>/lib/libons.so: undefined reference to 'memcpy@GLIBC_2.14'
/bin/chmod: cannot access ‘<DB_HOME>/precomp/lib/proc’: No such file or directory
make[1]: *** [<DB_HOME>/precomp/lib/proc] Error 1
make: *** [proc] Error 2

20> opatch commands fails as below:

OUI-67073:UtilSession failed: Trailing char < > at index 0:
Finishing UtilSession at Fri Jan 08 20:17:36 EST 2021
..
[INFO] Stack Description: java.lang.RuntimeException: Trailing char < > at index 0:
..

21> $ORACLE_HOME/OPatch/opatch lsinventory
       Error: This Java instance does not support a 64-bit JVM.
       Please install the desired version.

       OPatch failed with error code 1

22> $ opatch lsinv fail with below error :

OPatch cannot continue because it would not be able to load OUI platform dependent library from the directory "<ORACLE_HOME>/oui/lib/linux". The directory does not exist in the Oracle home.
This could be due to the following reasons.
(1) Incompatible usage of java with OUI (32/64 bit).
(2) Wrong 32-bit Oracle Home installation in 64-bit environment (or) vice-versa.
Please contact Oracle support for more details.

OPatch failed with error code 1

 

23> opatch apply is hung long time (more than one hour) doing next:
       [INFO] Running prerequisite checks...

24>opatch fails to apply by listing active processes from oracle_home/java executable : False Alert
Following active files/executables/libs are used by ORACLE_HOME :C:\db_home

C:\db_home\jdk\bin\java.exe
C:\db_home\jdk\jre\bin\java.dll
C:\db_home\jdk\jre\bin\management.dll
C:\db_home\jdk\jre\bin\msvcr100.dll
C:\db_home\jdk\jre\bin\net.dll
C:\db_home\jdk\jre\bin\nio.dll
C:\db_home\jdk\jre\bin\server\jvm.dll
C:\db_home\jdk\jre\bin\verify.dll
C:\db_home\jdk\jre\bin\zip.dll

C:\db_home\jdk\jre\lib\rt.jar
C:\db_home\jdk\bin\java.exe
C:\db_home\jdk\jre\bin\java.dll
C:\db_home\jdk\jre\bin\management.dll
C:\db_home\jdk\jre\bin\net.dll
C:\db_home\jdk\jre\bin\nio.dll
C:\db_home\jdk\jre\bin\verify.dll
C:\db_home\jdk\jre\bin\zip.dll
C:\db_home\jdk\jre\bin\server\jvm.dll
C:\db_home\jdk\jre\lib\rt.jar

 

25> opatch apply
Oracle Interim Patch Installer version 12.2.0.1.15
Copyright (c) 2024, Oracle Corporation. All rights reserved.

Oracle Home : C:\app\Oracle\product\190~1.0\CLIENT~1
Central Inventory : C:\Program Files (x86)\Oracle\Inventory
from :
OPatch version : 12.2.0.1.15
OUI version : 12.2.0.7.0
Log file location : C:\app\Oracle\product\190~1.0\CLIENT~1\cfgtoollogs\opatch\opatch2024-04-02_09-25-00AM_1.log

Verifying environment and performing prerequisite checks...
UtilSession failed: null
Log file location: C:\app\Oracle\product\190~1.0\CLIENT~1\cfgtoollogs\opatch\opatch2024-04-02_09-25-00AM_1.log

OPatch failed with error code = 73