EM 13: Deployment ASH Analytics package Fails: OMC_ASH_VIEWER : PACKAGE BODY - PLS-00201: identifier 'SYS.DBMS_SQL' must be declared (Doc ID 2912033.1)

Last updated on NOVEMBER 28, 2022

Applies to:

Symptoms

ASH Analytics and SQL Monitoring package deployment failing with 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 'SYS.DBMS_SQL' 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_SQL' 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_SQL' 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_SQL' must be declared

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.