Data Replication 2
Results 1 to 2 of 2

Thread: ERROR starting CDC instance- CDC instance could not be Started

  1. #1
    fastloader is offline Junior Member
    Join Date
    May 2014
    Posts
    3
    Rep Power
    0

    ERROR starting CDC instance- CDC instance could not be Started

    Hi we are using CDc instance for the past one year it working fine.

    Last week in my TEST environment CDC is not reading changes and the time stamp is also strucked still, so we did reset of the instance and started it .

    It is going into IDLE state for a few seconds and going into stop state, If we try to start again it repeatedly going into IDLE and STOP state followed by an ERROR MESSAGE: The service 'CDC_QA' is either stopped or in error state so CDC instance 'TEST' could not be started.



    I have checked the cdc.xdbcdc_state table there is no error.

    Name:  cdc.xdbcdc_state.JPG
Views: 477
Size:  11.2 KB

    STATUS is STOPPED, SUB-STATUS is STOPPED, ACTIVE-0, ERROR-0


    COLLECTED DIAGNOSTICS:

    "8/13/2014 1:18:32 PM","INFO","********36","RUNNING","INIT","ORACDC30 5I:The value of the option 'source_env_report' was changed to 16.","infrastructure","",""
    "8/13/2014 1:18:32 PM","TRACE","********36","RUNNING","INIT","ORACDC0 00T:** Debug / Announce input parameters. **
    Component Type:
    Component Name:
    at: 'oracle_source_allocate(...)'","source","",""
    "8/13/2014 1:18:32 PM","TRACE","********36","RUNNING","INIT","ORACDC0 00T:** Debug / Announce input parameters. **
    Prepare
    at: 'oracle_source_prepare(...)'","source","",""
    "8/13/2014 1:18:34 PM","TRACE","********36","RUNNING","INIT","ORACDC0 00T:** Debug / Announce input parameters. **
    Component Type:
    Component Name:
    at: 'oracle_source_allocate(...)'","source","",""
    "8/13/2014 1:18:34 PM","TRACE","********36","RUNNING","INIT","ORACDC0 00T:** Debug / Announce input parameters. **
    Prepare
    at: 'oracle_source_prepare(...)'","source","",""
    "8/13/2014 1:18:34 PM","TRACE","********36","RUNNING","INIT","ORACDC0 00T:** Debug / Announce input parameters. **
    at: 'oracle_source_set_stream(...)'","source","",""
    "8/13/2014 1:18:34 PM","TRACE","********36","RUNNING","IDLE","ORACDC0 00T:Retrieving current SCN","source","",""
    "8/13/2014 1:18:34 PM","TRACE","********36","RUNNING","IDLE","ORACDC0 00T:Oracle CDC Capture start","source","",""
    "8/13/2014 1:18:34 PM","INFO","********36","RUNNING","IDLE","ORACDC30 2I:The Oracle CDC instance for service CDC_QA and database TEST received a stop signal.","service","",""
    "8/13/2014 1:18:34 PM","TRACE","********36","RUNNING","IDLE","ORACDC0 00T:Oracle CDC Merger was allocated","source","",""
    "8/13/2014 1:18:34 PM","TRACE","********36","RUNNING","IDLE","ORACDC0 00T:Retrieving current SCN","source","",""
    "8/13/2014 1:18:34 PM","TRACE","********36","RUNNING","IDLE","ORACDC0 00T:Adding redo logs to log miner session.","source","",""
    "8/13/2014 1:18:34 PM","TRACE","********36","RUNNING","IDLE","ORACDC0 00T:Redo log: /data02/app/***/***/db/apps_st/data/log1a.dbf, Sequence: 47023","source","",""
    "8/13/2014 1:18:34 PM","TRACE","********36","RUNNING","IDLE","ORACDC0 00T:Redo log: /data02/app/***/***/db/apps_st/data/log1b.dbf, Sequence: 47023","source","",""
    "8/13/2014 1:18:34 PM","TRACE","********36","RUNNING","IDLE","ORACDC0 00T:Thread(1) - Start log miner session","source"," begin
    SYS.DBMS_LOGMNR.START_LOGMNR(
    startScn => 5968828340303,
    endScn => 5968828340503
    );
    end;",""
    "8/13/2014 1:18:34 PM","ERROR","********36","RUNNING","IDLE","ORACDC5 17E:Oracle Call Intreface (OCI) method failed: ORA-01882: timezone region not found
    .","source","",""
    "8/13/2014 1:18:34 PM","TRACE","********36","RUNNING","IDLE","ORACDC0 00T:** Debug / Announce input parameters. **
    at: 'oracle_source_free(...)'","source","",""
    "8/13/2014 1:18:34 PM","TRACE","********36","RUNNING","IDLE","ORACDC0 00T:** Debug / Announce input parameters. **
    at: 'oracle_source_free(...)'","source","",""
    "8/13/2014 1:18:34 PM","INFO","********36","STOPPED","STOP","ORACDC30 1I:The Oracle CDC instance for service CDC_QA and database TEST stopped.","service","",""
    "8/13/2014 3:48:32 PM","INFO","********36","RUNNING","INIT","ORACDC30 0I:The Oracle CDC instance for service CDC_QA and database TEST started.","service","",""
    "8/13/2014 3:48:32 PM","INFO","********36","RUNNING","INIT","ORACDC30 5I:The value of the option 'source_env_report' was changed to 16.","infrastructure","",""
    "8/13/2014 3:48:32 PM","TRACE","********36","RUNNING","INIT","ORACDC0 00T:** Debug / Announce input parameters. **
    Component Type:
    Component Name:
    at: 'oracle_source_allocate(...)'","source","",""
    "8/13/2014 3:48:32 PM","TRACE","********36","RUNNING","INIT","ORACDC0 00T:** Debug / Announce input parameters. **
    Prepare
    at: 'oracle_source_prepare(...)'","source","",""
    "8/13/2014 3:48:34 PM","TRACE","********36","RUNNING","INIT","ORACDC0 00T:** Debug / Announce input parameters. **
    Component Type:
    Component Name:
    at: 'oracle_source_allocate(...)'","source","",""
    "8/13/2014 3:48:34 PM","TRACE","********36","RUNNING","INIT","ORACDC0 00T:** Debug / Announce input parameters. **
    Prepare
    at: 'oracle_source_prepare(...)'","********36","RUNNIN G","INIT","ORACDC000T:** Debug / Announce input parameters. **
    at: 'oracle_source_set_stream(...)'","source","",""
    "8/13/2014 3:48:34 PM","TRACE","********36","RUNNING","IDLE","ORACDC0 00T:Retrieving current SCN","source","",""
    "8/13/2014 3:48:34 PM","TRACE","********36","RUNNING","IDLE","ORACDC0 00T:Oracle CDC Capture start","source","",""
    "8/13/2014 3:48:34 PM","INFO","********36","RUNNING","IDLE","ORACDC30 2I:The Oracle CDC instance for service CDC_QA and database TEST received a stop signal.","service","",""
    "8/13/2014 3:48:34 PM","TRACE","********36","RUNNING","IDLE","ORACDC0 00T:Oracle CDC Merger was allocated","source","",""
    "8/13/2014 3:48:34 PM","TRACE","********36","RUNNING","IDLE","ORACDC0 00T:Retrieving current SCN","source","",""
    "8/13/2014 3:48:34 PM","TRACE","********36","RUNNING","IDLE","ORACDC0 00T:Adding redo logs to log miner session.","source","",""
    "8/13/2014 3:48:34 PM","TRACE","********36","RUNNING","IDLE","ORACDC0 00T:Redo log: /data02/app/***/***/db/apps_st/data/log2a.dbf, Sequence: 47033","source","",""
    "8/13/2014 3:48:34 PM","TRACE","********36","RUNNING","IDLE","ORACDC0 00T:Redo log: /data02/app/***/***/db/apps_st/data/log2b.dbf, Sequence: 47033","source","",""
    "8/13/2014 3:48:34 PM","TRACE","********36","RUNNING","IDLE","ORACDC0 00T:Thread(1) - Start log miner session","source"," begin
    SYS.DBMS_LOGMNR.START_LOGMNR(
    startScn => 5968828589325,
    endScn => 5968828589525
    );
    end;",""
    "8/13/2014 3:48:34 PM","TRACE","********6","RUNNING","IDLE","ORACDC00 0T:** Debug / Announce input parameters. **
    at: 'oracle_source_free(...)'","source","",""
    "8/13/2014 3:48:34 PM","ERROR","********36","RUNNING","IDLE","ORACDC5 17E:Oracle Call Intreface (OCI) method failed: ORA-01882: timezone region not found
    .","source","",""
    "8/13/2014 3:48:34 PM","TRACE","********36","RUNNING","IDLE","ORACDC0 00T:** Debug / Announce input parameters. **
    at: 'oracle_source_free(...)'","source","",""
    "8/13/2014 3:48:34 PM","INFO","********36","STOPPED","STOP","ORACDC30 1I:The Oracle CDC instance for service CDC_QA and database TEST stopped.","service","",""


    NOTE: Recently 10days back we are having RAM issue in the server (it in VMWare) having High Load it is not supporting ETL process, So ADMIN team changed the HOST of the server.

    Please let me know if any one is having solution for this , To bring the CDC instance into PROCESSING mode.

  2. #2
    mikedba is offline Junior Member
    Join Date
    Nov 2014
    Posts
    8
    Rep Power
    0
    I had a similar issue once. Try a reboot of the CDC server (I found restarting the CDC services was not enough).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •