Oracle 12c MultiTenent AWR Errors -ORA-20105 ORA-06512 ORA-20303

While testing, i wanted to create a manual AWR Report – so i ran the normal 11g scripts on the container DB (BTW, you cannot run it on the pluggable database !)

– $ORACLE_HOME/rdbms/admin/awrextr – no issues

BUT – $ORACLE_HOME/rdbms/admin/awrload

Issue #1 – To create a local user in the container – MUST USE C## before the AWR_STAGING USER (Cant accept the default)

Issue #2 – get the following error :

ERROR at line 1:

ORA-20105: unable to move AWR data to SYS

ORA-06512: at “SYS.DBMS_SWRF_INTERNAL”, line 4552

ORA-20303: Can not import snasphots because flushing is enabled

ORA-06512: at line 3

I opened an SR to find out how to resolve the errors – more news to come.

THe following is the Oracle bug document.