:

ORA-20105: unable to move AWR data to SYS

Oracle Version: 10.2.0.4 & 11.2.0.2

Platform: Windows Server 2003 R2

The Problem

I had exported some AWR snapshots from my production DB using the $ORACLE_HOME\RDBMS\ADMIN\awrextr.sql script. This generates a dump file which can then be imported into another DB and the AWR snapshots used for comparison. I copied the dump file across to my DEV system, which was in fact a clone of the PROD DB. I attempted to import the AWR snapshots using $ORACLE_HOME\RDBMS\ADMIN\awrload.sql and then I received the error below:

ERROR at line 1:
*
ORA-20105: unable to move AWR data to SYS
ORA-06512: at "SYS.DBMS_SWRF_INTERNAL", line 2945
ORA-20107: not allowed to move AWR data for local dbid
ORA-06512: at line 3

The Cause

It seemed as though it was importing the data based on the import log file, but it was not moving the data from the staging schema to the SYS schema – this is the way that the script works.

The Solution

I had to change the DB ID in order to get this working. You can use the NID utility to do this. Once complete, re-import using the AWRLOAD.sql script and everything should be in order.

SET ORACLE_SID=<SID>
NID TARGET=SYS

Like it, share it...

Category: AWR


Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *