Import for Replay getting Ora-20222: Capture's AWR Already Exists Cannot Import Again (Doc ID 887394.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.7
This problem can occur on any platform.

Symptoms

The Database, through Enterprise Manager, is getting the following errors:

Request Start Date Sep 12, 2009 10:23:41 PM +00:00
Actual Start Date Sep 12, 2009 10:23:41 PM +00:00
Error # 20222
Run Duration (minutes) 0.0
CPU Used (seconds) 0.0
Instance ID 1
Session ID 1837,3647
Process ID 7710

Details ORA-20222: Capture's AWR already exists in the current database. Cannot
import again! ORA-06512: at "SYS.DBMS_WORKLOAD_CAPTURE", line 1506 ORA-06512:
at line 1

This error happened in EM (Enterprise Manager) when trying to replay a 10.2.0.4 workload on the database copy after an upgrade to 11.1.0.7.  When trying to create the Compare Report, EM requested for the import of the Capture AWR.  The first import of this Capture AWR failed because the tablespace ran out of space.  After fixing that problem, when trying to re-run the import you get the above error.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms