ORA-00904 When Run Any AWR or ASH Reports From SQL Developer
(Doc ID 2518648.1)
Last updated on MAY 02, 2023
Applies to:
Oracle SQL Developer - Version 18.1 and laterInformation 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
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 |