Queryable Patch Inventory - Issues/Solutions for ORA-20001: Latest xml inventory is not loaded into table (Doc ID 1602089.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

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.

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

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"

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"

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"

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

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

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"

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"

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'

 

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

ORA-01691: unable to extend lob segment SYS.SYS_LOB0000022515C00008$$ by 27309 in tablespace SYSTEM

 

 

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

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"

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 "

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.

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"

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.

[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

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

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"

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"

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

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

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

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

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

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"

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

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

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"

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"

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"

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

SQL> select * from OPATCH_XML_INV;
ERROR:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04095: preprocessor command
/u01/OracleDB/product/19.3.0.0/dbhome_1/QOpatch/qopiprep.bat encountered error
"Error: This Java instance does not support a 64-bit JVM.Please install the desired version."

XML_INVENTORY CHAR (100000000)
Terminated by "UIJSVTBOEIZBEFFQBL"
Trim whitespace same as SQL Loader
KUP-04095: preprocessor command /u01/OracleDB/product/19.3.0.0/dbhome_1/QOpatch/qopiprep.bat encountered error "Error: This Java instance does not support a 64-bit JVM.Please install the desired version."

ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-01157: cannot identify/lock data file 202 - see DBWR trace file

Connecting to database...OK
Gathering database info...done
Error: prereq checks failed!
verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table
Prereq check failed, exiting without installing any patches.

QPI: Caught error while querying opatch_xml_inv
QPI: in REFRESH_OPATCH_DATA, ERROR code -29913 : ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-27102: out of memory
IBM AIX RISC System/6000 Error: 12: Not enough

QPI: in REFRESH_OPATCH_DATA, ERROR code -29913 : ORA-29913: error in executing ODCIEXTTABLEFETCH callout

ORA-27102: out of memory

IBM AIX RISC System/6000 Error: 12: Not enough

QPI: Releasing lock SUCCESSFUL, qp_result=0 at : 03-JAN-23 01.28.47.263315000 AM -04:00

QPI: Releasing lock FAILED, qp_result=4 at : 03-JAN-23 01.28.47.263495000 AM -04:00

QPI: in get_pending_activity, ERROR code -20001 : ORA-20001: Latest xml inventory is not loaded into table

QPI: org_node and inst resore 2::

KUP-04095: preprocessor command /ora/sys01/app/oracle/product/19300/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"

Error: prereq checks failed!
verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table

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
"en_US.utf8: unknown locale"

Error: prereq checks failed! verify_queryable_inventory returned
ORA-20001: Latest xml inventory is not loaded into table Prereq check failed, exiting without installing any patches

KUP-04095: preprocessor command C:\Oracle\product\19.16.0.0\db_home\QOpatch\qopiprep.bat encountered error "'ID' is not recognized as an internal or external command,

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
"'ID' is not recognized as an internal or external command,
operable program or batch file.

Bootstrapping registry and package to current versions...done
Error: prereq checks failed!
verify_queryable_inventory returned ORA-20001: Latest xml inventory is not loaded into table
Prereq check failed, exiting without installing any patches.

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 "[dd.trace <date> <time> -0400] [dd-telemetry] WARN
datadog.telemetry.TelemetryRouter - Got FAILURE sending telemetry request to
http://localhost:8126/"