My Oracle Support Banner

datapatch fails with errors:"ORA-31011","qopiprep.bat[42]: no space" (Doc ID 2377994.1)

Last updated on FEBRUARY 14, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
IBM AIX on POWER Systems (64-bit)


datapatch with errors as below:

SQL Patching tool version Production on Sun Feb 11 09:55:01 2018
Copyright (c) 2012, 2017, Oracle. All rights reserved.

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' and/or check the invocation log
<Location>/sqlpatch_invocation.log for the complete error.



SQL> select dbms_sqlpatch.verify_queryable_inventory from dual;

ORA-31011: XML parsing failed
ORA-19213: error occurred in XML processing at lines 1
LPX-00225: end-element tag "patchActions" does not match start-element tag ""
ORA-06512: at "SYS.XMLTYPE", line 272
ORA-06512: at line 1


SQL> select * from OPATCH_XML_INV ;

ORA-29913: error in executing

ORA-29400: data cartridge error

KUP-04095: preprocessor command

encountered error
"$ORACLE_HOME/QOpatch/qopiprep.bat[41]: no space"
no rows selected



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

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