Import for Replay getting Ora-20222: Capture's AWR Already Exists Cannot Import Again
(Doc ID 887394.1)
Last updated on NOVEMBER 26, 2019
Applies to:Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.
This problem can occur on any platform.
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 22.214.171.124. 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document