POTENTIAL SOLUTION(S) for AWR Snapshot Error
============================================
(*) To take the snapshots we need to populate WRM$_SNAPSHOT table successfully and for that instance metadata should be present in WRM$_DATABASE_INSTANCE.
(*) To regenerate the AWR objects run catnoawr.sql and catawr.sql scripts from $ORACLE_HOME/rdbms/admin
(*) Then RESTART the database
So, if we have regenerated the AWR objects by running catnoawr.sql and catawr.sql, then we need to bounce the database. On restart of the database instance the WRM$_DATABASE_INSTANCE & Other internal objects will be populated with the required data. Then we can take manual snapshots and also MMON process will start collecting the snapshots.
Remember: If we are inserting manually into WRP$_DATABASE_INSTANCE, we are getting some errors while executing $ORACLE_HOME/rdbms/admin/awrrpt.
When we rename instance oracle still keeps the old hostname and old database information in WRM$_DATABASE_INSTANCE, so MMON might not be able to generate snapshot at specific interval. So its always needed to drop and re-generate AWR Objects when we are renaming database and instance name.
*) Then try generating the snapshots manually for testing purpose.
SQL> BEGIN
2 DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(‘TYPICAL’);
3 END;
4 /
POTENTIAL SOLUTION JUSTIFICATION(S)
==================================
Note 308003.1 AWR Snapshots Not Generating