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.

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s