用于生成AWR的用户必须没有DBMS_WORKLOAD_REPOSITORY包的执行权限。
引用Oracle文档，
..要调用这些过程，必须授予用户DBA角色。
下面是生成AWR所需的GRANTS列表

GRANT SELECT ON SYS.V_$DATABASE TO MY_USER;

GRANT SELECT ON SYS.V_$INSTANCE TO MY_USER;

GRANT EXECUTE ON SYS.DBMS_WORKLOAD_REPOSITORY TO MY_USER;

GRANT SELECT ON SYS.DBA_HIST_DATABASE_INSTANCE TO MY_USER;

GRANT SELECT ON SYS.DBA_HIST_SNAPSHOT TO MY_USER;

GRANT ADVISOR TO MY_USER;

我发现Oracle 18c也会引发同样的错误，而且我是以sys和sysdba角色连接的。

连接器/AS系统数据库
SQL〉@$ORACLE_HOME/关系数据库管理系统/管理员/awrrpt. sql
指定报告类型

AWR reports can be generated in the following formats. Please enter the
name of the format at the prompt. Default value is 'html'.

'html' HTML format (default)
'text' Text format
'active-html' Includes Performance Hub active report

Enter value for report_type:
old 1: select 'Type Specified: ',lower(nvl('&&report_type','html')) report_type from dual
new 1: select 'Type Specified: ',lower(nvl('','html')) report_type from dual

Type Specified: html

old 1: select '&&report_type' report_type_def from dual
new 1: select 'html' report_type_def from dual


old 1: select '&&view_loc' view_loc_def from dual
new 1: select 'AWR_PDB' view_loc_def from dual