This discussion is archived
0 Replies Latest reply: Oct 8, 2013 1:00 PM by a3c80855-4cf6-4dad-b682-a358b636d701 RSS

Object DBMS_WORKLOAD_CAPTURE compilation error

a3c80855-4cf6-4dad-b682-a358b636d701 Newbie
Currently Being Moderated

Hi guys,

 

After upgrading an ORACLE database to 11.2.0.3 for Windows, i got two objects with INVALID Status

 

DBMS_WORKLOAD_CAPTURE

DBMS_WORKLOAD_REPLAY

 

 

The only error during Upgrade was mentioned onMOS Note 1465852.1 “ORA-00942 reports during upgrade to 11.2.0.3 using manual or DBUA”

 

 

 

 

I understand *this bug affects only Oracle 11.2.0.3 for Windows and only if Patch

bundle is installed before the upgrade. That was exactly my scenario, not sure if this is related to the actual warning.

 

 

 

<br>

 

 

When submitting script post_upgrade_status.sql it mentions as a warning


There are invalid objects in the SYS Schema.

 

Tried to compile them but no luck


SQL> ALTER PACKAGE DBMS_WORKLOAD_CAPTURE compile body
  2  ;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY DBMS_WORKLOAD_CAPTURE:

LINE/COL ERROR
-------- -----------------------------------------------------------------
475/17   PL/SQL: Item ignored
475/61   PLS-00302: component 'FALSE_I' must be declared
483/7    PL/SQL: Statement ignored
483/7    PLS-00320: the declaration of the type of this expression is
         incomplete or malformed

486/5    PL/SQL: Statement ignored
487/63   PLS-00320: the declaration of the type of this expression is
         incomplete or malformed

SQL> ALTER PACKAGE DBMS_WORKLOAD_CAPTURE compile body

 

Any hint how to fix this error?


Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points