DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS Hanging On Datapump Export / Import Operations.

(Doc ID 2227686.1)

Last updated on FEBRUARY 03, 2017

Applies to:

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

Symptoms

Streams setup thru DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS may hang in RDBMS 12c. The same setup works fine in 11g.

Tried both methods, running DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS with "perform_actions=>true" and manually with the generated setup scripts, for example:

BEGIN
DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS(
schema_names => 'SCOTT',
source_directory_object => 'WORK_DIR',
destination_directory_object => 'WORK_DIR',
source_database => 'ORCL',
destination_database => 'ORCL1',
capture_name => 'CAPTURE_SCOTT',
capture_queue_table => 'CAPTURE_QTABLE_SCOTT',
capture_queue_name => 'CAPTURE_QNAME_SCOTT',
capture_queue_user => null,
apply_name => 'APPLY_SCOTT',
apply_queue_table => 'APPLY_QTABLE_SCOTT',
apply_queue_name => 'APPLY_QNAME_SCOTT',
apply_queue_user => null,
propagation_name => 'PROP_SCOTT',
log_file => 'maint_schemas.log',
bi_directional => true,
include_ddl => true,
instantiation => dbms_streams_adm.instantiation_schema,
perform_actions => true,
script_name => 'schema_replication.sql',
script_directory_object => 'work_dir'
);
END;
/

 

 

Changes

 Upgraded 11g database to 12c.

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