Subscriber Count

    459

Subscribe to Posts by Email

Pages

AWR Report – Error ORA-13605: The specified task or object does not exist for the current user.

When you run the awr report with non privileged user i.e custom user (even with dba privilege) you may receive the following error.

@?/rdbms/admin/awrrpt.sql

ORA-13605: The specified task or object  does not exist for the current user.

Error encountered in special section 99995

The possible cases are,

  • missing grant on sys.dbms_advisor
  • bug 17588463 -- found reference to where tasks are stored in table WRI$_ADV_TASKS

Our case is resolved when we granted the following privilege.

GRANT ADMINISTER ANY SQL TUNING SET TO <user>;

Update: 16-Feb-2017 (Thanks Vasu)

The issue still reports, but the following patch is permanent fix.

.(Bug 25059420: Schemas with Non-SYSDBA Privileges Get ORA-13605 in AWR Reports)

Patch ## 25105847 

Patch 25105847: ORA-13605 IN ADDM SECTION OF AWR REPORT FOR DBA USER

Hope this helps

-Thanks

Geek DBA

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>