My Oracle Support Banner

Queryable Patch Inventory - Issues/Solutions for ORA-20001: Latest xml inventory is not loaded into table (Doc ID 1602089.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Oracle Database - Standard Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

During execution of datapatch or DBMS_QOPATCH following error seen

 

Symptom 1

ERROR:
ORA-20001: Latest xml inventory is not loaded into table
ORA-06512: at "SYS.DBMS_QOPATCH", line 1448
ORA-06512: at "SYS.DBMS_QOPATCH", line 122

 

select * from OPATCH_XML_INV ;
ERROR:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04027: file name check failed: <$ORACLE_HOME>/QOpatch/qopiprep.bat


Symptom 2

Connecting to database…OK
Determining current state…
Currently installed SQL Patches:
DBD::Oracle::st execute failed: ORA-20001: Latest xml inventory is not loaded into table
ORA-06512: at “SYS.DBMS_QOPATCH”, line 1011
ORA-06512: at line 4 (DBD ERROR: OCIStmtExecute) [for Statement "DECLARE
x XMLType;
BEGIN
x := dbms_qopatch.get_pending_activity;
? := x.getStringVal();
END;" with ParamValues: :p1=undef] at <$ORACLE_HOME>/sqlpatch/sqlpatch.pm line 962.

 

Symptom 3

SQL> select dbms_sqlpatch.verify_queryable_inventory from dual;

VERIFY_QUERYABLE_INVENTORY
--------------------------------------------------------------------------------
ORA-20013: DBMS_QOPATCH ran mostly in non install area

SQL> select * from OPATCH_XML_INV ;
ERROR:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04001: error opening file
<$ORACLE_HOME>/QOpatch/qopatch_log.log

 $ORACLE_HOME/QOpatch/qopatch_log.log reports

Terminated by "UIJSVTBOEIZBEFFQBL"
Trim whitespace same as SQL Loader
KUP-04004: error while reading file <$ORACLE_HOME>/QOpatch/qopiprep.bat
KUP-04017: OS message: Error 0
KUP-04017: OS message: error during exec: errno is 13

KUP-04118: operation "pipe read", location "skudmir"

  

Symptoms 4

SQL> select * from OPATCH_XML_INV ;
ERROR:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04095: preprocessor command
<$ORACLE_HOME>/QOpatch/qopiprep.bat encountered error
"/etc/.kshrc[5]: whoami:  not found.
/etc/.kshrc[6]: whoami:  not found.
/etc/.kshrc[16]: termdef:  not found.
/etc/.kshrc[16]: test: 0403-004 Specify a parameter with this command.

 

KUP-04017: OS message: /home/oracle/.kshrc[6]: grep:  not found.
/home/oracle/.kshrc[6]: sort:  not found.

KUP-04118: operation "pipe read", location "skudmir"

 In $ORACLE_HOME/QOpatch/qopatch.log

 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: Error 0
KUP-04017: OS message: /etc/kshrc: hostname: not found.
/etc/kshrc: sed: not found.
/etc/kshrc[2]: id: not found.
/etc/kshrc[2]: sed: not found.
/etc/kshrc[2]: test: 0403-004 Spec
KUP-04118: operation "pipe read", location "skudmir"

 

Symptoms 4a

In $ORACLE_HOME/QOPatch/qopatch.log.

KUP-04017: OS message: Error 0
KUP-04017: OS message: /<ORACLE USER HOME PATH>/.kshrc[10]: stty:  not found.
stty: tcgetattr: A specified file does not support the ioctl system call

 

Symptoms 5

KUP-04004: error while reading file <$ORACLE_HOME>/QOpatch/qopiprep.bat
KUP-04017: OS message: Error 0
KUP-04017: OS message: Inventory load failed... OPatch cannot load inventory for the given Oracle Home.
Possible causes are:
  Oracle Home dir. path does not exist in Central Inventory
KUP-04118: operation "pipe read", location "skudmir

 

Symptoms 6

KUP-04004: error while reading file <$ORACLE_HOME>/QOpatch/qopiprep.bat
KUP-04017: OS message: Error 0
KUP-04017: OS message: [WARN ][jrockit] MaxPermSize=128M ignored: Not a valid option for JRockit

KUP-04118: operation "pipe read", location "skudmir"

Symptoms 7

XML_INVENTORY CHAR (100000000)
Terminated by "UIJSVTBOEIZBEFFQBL"
Trim whitespace same as SQL Loader
KUP-04004: error while reading file <$ORACLE_HOME>b/QOpatch/qopiprep.bat
KUP-04017: OS message: Error 0
KUP-04017: OS message: WARNING: JVM is running with hard ulimit not set to unlimited, out of memory errors may occur
If an out of memory error occurs try running "chuser data
KUP-04118: operation "pipe read", location "skudmir"

Symptoms 8

Bootstrapping registry and package to current versions...done
verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table

Queryable inventory could not determine the current opatch status.
Execute 'select dbms_sqlpatch.verify_queryable_inventory from dual'

From alert log

ORA-1691: unable to extend lobsegment SYS.SYS_LOB0000010985C00001$$ by 128 in tablespace SYSAUX
ORA-1691: unable to extend lobsegment SYS.SYS_LOB0000010985C00001$$ by 128 in tablespace SYSAUX
ORA-1691: unable to extend lobsegment SYS.SYS_LOB0000010985C00001$$ by 128 in tablespace SYSAUX
ORA-1691: unable to extend lobsegment SYS.SYS_LOB0000010985C00001$$ by 128 in tablespace SYSAUX

 

Symptoms 9

Bootstrapping registry and package to current versions...done
verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table

Queryable inventory could not determine the current opatch status.
Execute 'select dbms_sqlpatch.verify_queryable_inventory from dual'

From alert.log


ORA-01186: file 201 failed verification tests
ORA-01122: database file 201 failed verification check
ORA-01110: data file 201: '/<path to datafile>/atmtmp1'
ORA-01203: wrong incarnation of this file - wrong creation SCN
File 201 not verified due to error ORA-01122

Symptoms 10

 SQL> select dbms_sqlpatch.verify_queryable_inventory from dual;

VERIFY_QUERYABLE_INVENTORY
--------------------------------------------------------------------------------
ORA-20001: Latest xml inventory is not loaded into table

From the log: qopatch_log.log

KUP-04004: error while reading file <$ORACLE_HOME>/QOpatch/qopiprep.bat
KUP-04017: OS message: Error 0
KUP-04017: OS message: <$ORACLE_HOME>/QOpatch/qopiprep.bat: line 38: <$ORACLE_HOME>/QOpatch/stout.txt: Permission denied
/opt/oracle/product/12.1
KUP-04118: operation "pipe read", location "skudmir"

Symptoms 11

SQL> select dbms_sqlpatch.verify_queryable_inventory from dual ;

VERIFY_QUERYABLE_INVENTORY
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ORA-20001: Latest xml inventory is not loaded into table


KUP-04004: error while reading file <$ORACLE_HOME>/QOpatch/qopiprep.bat
KUP-04017: OS message: Error 0
KUP-04017: OS message: Argument(s) Error... Cannot use file "<$ORACLE_HOME>/QOpatch/xml_file.xml" to generate XML output.
Specify path/filename and make sure file
KUP-04118: operation "pipe read", location "skudmir"

or

SQL>select * from OPATCH_XML_INV ;
ERROR:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04095: preprocessor command <$ORACLE_HOME>/QOpatch/qopiprep.bat encountered error "Argument(s) Error... Cannot use file
"<$ORACLE_HOME>/QOpatch/xml_file.xml" to generate XML output.
Specify path/filename and make sure "

OR

After applying 30942294 - JDK BUNDLE PATCH 12.1.0.2.200414 patch hitting 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
/<ORACLE_BASE>/cfgtoollogs/sqlpatch/sqlpatch_28508310_2020_08_17_11_03_39/sqlpatch_invocation.log
for the complete error.
Prereq check failed, exiting without installing any patches.

in qopatch_log.log file


KUP-04004: error while reading file /<ORACLE_HOME>/QOpatch/qopiprep.bat
KUP-04017: OS message: Error 0
KUP-04017: OS message: Argument(s) Error... Cannot use file "/<ORACLE_HOME>/QOpatch/xml_file.xml" to generate XML output.
Specify path/filename and make sure filename do
KUP-04118: operation "pipe read", location "skudmir"

OR

Error: prereq checks failed!
  patch 30700212: Existing bundle ID 200414 in patch description does not match highest bundle id 200714 in bundledata.xml
Prereq check failed, exiting without installing any patches.

 

Symptoms 12

[oracle@RAC-DB1 OPatch]$ $RDBMS_HOME/OPatch/datapatch -verbose
SQL Patching tool version 12.2.0.0.0 on Thu Mar 23 20:46:30 2017
Copyright (c) 2014, Oracle. All rights reserved.

Connecting to database...OK

Queryable inventory could not determine the current opatch status.
Execute 'select dbms_sqlpatch.verify_queryable_inventory from dual'
for the complete error.
Prereq check failed, exiting without installing any patches.

Please refer to MOS Note 1609718.1 for information on how to resolve the above errors.

SQL Patching tool complete on Thu Mar 22 09:46:33 2017

 

Symptoms 13

SQL> select dbms_sqlpatch.verify_queryable_inventory from dual;

VERIFY_QUERYABLE_INVENTORY                                                      
--------------------------------------------------------------------------------
ORA-31011: XML parsing failed                                                  
ORA-19202: Error occurred in XML processing                                    
LPX-00229: input source is empty                                                
ORA-06512: at "SYS.XMLTYPE", line 272                                          
ORA-06512: at line 1                                        

 

SQL> select dbms_sqlpatch.verify_queryable_inventory from dual;

VERIFY_QUERYABLE_INVENTORY
--------------------------------------------------------------------------------
ORA-31011: XML parsing failed
ORA-19213: error occurred in XML processing at lines 1
LPX-00241: entity reference is not well formed
ORA-06512: at "SYS.XMLTYPE", line 272
ORA-06512: at line 1

 

Symptoms 14

While executing opatch, following warning is observed

WARNING: JVM is running with hard ulimit not set to unlimited

$ORACLE_HOME/QOpatch/qopatch_log.log has following error messages

KUP-04004: error while reading file <$ORACLE_HOME>/QOpatch/qopiprep.bat
KUP-04017: OS message: Error 0
KUP-04017: OS message: WARNING: JVM is running with hard ulimit not set to unlimited, out of memory errors may occur If an out of memory error occurs try running "chuser data
KUP-04118: operation "pipe read", location "skudmir"

Symptoms 15

qopatch_log.log has following errors

KUP-04004: error while reading file /OFPROD/oracle/finprod/12.1.0/QOpatch/qopiprep.bat
KUP-04017: OS message: Error 0
KUP-04017: OS message: /<ORACLE_HOME>/QOpatch/qopiprep.bat[40]: 0403-029 There is not enough memory available now.
KUP-04118: operation "pipe read", location "skudmir"

Symptoms 16

qopatch_log.log has following errors

 KUP-04095: preprocessor command /<ORACLE_HOME>/QOpatch/qopiprep.bat encountered error "Inventory load failed... OPatch cannot load inventory for the given Oracle Home.

LsInventorySession failed: Unable to create patchObject

 

Symptoms 17

sqlpatch_invocation.log has following errors

Connecting to database...OK
catcon: ALL catcon-related output will be written to <ORACLE_BASE>\cfgtoollogs\sqlpatch\sqlpatch_9208_2018_05_14_14_31_00/sqlpatch_catcon__catcon_9208.lst
catcon: See <ORACLE_BASE>\cfgtoollogs\sqlpatch\sqlpatch_9208_2018_05_14_14_31_00/sqlpatch_catcon_*.log files for output generated by scripts
catcon: See <ORACLE_BASE>\cfgtoollogs\sqlpatch\sqlpatch_9208_2018_05_14_14_31_00/sqlpatch_catcon__*.lst files for spool files, if any
Bootstrapping registry and package to current versions...done
verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table

OR

SQL> select * from OPATCH_XML_INV ;
ERROR:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-25153: Temporary Tablespace is Empty  

 

Symptoms 18


qopatch_log.log shows followign errors:

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: Error 0

KUP-04017: OS message: couldn't set locale correctly

couldn't set locale correctly

 

Symptoms 19

alert.log shows

 2018-12-23T08:01:37.336982+01:00
CJQ0 started with pid=40, OS id=61384
Completed: ALTER DATABASE OPEN
2018-12-23T08:01:43.251328+01:00
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 767
ORA-06512: at "SYS.DBMS_QOPATCH", line 846
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.DBMS_QOPATCH", line 841
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04095: preprocessor command <18.3 ORACLE_HOME>/QOpatch/qopiprep.bat encountered error "locale: Cannot set LC_CTYPE to default locale: No such file or directory
locale: Cannot set LC_MESSAGES to default locale: No such file or directory
locale: Can"
ORA-06512: at "SYS.DBMS_QOPATCH", line 832
ORA-06512: at "SYS.DBMS_QOPATCH", line 2101
ORA-06512: at "SYS.DBMS_QOPATCH", line 730
ORA-06512: at "SYS.DBMS_QOPATCH", line 2124

 

select * from "SYS"."OPATCH_XML_INV";

*
ERROR:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04095: preprocessor command <$ORACLE_HOME>/QOpatch/qopiprep.bat encountered error "couldn't set locale
correctly
couldn't set locale correctly
couldn't set locale correctly
couldn't set locale correctly

 

Symptoms 20

qopatch_log.log file

KUP-04004: error while reading file <12c ORACLE_HOME>/QOpatch/qopiprep.bat
KUP-04017: OS message: Error 0
KUP-04017: OS message: Java HotSpot(TM) 64-Bit Server VM warning: Insufficient space for shared memory file:  25463
Try using the -Djava.io.tmpdir= option to select an alternate tem
KUP-04118: operation "pipe read", location "skudmir"

Symptoms 21

qopatch_log.log file

    XML_INVENTORY                   CHAR (100000000)
     Terminated by "UIJSVTBOEIZBEFFQBL"
     Trim whitespace same as SQL Loader
KUP-04095: preprocessor command $ORACLE_HOME/QOpatch/qopiprep.bat encountered error "LsInventorySession failed: RawInventory gets null OracleHomeInfo

sqlpatch_invocation.log

verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table

Queryable inventory could not determine the current opatch status.
Execute 'select dbms_sqlpatch.verify_queryable_inventory from dual' and/or check the invocation log
$ORACLE_BASE/cfgtoollogs/sqlpatch/sqlpatch_12145_2019_07_27_04_49_22/sqlpatch_invocation.log for the complete error.
Prereq check failed, exiting without installing any patches

Symptoms 22

 SQL>  select * from OPATCH_XML_INV ;
ERROR:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04095: preprocessor command
/u01/app/oracle/product/19.0.0/dbhome_1/QOpatch/qopiprep.bat encountered error
"/u01/app/oracle/product/19.0.0/dbhome_1/OPatch/opatch: line 840: [: too many arguments
/u01/app/oracle/product/19.0.0/dbhome_1/OPatch/opatch: line 840: [: too m"

in qopatch_log.log

KUP-04004: error while reading file <ORACLE_HOME>/QOpatch/qopiprep.bat
KUP-04017: OS message: Error 0
KUP-04017: OS message: java.lang.UnsatisfiedLinkError: Can't load library: <ORACLE_HOME>/oui/lib/linux/liboraInstaller.so
at java.lang.ClassLoader.loadLibrary(Class
KUP-04118: operation "pipe read", location "skudmir"

 

Symptoms 23

KUP-04095: preprocessor command $ORACLE_HOME/QOpatch/qopiprep.bat encountered error "pipe read timeout"
KUP-04017: OS message: No such file or directory
KUP-04017: OS message: pipe read timeout
KUP-04118: operation "pipe read timeout", location "skudmir:2"

 

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.