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

26> opatch fail with :
ApplySession failed in system modification phase... 'ApplySession::apply failed: java.io.IOException: oracle.sysman.oui.patch.PatchException: java.lang.NoClassDefFoundError: javax/xml/stream/XMLOutputFactory

27> OPatch failed with error code 1

Unrecognized option: --illegal-access=deny
Error: Could not create the Java Virtual Machine.
Error: A fatal exception has occurred. Program will exit.

28> $ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./<patch_id>
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2024, Oracle Corporation. All rights reserved.

ZOP-50: The patch location is not valid because it may not exist (or) current user has no permission to access it. Please check the same.
Argument(s) Error... Patch Location not valid

Please check the arguments and try again.

OPatch failed with error code 135