Home » RDBMS Server » Performance Tuning » PLS-00201: identifier 'DBMS_AWR.ENABLE_AWR' must be declared (Oracle 11.2.0.4 / Solaris 11)
PLS-00201: identifier 'DBMS_AWR.ENABLE_AWR' must be declared [message #663394] Thu, 01 June 2017 17:48 Go to next message
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.
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 Go to previous messageGo to next message
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?
Re: PLS-00201: identifier 'DBMS_AWR.ENABLE_AWR' must be declared [message #663396 is a reply to message #663395] Thu, 01 June 2017 18:52 Go to previous messageGo to next message
SamuelJk
Messages: 25
Registered: August 2007
Junior Member
Yes, This package not available in dba_objects.
Re: PLS-00201: identifier 'DBMS_AWR.ENABLE_AWR' must be declared [message #663397 is a reply to message #663396] Thu, 01 June 2017 18:54 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
SamuelJk wrote on Thu, 01 June 2017 16:52
Yes, This package not available in dba_objects.
How can you invoke code that does NOT exist?

post URL to Oracle documentation that discusses DBMS_AWR.AWR_ENABLE()
Previous Topic: Same query runs way better in 10g than in 12c
Next Topic: query issue with execute immediate
Goto Forum:
  


Current Time: Thu Mar 28 20:18:56 CDT 2024