Database Consultant (Passionate about Database & Cloud Technologies)

Database Architect,Core DBA ,APPSDBA,Mysql DBA,MongoDB,PostgreSQL,MariaDB,Installations,Upgrades on all Flavors of UNIX (LINUX,SOLARIS,HP(AIX)). Oracle E-Business Suite R12 (Upgrades,Patching,Cloning) AWS upgrades and implementation expert. OCI (Oracle Cloud Infrastructure) Architect, Exadata (Oracle Database Exadata Cloud at Customer(Exacc)),Superclusters ,Autonomous Databases, AWS RDS Customs , Sql Tuning Expert. ***Never Stop sharing,Learning and Growing***

Thursday, January 17, 2019

Internal Error Has Occurred' When Using Sql Advisory Through OEM

'There Was A Problem Tuning The SQL Statement: Internal Error Has Occurred'
When Using Sql Advisory Through OEM (Doc ID 2202842.1)

To Bottom

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Using Enterprise Manager console UI > DB target homepage > Performance > Top Activity > SQL tuning advisor
Enterprise Manager version is 12.1.0.5.0
During executing the job of "SQL tuning advisor", the following error is seen:

Cause

From "emoms.trc", the following error is seen:
--------------------------

2016-10-03 17:08:23,474 [Thread-12335531] ERROR sqlt.SqlTuningProcessBean logp.251 - java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_SCHEDULER' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

The user does not have DBMS_SCHEDULER privileges.

Solution

Grant DBMS_SCHEDULER privileges to the user:

"grant execute on DBMS_SCHEDULER TO username; "