EM 12c: Deploying ASH Analytic Package in Enterprise Manager 12c Cloud Control Gives PLS-00201 Error (Doc ID 2063567.1)

Last updated on OCTOBER 12, 2015

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.3.0 and later
Information in this document applies to any platform.

Symptoms

Navigate: Targets > Databases > [select target instance] > [Performance pull down menu] > Ash Analytics

Deploying the ASH Analytic package in EM 12c Cloud Control fails with this error:

Error while executing the script : oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: Error creating PL/SQL Object PRVT_AWR_DATA : PACKAGE BODY - PLS-00201: identifier 'DBSNMP.ASHVIEWER' must be declared
Error creating PL/SQL Object PRVT_AWR_DATA : PACKAGE BODY - PL/SQL: Statement ignored
 at line number - 2580
Driver SQL Script encountered errors.
Fail

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