Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

ORA-26675: cannot create Streams capture process

Question
1
Views
0
Comments

We are trying to setup Change Data Capture in Asynchronous Distributed HotLog Mode and

followed the steps described in https://docs.oracle.com/cd/B28359_01/server.111/b28313/cdc.htm

On step 8 of "Performing Asynchronous Distributed HotLog Publishing" section we got the following error:

SQL> BEGIN

  2     DBMS_CDC_PUBLISH.CREATE_HOTLOG_CHANGE_SOURCE(

  3         change_source_name => 'CHG_SRC_FENIX_NAL',

  4         description => 'DIST HOTLOG SOURCE',

  5         source_database => 'DBL_FENIX_NAL');

  6  END;

  7  /

BEGIN

*

ERROR at line 1:

ORA-26675: cannot create Streams capture process CDC$C_CHG_SRC_FENIX_NAL

ORA-06512: at "SYS.DBMS_CAPTURE_ADM_INTERNAL", line 600

ORA-06512: at line 1

ORA-06512: at "SYS.DBMS_CDC_IPUBLISH", line 182

ORA-06512: at "SYS.DBMS_CDC_PUBLISH", line 339

ORA-06512: at line 2

SQL>

Can you give us some advice on this error, please? database links are working fine and all steps until 8 is working too.

Source database : 11.2.0.4

Staging database: 11.2.0.4