Installing the ASH Analytics package from OEM13 Errors 'PACKAGE BODY - PLS-00201: identifier 'DBMS_LOB' must be declared'
(Doc ID 2699059.1)
Last updated on JANUARY 17, 2023
Applies to:
Enterprise Manager for Oracle Database - Version 13.4.1.0.0 and laterInformation in this document applies to any platform.
Symptoms
- 13.4.1.0.0 version
- Trying to install the ASH Analytics package from OEM13 on a database with following errors:
Error while executing the script : oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: Error creating PL/SQL Object OMC_ASH_VIEWER : PACKAGE BODY - PLS-00201: identifier 'DBMS_LOB' must be declared
Error creating PL/SQL Object OMC_ASH_VIEWER : PACKAGE BODY - PL/SQL: Statement ignored
Error creating PL/SQL Object OMC_ASH_VIEWER : PACKAGE BODY - PLS-00201: identifier 'SYS.DBMS_LOB' must be declared
Error creating PL/SQL Object OMC_ASH_VIEWER : PACKAGE BODY - PL/SQL: Statement ignored
Error creating PL/SQL Object OMC_ASH_VIEWER : PACKAGE BODY - PLS-00201: identifier 'SYS.DBMS_LOB' must be declared
Error creating PL/SQL Object OMC_ASH_VIEWER : PACKAGE BODY - PL/SQL: Statement ignored
Error creating PL/SQL Object OMC_ASH_VIEWER : PACKAGE BODY - PLS-00201: identifier 'SYS.DBMS_LOB' must be declared
Error creating PL/SQL Object OMC_ASH_VIEWER : PACKAGE BODY - PL/SQL: Statement ignored
at line number - 5919
Driver SQL Script encountered errors.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |