-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|