My Oracle Support Banner

Datapatch Fails with Error: "ORA-04063" or "ORA-06508" or "ORA-29913 ,KUP-00600" (Doc ID 1948198.1)

Last updated on AUGUST 16, 2018

Applies to:

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
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

 Executing Post patch SQL Deployment Automation script:  " datapatch -verbose " , fails with error:

Connecting to database...OK
Determining current state...
Currently installed SQL Patches: 18522516
DBD::Oracle::st execute failed: ORA-04063: package body "SYS.DBMS_QOPATCH" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_QOPATCH"
ORA-06512: at line 4 (DBD ERROR: OCIStmtExecute) [for Statement "DECLARE
x XMLType;
BEGIN
x := dbms_qopatch.get_pending_activity;
? := x.getStringVal();
END;" with ParamValues: :p1=undef] at /oraappfs/oracle/db12101/sqlpatch/sqlpatch.pm line 1293.

or

Connecting to database...OK
catcon: ALL catcon-related output will be written to [/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_31782_2018_09_52_04_32_16/sqlpatch_catcon__catcon_31782.lst]
catcon: See [/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_31782_2018_09_52_04_32_16/sqlpatch_catcon_*.log] files for output generated by scripts
catcon: See [/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_31782_2018_09_52_04_32_16/sqlpatch_catcon__*.lst] files for spool files, if any
Bootstrapping registry and package to current versions...done
verify_queryable_inventory returned ORA-06508: PL/SQL: could not find program unit being called

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-06508: PL/SQL: could not find program unit being called

or

Connecting to database...OK
catcon: ALL catcon-related output will be written to /orainst/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_53150146_2016_05_09_21_37_14/sqlpatch_catcon__catcon_53150146.lst
catcon: See /orainst/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_53150146_2016_05_09_21_37_14/sqlpatch_catcon_*.log files for output generated by scripts
catcon: See /orainst/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_53150146_2016_05_09_21_37_14/sqlpatch_catcon__*.lst files for spool files, if any
Bootstrapping registry and package to current versions...done
DBD::Oracle::db selectrow_array failed:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
KUP-00600: internal error, arguments [kudmpgnc:badbl] [0] [] [] [] (DBD ERROR: error possibly near <*> indicator at char 7 in 'SELECT <*>dbms_sqlpatch.verify_queryable_inventory FROM dual') [for Statement "SELECT dbms_sqlpatch.verify_queryable_inventory FROM dual"] at

trace file shows:
========= Dump for incident 22759 (KUP 600) ========

*** 2018-07-30T01:05:00.346613+00:00
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0) [TOC00003]
----- Current SQL Statement for this session (sql_id=2jx5azp04ywc6) -----
/* SQL Analyze(435,2) */ SELECT /*+ NOPARALLEL */ * FROM "SYS"."OPATCH_XML_INV" [TOC00004]

 or

SQL> select * from OPATCH_XML_INV;
ERROR:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "identifier": expecting one of: "column,
disable_directory_link_check, fields, file_format, logfile, nologfile,
preprocessor, readsize, records"
KUP-01008: the bad identifier was: ┐┐┐┐┐┐┐┐┐┐
KUP-01007: at line 1 column 1

 

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!


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