6 Replies Latest reply on Jan 17, 2014 8:58 PM by Baris Yildirim

    Unable to enable capture on Changeset

    766efa18-2178-4e3e-846b-7e147909cd32

      I have set up CDC

       

       

      ALTER  DATABASE FORCE LOGGING;

       

      ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

       

      CREATE USER CDC_Publisher IDENTIFIED BY CDC_Publisher DEFAULT TABLESPACE CDC_Objects;

       

      GRANT  DBA TO CDC_Publisher;

       

       

      BEGIN
      DBMS_CDC_PUBLISH.CREATE_CHANGE_SET(change_set_name => 'DIMENSIONS',  description => 'Change set for Dimensions',  change_source_name => 'HOTLOG_SOURCE', stop_on_ddl => 'y);

       

       

      END;

       

      ALTER TABLE SCOTT.EMP_CDCSource ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

       

      -- Instantiate

      BEGIN

      DBMS_CAPTURE_ADM.PREPARE_TABLE_INSTANTIATION(TABLE_NAME => 'SCOTT.EMP_CDCSource');

      END;

       

      --Create change table

      BEGIN

      DBMS_CDC_PUBLISH.CREATE_CHANGE_TABLE( owner  => 'CDC_PUBLISHER', change_table_name  => 'EMP_CDCSource_CT', change_set_name => 'DIMENSIONS',source_schema => 'SCOTT', source_table  => 'EMP_CDCSource',

         column_type_list   => 'EMPNO NUMBER(4),ENAME VARCHAR2(10),JOB  VARCHAR2(9),MGR  NUMBER(4),HIREDATE DATE,SAL NUMBER(7,2), COMM NUMBER(7,2),DEPTNO NUMBER(2)', capture_values  => 'BOTH', rs_id  => 'y',row_id => 'n',user_id => 'y',timestamp => 'n',

         object_id  => 'n',source_colmap => 'n',target_colmap  => 'y', options_string  => '');

      END;

       

      -- Enable Capture

      BEGIN

         DBMS_CDC_PUBLISH.ALTER_CHANGE_SET(change_set_name => 'DIMENSIONS', enable_capture => 'y');

      END;

       

      ---At this point it throws error:  Change Set Dimensions Disabled due to capture error.  

       

      When I checked the error in SELECT * FROM DBA_APPLY_ERROR  the error is ORA-26702: shut the STREAMS/CDC apply engine down. 

       

      Any idea how to solve this?