Error ORA-23621 When Calling DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS (Doc ID 456680.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.

Symptoms

In a bidirectional Streams setup you get the following stack error when calling DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS:

 



SQL>Begin
2 DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS (
3 schema_names => 'stream_usr',
4 source_directory_object =>'expdir',
5 destination_directory_object => 'impdir',
6 source_database => 'SRC_DB',
7 destination_database =>'DEST_DB',
8 capture_queue_table => 'cap1_qt',
9 capture_queue_name => 'cap1_q_name',
10 apply_queue_table => 'apply1_qt',
11 apply_queue_name => 'apply1_q_name',
12 capture_name => 'cap1_cip',
13 propagation_name => 'prop1_cip',
14 APPLY_NAME => 'apply1_cip',
15 include_ddl => true,
16 bi_directional => true);
17 end;
18 /
Begin
*
ERROR at line 1:
ORA-23621: Operation corresponding to script 34ACEFADB2C070D3E044000000000000 is in progress.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_STREAMS_MT", line 2328
ORA-06512: at "SYS.DBMS_STREAMS_MT", line 7451
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2624
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2685
ORA-06512: at line 2

 
 

You retry the above procedure after removing current Streams setup via DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION but you get same error ORA-23621.

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