My Oracle Support Banner

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

Last updated on JANUARY 08, 2020

Applies to:

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

Symptoms

datapatch with errors as below:

datapatch
SQL Patching tool version 12.1.0.2.0 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;

VERIFY_QUERYABLE_INVENTORY
--------------------------------------------------------------------------------
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 ;
ERROR:

ORA-29913: error in executing
ODCIEXTTABLEFETCH callout

ORA-29400: data cartridge error

KUP-04095: preprocessor command
$ORACLE_HOME/QOpatch/qopiprep.bat

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

 

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.