ORA-13516 AWR Operation failed: SWRF Schema not initialized
ERROR
While executing the following command will give us the following error:
exec dbms_workload_repository.create_snapshot;
OR
exec dbms_workload_repository.modify_snapshot_settings(interval=>10);
BEGIN dbms_workload_repository.modify_snapshot_settings(interval=>10); END;
ERROR at line 1:
ORA-13516: AWR Operation failed: SWRF Schema not initialized
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 85
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 133
ORA-06512: at line 1
Cause
May repository is incorrectly initialized or may have invalid objects in the AWR Schema.
Solution
1. Run the UTLRP utility to compile all the invalid objects, then try again the upper command.
@?\rdbms\admin\utlrp.sql
2. If it not fixed in first step, then you need to recreate the AWR objects or repository.
For Reconfigure AWR: Please click on link: Recreate AWR Repository
