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

Last updated on AUGUST 06, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
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



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
/u00/u11/oracle/find/db/tech_st/12.1.0.2/QOpatch/qopatch_log.log

 

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
/opt/app/oracle/product/12.1.0/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"

  

Symptoms 5

KUP-04004: error while reading file /export/oracle/12.1.0.2/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 /s31/app/oracle/product/12.1.0/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 /local/app/oracle/product/12.1.0.2b/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: '/oracle12/base/DATM/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 /opt/oracle/product/12.1.0.2/db_1/QOpatch/qopiprep.bat
KUP-04017: OS message: Error 0
KUP-04017: OS message: /opt/oracle/product/12.1.0.2/db_1/QOpatch/qopiprep.bat: line 38: /opt/oracle/product/12.1.0.2/db_1/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 /u01/app/oracle/product/12.1.0/db_2/QOpatch/qopiprep.bat
KUP-04017: OS message: Error 0
KUP-04017: OS message: Argument(s) Error... Cannot use file "/u01/app/oracle/product/12.1.0/db_2/QOpatch/xml_file.xml" to generate XML output.
Specify path/filename and make sure file
KUP-04118: operation "pipe read", location "skudmir"

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                                        

 

Changes

 

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