Object DBMS_WORKLOAD_CAPTURE compilation error

[former_member229542]

Hi guys,

After upgrading an ORACLE database to 11.2.0.3 for Windows Server 2008 64 bits, there are 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.

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?

[Reagan · Accepted solution]

Hello

Run this query to find the invalid objects.

select object_name from dba_objects where status='INVALID';

If there is any then execute this:

@?/rdbms/admin/utlrp.sql

Regards

RB

[former_member229542 · Accepted solution]

After implementing WinPatch 22 issues was fixed