APPLY ABORTS WITH ORA-26687 AFTER STREAMS SETUP USING MAINTAIN_* SET OF PROCEDURES
(Doc ID 1379065.1)
Last updated on FEBRUARY 19, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
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 <STRMADMIN_USER>/<STRMADMIN_PASSWORD>
BEGIN
dbms_streams_adm.maintain_tables(
table_names => '<SCHEMA>.<TABLE>',
source_directory_object => '<SOURCE_DIRECTORY_OBJECT>',
destination_directory_object => '<DESTINATION_DIRECTORY_OBJECT>',
source_database => '<SOURCE DATABASE>',
destination_database => '<TARGET DATABASE>',
script_name => '<SCRIPT_NAME>',
script_directory_object=>'<SOURCE_DIRECTORY_OBJECT>',
capture_name => '<CAPTURE_NAME>',
apply_name => '<APPLY_NAME>',
capture_queue_name=>'<QUEUE_NAME>',
apply_queue_name =>'<QUEUE_NAME>',
perform_actions => TRUE,
bi_directional => FALSE,
include_ddl => false,
instantiation => dbms_streams_adm.instantiation_table);
END;
/
conn <STRMADMIN_USER>/<STRMADMIN_PASSWORD>
BEGIN
dbms_streams_adm.maintain_tables(
table_names => '<SCHEMA>.<TABLE>',
source_directory_object => '<SOURCE_DIRECTORY_OBJECT>',
destination_directory_object => '<DESTINATION_DIRECTORY_OBJECT>',
source_database => '<SOURCE DATABASE>',
destination_database => '<TARGET DATABASE>',
script_name => '<SCRIPT_NAME>',
script_directory_object=>'<SOURCE_DIRECTORY_OBJECT>',
capture_name => '<CAPTURE_NAME>',
apply_name => '<APPLY_NAME>',
capture_queue_name=>'<QUEUE_NAME>',
apply_queue_name =>'<QUEUE_NAME>',
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
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 |
| References |