My Oracle Support Banner

Invalid SYS.KUPD$DATA Package After Applying Patch Bundle 15 On Top of (Doc ID 1526705.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2]
Microsoft Windows x64 (64-bit) - OS Version: 7


1. SYS.KUPD$DATA package is invalid:

SQL> SELECT status, object_id, object_type, owner||'.'||object_name "OWNER.OBJECT" FROM dba_objects WHERE stat
us != 'VALID' AND object_name NOT LIKE 'BIN$%' ORDER BY 4,2;

--------- ---------- -------------------- --------------------------------------------------

2. CATPROC component is invalid in database registry:

SQL> SELECT comp_id, version, status, SUBSTR(comp_name,1,35) COMP_NAME FROM dba_registry;

------------ --------------- ---------- ----------------------------------------
OWB      VALID      OWB
APEX     VALID      Oracle Application Express
EM       VALID      Oracle Enterprise Manager
AMD      VALID      OLAP Catalog
SDO      VALID      Spatial
ORDIM      VALID      Oracle Multimedia
XDB      VALID      Oracle XML Database
CONTEXT      VALID      Oracle Text
EXF      VALID      Oracle Expression Filter
RUL      VALID      Oracle Rules Manager
OWM      VALID      Oracle Workspace Manager
CATALOG      VALID      Oracle Database Catalog Views
CATPROC      INVALID    Oracle Database Packages and Types
JAVAVM      VALID      JServer JAVA Virtual Machine
XML      VALID      Oracle XDK
CATJAVA      VALID      Oracle Database Java Packages
APS      VALID      OLAP Analytic Workspace
XOQ      VALID      Oracle OLAP API

3. DataPump export fails with:

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.MOVE_DATA [TABLE_DATA:"SCOTT"."DEPT"]
ORA-04063: package body "SYS.KUPD$DATA" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.KUPD$DATA"

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9001

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
000007FF396A2370     20462  package body SYS.KUPW$WORKER
000007FF396A2370      9028  package body SYS.KUPW$WORKER
000007FF396A2370     15498  package body SYS.KUPW$WORKER
000007FF396A2370      3145  package body SYS.KUPW$WORKER
000007FF396A2370      9711  package body SYS.KUPW$WORKER
000007FF396A2370      1775  package body SYS.KUPW$WORKER
000007FF39DB8B30         2  anonymous block


Patch bundle 15 for Windows was applied on top of

catwinbundle.sql and utlrp.sql scripts were run as part of post patch installation steps.


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.