none
Oracle CDC Suspended problem : ORA-01406 RRS feed

  • Question

  • Hi,

    This morning our Oracle CDC service was in pause status (yellow) Détailed Status : LOGGER

    "10/11/2012 7:57:56 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01406: fetched column value was truncated

    .","source","",""


    i have restarted the service but after few seconds it failed again...

    in the Collect diagnostics file i have found the error ORA-01406, i have checked in the oracle "alert" file and didn't find any error in it

    Could anyone help me ??  as i don't know what could be the cause and if it's on oracle side or CDC part



    /* **************************************************  ********** */
    "10/11/2012 9:20:28 AM","INFO","bel-cdm-dsql","RUNNING","IDLE","ORACDC302I:The Oracle CDC instance for service ECBI_CDC and database ECBI_DV_CDC_BEL_PREP received a stop signal.","service","",""
    "10/11/2012 9:20:28 AM","INFO","bel-cdm-dsql","STOPPED","STOP","ORACDC301I:The Oracle CDC instance for service ECBI_CDC and database ECBI_DV_CDC_BEL_PREP stopped.","service","",""
    "10/11/2012 9:20:59 AM","INFO","bel-cdm-dsql","RUNNING","INIT","ORACDC300I:The Oracle CDC instance for service ECBI_CDC and database ECBI_DV_CDC_BEL_PREP started.","service","",""
    "10/11/2012 9:20:59 AM","INFO","bel-cdm-dsql","RUNNING","INIT","ORACDC305I:The value of the option 'source_env_report' was changed to 9.","infrastructure","",""
    "10/11/2012 9:20:59 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01406: fetched column value was truncated
    .","source","",""
    "10/11/2012 9:20:59 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "10/11/2012 9:21:10 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC517E:Oracle Call Intreface (OCI) method failed: ORA-01406: fetched column value was truncated
    .","source","",""
    "10/11/2012 9:21:10 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "10/11/2012 9:21:10 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "10/11/2012 9:21:10 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "10/11/2012 9:21:10 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "10/11/2012 9:21:10 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "10/11/2012 9:21:10 AM","ERROR","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC512E:Failed to fetch a new record.","source","",""
    "10/11/2012 9:21:58 AM","INFO","bel-cdm-dsql","RUNNING","IDLE","ORACDC303I:The Oracle CDC instance for service ECBI_CDC and database ECBI_DV_CDC_BEL_PREP received a reconfigure signal.","service","",""
    "10/11/2012 9:21:58 AM","INFO","bel-cdm-dsql","RUNNING","IDLE","ORACDC305I:The value of the option 'source_env_report' was changed to 10.","infrastructure","",""
    "10/11/2012 9:21:58 AM","REPORT","bel-cdm-dsql","SUSPENDED","LOGGER","ORACDC000R:Oracle Diagnostics","infrastructure","
    Character set information:
    NLS_CHARACTERSET: 31
    LS_NCHAR_CHARACTERSET: 2000
    Reader Information:
    Thread: 1
    Last Transaction SCN: 9915841651996
    Last SCN: 9915841651996
    Greatest Sequence: 188720
    Start SCN: 9915841651996
    Transaction Sequencer: 1
    Context Sequencer: 0
    Max SCN: 0
    Last RBASQN: 188702
    Last RBABLK: 76850
    Last RBABYTE: 16
    State: 4
    Redo logs:
    /tablespaces/oradata/BEL_PREP/redo02.log (Sequence=188720)
    /flashrecovery/BEL_PREP/archivelog/2012_10_11/o1_mf_1_188719_87d77lw6_.arc (Sequence=188719)
    /flashrecovery/BEL_PREP/archivelog/2012_10_11/o1_mf_1_188718_87d73s6v_.arc (Sequence=188718)
    /flashrecovery/BEL_PREP/archivelog/2012_10_11/o1_mf_1_188717_87d6ws5z_.arc (Sequence=188717)
    /flashrecovery/BEL_PREP/archivelog/2012_10_11/o1_mf_1_188716_87d6kj31_.arc (Sequence=188716)
    /flashrecovery/BEL_PREP/archivelog/2012_10_11/o1_mf_1_188715_

    Tuesday, October 16, 2012 12:50 PM

Answers

  • You are witnessing a truncation.

    To resolve as per http://www.dba-oracle.com/t_ora_01406_fetched_column_value_was_truncated.htm you

    •  expand the column buffer area so that it can hold the largest column value
    • check your insert syntax, allowing for appropriate processing


    Arthur My Blog

    • Marked as answer by Eileen Zhao Tuesday, October 23, 2012 9:18 AM
    Tuesday, October 16, 2012 1:45 PM
    Moderator