Enter value for Report_name:
Using the report name awrrpt_1_591_593.html
Select Output from table (dbms_workload_repository.awr_report_html (:d bid,
*
ERROR at line 1:
Ora-04063:package Body "SYS. Dbms_workload_repository "has errors
Report written to awrrpt_1_591_593.html
To view invalid objects:
Dbms_swrf_report_internal and dbms_workload_repository are not valid
Attempt to compile Dbms_workload_repository, Error: Object dbms_swrf_report_internal invalid
Attempt to compile dbms_swrf_report_internal error:
pls-00753:malformed or corrupted wrapped unit
Dbms_swrf_report_internal
Use the following command to view the error code
$ sqlplus/as SYSDBA
Sql>set Serveroutput on
Sql> alter package dbms_swrf_report_internal compile;
Sql>show Error
Sql> ALTER package dbms_swrf_report_internal compile body;
Sql>show Error
Sql> alter package dbms_workload_repository compile;
Sql> ALTER package dbms_workload_repository compile body;
Sql>show Error
To find the relevant information, use the following SQL repair package
$sqlplus "/as sysdba"
Sql> @?/rdbms/admin/catawrtb.sql
Sql> @?/rdbms/admin/dbmsawr.sql
Sql> @?/rdbms/admin/prvtawr.plb
Sql> @?/rdbms/admin/utlrp.sql
Sql> @?/rdbms/admin/awrrpt.sql
--if error still exists, please restart the database and try again ....
sql> shutdown Immediate
Sql> Startup
Sql> @?/rdbms/admin/awrrpt.sql
Test environment Test Passed
is also being tested in the formal environment:
Using the report name awrrpt_1_52549_52550.html
Select Output from table (dbms_workload_repository.awr_report_html (:d bid,
*
ERROR at line 1:
Ora-04045:errors during recompilation/revalidation of SYS. Dbms_swrf_report_internal
Ora-04030:out of process memory when trying to allocate 4120 bytes (PLS non-lib hp,pdz2m87_allocate_permanent)
Ora-06508:pl/sql:could not the Find program unit being called: "SYS. Dbms_swrf_report_internal "
Ora-06512:at "SYS. Dbms_workload_repository ", line 309
Ora-06512:at Line 1
Report written to awrrpt_1_52549_52550.html
Investigation:
According to the document
Diagnosing and resolving ORA-4030 Errors (document ID 233869.1) troubleshooting
Oracle recommends rebuilding the AWR library:
How to recreate the AWR (AUTOMATIC WORKLOAD) Repository? (Document ID 782974.1)
But the action is too big to be tested in the product environment
oracle10g using $oracle_home/rdbms/admin/awrrpt.sql Error
