WINDOWS : ORA-20001: Latest xml inventory is not loaded into table ORA-06512: at "SYS.DBMS_QOPATCH" in alert.logs of several DB Instances ,after Server reboot
(Doc ID 2616202.1)
Last updated on JANUARY 24, 2022
Applies to:
Oracle Database - Standard Edition - Version 12.2.0.1 and laterGeneric Windows
Symptoms
On a Windows Setup with 1 Oracle Home & multiple Database Instances,Whenever the Server is rebooted,the below messages are logged in the alert.log(s) of some/all Instances:
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 2472
ORA-06512: at "SYS.DBMS_QOPATCH", line 889
ORA-06512: at "SYS.DBMS_QOPATCH", line 978
ORA-06512: at "SYS.DBMS_QOPATCH", line 2427
ORA-06512: at "SYS.DBMS_QOPATCH", line 852
ORA-06512: at "SYS.DBMS_QOPATCH", line 2452
ORA-06512: at "SYS.DBMS_QOPATCH", line 2472
ORA-06512: at "SYS.DBMS_QOPATCH", line 889
ORA-06512: at "SYS.DBMS_QOPATCH", line 978
ORA-06512: at "SYS.DBMS_QOPATCH", line 2427
ORA-06512: at "SYS.DBMS_QOPATCH", line 852
ORA-06512: at "SYS.DBMS_QOPATCH", line 2452
Checking the QI Log - <ORACLE_HOME>\QOpatch\qopatch_log.log:
LOG file opened at 05/06/19 03:24:18
KUP-05007: Warning: Intra source concurrency disabled because the preprocessor option is being used.
Field Definitions for table OPATCH_XML_INV
Record format DELIMITED BY NEWLINE
Data in file has same endianness as the platform
Reject rows with all null fields
Fields in Data Source:
XML_INVENTORY CHAR (100000000)
Terminated by "UIJSVTBOEIZBEFFQBL"
Trim whitespace same as SQL Loader
KUP-04004: error while reading file <ORACLE_HOME>\QOpatch\qopiprep.bat
KUP-04017: OS message: The operation completed successfully.
KUP-04017: OS message: The process cannot access the file because it is being used by another process.
KUP-04118: operation "read_pipe", location "skudmir:3"
KUP-05007: Warning: Intra source concurrency disabled because the preprocessor option is being used.
Field Definitions for table OPATCH_XML_INV
Record format DELIMITED BY NEWLINE
Data in file has same endianness as the platform
Reject rows with all null fields
Fields in Data Source:
XML_INVENTORY CHAR (100000000)
Terminated by "UIJSVTBOEIZBEFFQBL"
Trim whitespace same as SQL Loader
KUP-04004: error while reading file <ORACLE_HOME>\QOpatch\qopiprep.bat
KUP-04017: OS message: The operation completed successfully.
KUP-04017: OS message: The process cannot access the file because it is being used by another process.
KUP-04118: operation "read_pipe", location "skudmir:3"
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |