DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: oracle upgrade issues

  1. #1
    Join Date
    Mar 2025
    Posts
    1

    oracle upgrade issues

    Hello all,

    wanted to know what is the issues here.

    I have loaded oracle 19c on the windows 2022 fine.

    then tried to patch to 35681552 and it went fine to as per the command line saying the patch has been applied successfully.

    but upon restarting the database. it starts up as well but in the log file i see as follow:

    Unable to obtain current patch information due to error: 20001, ORA-20001: Latest xml inventory is not loaded into table
    ORA-06512: at "SYS.DBMS_QOPATCH", line 2327
    ORA-06512: at "SYS.DBMS_QOPATCH", line 854
    ORA-06512: at "SYS.DBMS_QOPATCH", line 937
    ORA-06510: PL/SQL: unhandled user-defined exception
    ORA-06512: at "SYS.DBMS_QOPATCH", line 932
    ORA-29913: error in executing ODCIEXTTABLEFETCH callout
    ORA-29400: data cartridge error
    KUP-04020: found record longer than buffer size supported, 8388608, in D:\SW\WINDOWS.X64_193000_db_home\QOpatch\qopiprep.bat (offset=0)
    ORA-06512: at "SYS.DBMS_QOPATCH", line 919
    ORA-06512: at "SYS.DBMS_QOPATCH", line 2286
    ORA-06512: at "SYS.DBMS_QOPATCH", line 817
    ORA-06512: at "SYS.DBMS_QOPATCH", line 2309

    ===========================================================
    Dumping current patch information
    ===========================================================
    Unable to obtain current patch information due to error: 20001
    ===========================================================
    2025-03-12T14:54:26.724934-05:00

    How to resolve this. please guide.

    thanks

  2. #2
    Join Date
    Jul 2025
    Location
    Kettering, Ohio, USA
    Posts
    1
    The issue you're encountering is due to the DBMS_QOPATCH package failing to read the patch inventory, likely because of a corrupted or oversized XML inventory file. The key error is:
    KUP-04020: found record longer than buffer size supported, which suggests the XML inventory file is too large.

    Solution:
    Run the following to reload the inventory:

    bash
    Copy
    Edit
    cd %ORACLE_HOME%\OPatch
    opatch util importInventory
    If that doesn't work, delete and regenerate the XML:

    bash
    Copy
    Edit
    cd %ORACLE_HOME%\QOpatch
    del *.xml
    Then rerun the patch application or contact Oracle Support for help with large XML parsing issues.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width