opatch fail with distinct errors/warnings : Latest opatch Recommended

(Doc ID 2363715.1)

Last updated on MAY 30, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2.0 and later
Information in this document applies to any platform.

Symptoms

 Apply a patch to an ORACLE_HOME may results in one of the belong warnings/errors :

 

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: D:\oracle2\product\root6\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 : /u02/software/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 : /u01/app/oracle/product/12.1.0.2/dbhome_1/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: /home/oracle/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
/u01/oracle/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 /u01/oracle/product/12.2.0/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

 

Changes

 Apply a patch to an ORACLE_HOME

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms