ORA-13516 AWR Operation failed: SWRF Schema not initialized

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.