"ORA-27486 insufficient privileges" Error When Running SQL Tuning Advisor (Doc ID 338930.1)

Last updated on NOVEMBER 18, 2013

Applies to:

Enterprise Manager for Oracle Database - Version 10.2.0.5 to 11.1.0.1 [Release 10.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 02-May-2012***
Checked for relevance on 18-Nov-2013

Symptoms

When trying to run the SQL Tuning Advisor via 10g Grid Control the following error is displayed.

There is a problem tuning the SQL Statement
ORA-27486 insufficient privileges ORA-06512 at SYS.DBMS_ISCHED , line 99 ORA-06512 at SYS.DBMS_SCHEDULER , line 262 ORA-06512 at line 1

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