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