Running awrgrpti.sql as a Non-sysdba User Fails with ORA-6550, PLS-00201. Due to Missing Privileges (Doc ID 1388001.1)

Last updated on MARCH 06, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

When running, awrgrpti.sql "Workload Repository RAC (Global) Report", as a non-SYSDBA user (which has been granted the SELECT_CATALOG_ROLE role), the awrginp.sql script (that it calls to setup the  bind variables needed to call the later PL/SQL procedures)  fails with the following errors while assigning the "insts" variable to the "AWRRPT_INSTANCE_LIST_TYPE" datatype:

  insts AWRRPT_INSTANCE_LIST_TYPE;
        *

ERROR at line 15:
ORA-06550: line 15, column 11:
PLS-00201: identifier 'AWRRPT_INSTANCE_LIST_TYPE' must be declared
ORA-06550: line 15, column 11:
PL/SQL: Item ignored
ORA-06550: line 47, column 24:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 48, column 4:
PL/SQL: ORA-00904: : invalid identifier
ORA-06550: line 46, column 4:
PL/SQL: SQL Statement ignored

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