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.