My Oracle Support Banner

RAT - Pre-processing DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE fails with ORA-00001 and ORA-06512 (Doc ID 2780525.1)

Last updated on OCTOBER 10, 2022

Applies to:

Enterprise Manager for Oracle Database - Version 13.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

 RAT Pre-processing DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE fails with ORA-00001 and ORA-06512

SQL> exec DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE (capture_dir => 'Capture_dir');
BEGIN DBMS_WORKLOAD_REPLAY.PROCESS_CAPTURE (capture_dir => 'Capture_dir'); END;

*
ERROR at line 1:
ORA-00001: unique constraint (SYS.WRR$_REPLAY_LOGIN_QUEUE_PK) violated
ORA-06512: at "SYS.DBMS_WORKLOAD_REPLAY_I", line 3110
ORA-06512: at "SYS.DBMS_WORKLOAD_REPLAY_I", line 2292
ORA-06512: at "SYS.DBMS_WORKLOAD_REPLAY_I", line 2789
ORA-06512: at "SYS.DBMS_WORKLOAD_REPLAY_I", line 3080
ORA-06512: at "SYS.DBMS_WORKLOAD_REPLAY", line 12
ORA-06512: at line 1

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.