My Oracle Support Banner

ORA-00904 When Run Any AWR or ASH Reports From SQL Developer (Doc ID 2518648.1)

Last updated on APRIL 28, 2020

Applies to:

Oracle SQL Developer - Version 18.1 and later
Information in this document applies to any platform.

Symptoms

When attempt to run any AWR or ASH reports from SQL Developer 18.x, you get the following error:

An error was encountered performing the requested operation:

ORA-00904: "DBMS_WORKLOAD_REPOSITORY"."AWR_SQL_REPORT_HTML": invalid identifier
00904. 00000 -  "%s: invalid identifier"
*Cause:    
*Action:
Vendor code 904

 
However, you can access the database to run queries using other SQL commands. The problem is only when you try to access DBA functions such as AWR or ASH. You already verified that you have Oracle Diagnostics Pack to run the AWR or ASH report.

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
References


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