My Oracle Support Banner

datapatch fails with Error:"ORA-20001","ORA-06502: PL/SQL:numeric or value error: string buffer too small","KUP-04095:opatch: line 839: [: too many arguments" (Doc ID 2714487.1)

Last updated on SEPTEMBER 05, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

datapatch fails with error:

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'

 or

Bootstrapping registry and package to current versions...done
Error: prereq checks failed!
verify_queryable_inventory returned ORA-06502: PL/SQL:numeric or value error: string buffer too small
Prereq check failed, exiting without installing any patches.

 

And following errors returned when executed following query:

SQL> select dbms_sqlpatch.verify_queryable_inventory from dual;

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

 or

SQL> select dbms_sqlpatch.verify_queryable_inventory from dual;

VERIFY_QUERYABLE_INVENTORY
ORA-06502: PL/SQL:numeric or value error: string buffer too small

 

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/OPatch/opatch: line 839: [:
too many arguments
$ORACLE_HOME/OPatch/opatch: line 839: [: t"



Changes

 

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