My Oracle Support Banner

12.1: ORA-20001: Latest Xml Inventory Is Not Loaded Into Table, KUP-04017: OS message: Picked up _JAVA_OPTIONS: (Doc ID 2172655.1)

Last updated on JULY 26, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

While executing datapatch the following error message is displayed :

Connecting to database...OK
Bootstrapping registry and package to current versions...done
Queryable inventory could not determine the current opatch status.
Execute 'select dbms_sqlpatch.verify_queryable_inventory from dual'

 

SQL> select dbms_sqlpatch.verify_queryable_inventory from dual;
VERIFY_QUERYABLE_INVENTORY
--------------------------------------------------------------------------------
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-04004: error while reading file
/oracledb_dev/product/12.1.0/QOpatch/qopiprep.bat

  

$ORACLE_HOME/QOpatch/qopatch_log.log  shows:


KUP-04004: error while reading file $ORACLE_HOME/QOpatch/qopiprep.bat
KUP-04017: OS message: Error 0
KUP-04017: OS message: Picked up _JAVA_OPTIONS: -Xms256m -Xmx512m
Picked up _JAVA_OPTIONS: -Xms256m -Xmx512m
KUP-04118: operation "pipe read", location "skudmir"

or

 KUP-04004: error while reading file $ORACLE_HOME/QOpatch/qopiprep.bat
 KUP-04017: OS message: Error 0
 KUP-04017: OS message: Picked up _JAVA_OPTIONS:
 KUP-04118: operation "pipe read", location "skudmir:2"

  

 

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
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.