ORA-26675 When Executing Dbms_Cdc_Publish.Create_Hotlog_Change_Source (Doc ID 780037.1)

Last updated on FEBRUARY 03, 2009

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.7
This problem can occur on any platform.

Symptoms

-- Problem Statement:
Setting up Asynchronous Distributed HotLog Change Data Capture .
While connected at the staging database , following step fails:

SQL> BEGIN
DBMS_CDC_PUBLISH.CREATE_HOTLOG_CHANGE_SOURCE(
change_source_name => 'CDC_SOURCE',
description => 'test source',
source_database => 'source_db.amcastle.com');
END;
/
2 3 4 5 6 7
BEGIN
*
ERROR at line 1:
ORA-26675: cannot create Streams capture process CDC$C_CDC_SOURCE
ORA-06512: at "SYS.DBMS_CAPTURE_ADM_INTERNAL", line 121
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_CDC_IPUBLISH", line 133
ORA-06512: at "SYS.DBMS_CDC_PUBLISH", line 194
ORA-06512: at line 2


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