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

Last updated on FEBRUARY 07, 2013

Applies to:

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

Symptoms

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;

STATUS    OBJECT_ID  OBJECT_TYPE          OWNER.OBJECT
--------- ---------- -------------------- --------------------------------------------------
INVALID        12013 PACKAGE BODY         SYS.KUPD$DATA

2. CATPROC component is invalid in database registry:

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

COMP_ID      VERSION         STATUS     COMP_NAMEy
------------ --------------- ---------- ----------------------------------------
OWB          11.2.0.3.0      VALID      OWB
APEX         3.2.1.00.12     VALID      Oracle Application Express
EM           11.2.0.3.0      VALID      Oracle Enterprise Manager
AMD          11.2.0.3.0      VALID      OLAP Catalog
SDO          11.2.0.3.0      VALID      Spatial
ORDIM        11.2.0.3.0      VALID      Oracle Multimedia
XDB          11.2.0.3.0      VALID      Oracle XML Database
CONTEXT      11.2.0.3.0      VALID      Oracle Text
EXF          11.2.0.3.0      VALID      Oracle Expression Filter
RUL          11.2.0.3.0      VALID      Oracle Rules Manager
OWM          11.2.0.3.0      VALID      Oracle Workspace Manager
CATALOG      11.2.0.3.0      VALID      Oracle Database Catalog Views
CATPROC      11.2.0.3.0      INVALID    Oracle Database Packages and Types
JAVAVM       11.2.0.3.0      VALID      JServer JAVA Virtual Machine
XML          11.2.0.3.0      VALID      Oracle XDK
CATJAVA      11.2.0.3.0      VALID      Oracle Database Java Packages
APS          11.2.0.3.0      VALID      OLAP Analytic Workspace
XOQ          11.2.0.3.0      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

Changes

Patch bundle 15 for Windows was applied on top of 11.2.0.3.

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

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