OraFAQ Forum: Performance Tuning » PLS-00201: identifier 'DBMS_AWR.ENABLE

Home » RDBMS Server » Performance Tuning » PLS-00201: identifier 'DBMS_AWR.ENABLE_AWR' must be declared (Oracle 11.2.0.4 / Solaris 11)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PLS-00201: identifier 'DBMS_AWR.ENABLE_AWR' must be declared [message #663394]

Thu, 01 June 2017 17:48

SamuelJk
Messages: 25
Registered: August 2007

Junior Member

Hi team,

While executing exec dbms_awr.enable_awr(); in sys user
Getting below error.

PLS-00201: identifier 'DBMS_AWR.ENABLE_AWR' must be declared

Please let me know any script execution will resolve the issue ?

Regards
Samuel.

Report message to a moderator

Re: PLS-00201: identifier 'DBMS_AWR.ENABLE_AWR' must be declared [message #663395 is a reply to message #663394]

Thu, 01 June 2017 18:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SamuelJk wrote on Thu, 01 June 2017 15:48

Hi team,

While executing exec dbms_awr.enable_awr(); in sys user
Getting below error.

PLS-00201: identifier 'DBMS_AWR.ENABLE_AWR' must be declared

Please let me know any script execution will resolve the issue ?

Regards
Samuel.

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

SQL> select owner from dba_objects where object_name = 'DBMS_AWR';

no rows selected

SQL> DESC DBMS_AWR
ERROR:
ORA-04043: object DBMS_AWR does not exist

is it only a figment of your imagination?

Report message to a moderator