My Oracle Support Banner

Executing "Deploy Database Management PL/SQL Packages" In 12C Fails With "ORA-01031: insufficient privileges" (Doc ID 1365404.1)

Last updated on JANUARY 30, 2022

Applies to:

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

Symptoms

When executing "Deploy Database Management PL/SQL Packages" in 12C Cloud Control fails with following error:

Currently executing <Middleware_Home>/plugins/oracle.sysman.db.oms.plugin_12.1.0.0.0/sql/db/latest/instance/prvs_awr_data.sql :: DECLARE
  obj_not_found EXCEPTION;
  PRAGMA EXCEPTION_INIT(obj_not_found, -4043);
BEGIN  
  BEGIN
    execute immediate 'DROP PACKAGE prvt_awr_data';
    EXCEPTION WHEN obj_not_found THEN NULL;    
  END; 
.
.
END;
Error while executing the script : oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges at line number - 74

Driver SQL Script encountered errors.
Fail

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


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