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

Last updated on AUGUST 30, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
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 /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

 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

 

Cause

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 hundreds of Community platforms