SAP Knowledge Base Article - Preview

2979569 - Subscription Error: "LogReader is in ERROR state [ORA-01292: no log file has been specified for the current LogMiner session"

Symptom

  • Subscription failed with error
  • Error from subscription monitor page
    Error: "Error:  LogReader is in ERROR state [ORA-01292: no log file has been specified for the current LogMiner session
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 1
    ]. Check LogReader instance log <remote_source_name>.log for details."
  • Error in framework.trc file
    [ERROR] OracleRepAgentWrapper | OracleRepAgentWrapper$2.run [] - LogReader is not in REPLICATE state. State: REPLICATION DOWN.
    [ERROR] DPFramework | ReceiverImpl.sendError [] - com.sap.hana.dp.adapter.sdk.AdapterException: LogReader is in ERROR state [ORA-01292: no log file has been specified for the current LogMiner session

    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 1
    ]. Check LogReader instance log <remote_source_name>.log for details. Context: com.sap.hana.dp.adapter.sdk.AdapterException: LogReader is in ERROR state [ORA-01292: no log file has been specified for the current LogMiner session
    ORA-06512: at "SYS.DBMS_LOGMNR", line 58
    ORA-06512: at line 1

  • Error in <remote_source_name>.log
    ERROR          com.sybase.ds.oracle.logmnr.LogMiner          Failed to start Log Miner: STARTSCN=<STARTSCN>, ENDSCN=<ENDSCN>
     


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA smart data integration 2.0

Keywords

SCN, log file, SDI, ORA-01292 , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.