APPLY ABORTS WITH ORA-26687 AFTER STREAMS SETUP USING MAINTAIN_* SET OF PROCEDURES
Last updated on FEBRUARY 08, 2017
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]Information in this document applies to any platform.
Symptoms
Following Note 864973.1 to setup Streams replication using DBMS_STREAMS_ADM.MAINTAIN_* set of procedures
exec dbms_streams_adm.remove_streams_configuration;
conn stradm/stradm
BEGIN
dbms_streams_adm.maintain_tables(
table_names => 'scott.t1',
source_directory_object => 'inst1_dir',
destination_directory_object => 'inst2_dir',
source_database => 'dbs1',
destination_database => 'dbs2',
script_name => 'tables.sql',
script_directory_object=>'inst1_dir',
capture_name => 'SCOTT_TO_INST2',
apply_name => 'SCOTT_FROM_INST1',
capture_queue_name=>'SCOTT_QUEUE',
apply_queue_name =>'SCOTT_QUEUE',
perform_actions => TRUE,
bi_directional => FALSE,
include_ddl => false,
instantiation => dbms_streams_adm.instantiation_table);
END;
/
conn stradm/stradm
BEGIN
dbms_streams_adm.maintain_tables(
table_names => 'scott.t1',
source_directory_object => 'inst1_dir',
destination_directory_object => 'inst2_dir',
source_database => 'dbs1',
destination_database => 'dbs2',
script_name => 'tables.sql',
script_directory_object=>'inst1_dir',
capture_name => 'SCOTT_TO_INST2',
apply_name => 'SCOTT_FROM_INST1',
capture_queue_name=>'SCOTT_QUEUE',
apply_queue_name =>'SCOTT_QUEUE',
perform_actions => TRUE,
bi_directional => FALSE,
include_ddl => false,
instantiation => dbms_streams_adm.instantiation_table);
END;
/
Streams setup is working fine. Apply may abort with an error ora-26687 while insert,update or delete is being execute
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