EM 12c: Recompiling Invalid Objects of SYSMAN_MDS and SYSMAN_RO Fails with PLS-00201: identifier 'DBMS_LOB' must be declared (Doc ID 1550850.1)

Last updated on DECEMBER 02, 2014

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.2.0 and later
Information in this document applies to any platform.

Symptoms

EM 12c Repository has the following invalid objects:

SQL> select object_name, object_type, owner from dba_objects where status = 'INVALID';

OBJECT_NAME                      OBJECT_TYPE        OWNER

DERIVED_ASSOC_SANDBOX PACKAGE BODY    SYSMAN_RO
MDS_INTERNAL_SHREDDED  PACKAGE BODY    SYSMAN_MDS

Recompiling these invalid objects using following statements fails with errors:

SQL> alter package sysman_ro.DERIVED_ASSOC_SANDBOX compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors;
Errors for PACKAGE BODY SYSMAN_RO.DERIVED_ASSOC_SANDBOX:

LINE/COL ERROR
-------- -----------------------------------------------------------------
92/5      PL/SQL: Statement ignored
92/42    PLS-00201: identifier 'DBMS_SQL' must be declared


SQL> alter package sysman_mds.MDS_INTERNAL_SHREDDED compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors;
Errors for PACKAGE BODY SYSMAN_MDS.MDS_INTERNAL_SHREDDED:

LINE/COL ERROR
-------- -----------------------------------------------------------------
187/5    PL/SQL: Statement ignored
187/5    PLS-00201: identifier 'DBMS_LOB' must be declared
195/5    PL/SQL: Statement ignored
195/19  PLS-00201: identifier 'DBMS_LOB' must be declared

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