ORA-01306: dbms_logmnr.start_logmnr() must be invoked

[cheungtsl]

Hi there,

I'm running Oracle 11g and Oracle Connector version 1.0 in my environment. I got the following error and the logminer cannot restart itself.

[2020-10-16 23:01:01,538] ERROR Logminer could not start successfully and it will exit (com.ecer.kafka.connect.oracle.LogMinerThread)

Do you have any suggestions to resolve this issue? Below is the full stack of the errors

Thanks,
Thomas

connect | [2020-10-16 23:00:41,783] INFO Waiting for log switch (com.ecer.kafka.connect.oracle.LogMinerThread)
connect | [2020-10-16 23:00:50,784] INFO ################################# Scanning Log Files for SCN :88926360172 (com.ecer.kafka.connect.oracle.OracleSqlUtils)
connect | [2020-10-16 23:00:51,106] INFO Base log files O:\ORACLE\ORADATA\PROD\REDO01B.LOG (com.ecer.kafka.connect.oracle.OracleSqlUtils)
connect | [2020-10-16 23:00:51,107] INFO logmnr_logs log files O:\ORACLE\ORADATA\PROD\REDO01B.LOG (com.ecer.kafka.connect.oracle.OracleSqlUtils)
connect | [2020-10-16 23:00:51,107] INFO ################################# (com.ecer.kafka.connect.oracle.OracleSqlUtils)
connect | [2020-10-16 23:00:51,107] INFO Log miner will start , startScn : 88926360172 (com.ecer.kafka.connect.oracle.LogMinerThread)
connect | [2020-10-16 23:00:51,108] ERROR Logminer start exception ORA-01306: dbms_logmnr.start_logmnr() must be invoked before selecting from v$logmnr_contents
connect | , 10 (com.ecer.kafka.connect.oracle.LogMinerThread)
connect | [2020-10-16 23:00:51,108] INFO Waiting for log switch (com.ecer.kafka.connect.oracle.LogMinerThread)
connect | [2020-10-16 23:00:51,562] INFO WorkerSourceTask{id=star-connector-0} Committing offsets (org.apache.kafka.connect.runtime.WorkerSourceTask)
connect | [2020-10-16 23:00:51,562] INFO WorkerSourceTask{id=star-connector-0} flushing 0 outstanding messages for offset commit (org.apache.kafka.connect.runtime.WorkerSourceTask)
connect | [2020-10-16 23:01:01,109] INFO ################################# Scanning Log Files for SCN :88926360172 (com.ecer.kafka.connect.oracle.OracleSqlUtils)
connect | [2020-10-16 23:01:01,536] INFO Base log files O:\ORACLE\ORADATA\PROD\REDO01B.LOG (com.ecer.kafka.connect.oracle.OracleSqlUtils)
connect | [2020-10-16 23:01:01,537] INFO logmnr_logs log files O:\ORACLE\ORADATA\PROD\REDO01B.LOG (com.ecer.kafka.connect.oracle.OracleSqlUtils)
connect | [2020-10-16 23:01:01,537] INFO ################################# (com.ecer.kafka.connect.oracle.OracleSqlUtils)
connect | [2020-10-16 23:01:01,537] INFO Log miner will start , startScn : 88926360172 (com.ecer.kafka.connect.oracle.LogMinerThread)
connect | [2020-10-16 23:01:01,538] ERROR Logminer start exception ORA-01306: dbms_logmnr.start_logmnr() must be invoked before selecting from v$logmnr_contents
connect | , 11 (com.ecer.kafka.connect.oracle.LogMinerThread)
connect | [2020-10-16 23:01:01,538] ERROR Logminer could not start successfully and it will exit (com.ecer.kafka.connect.oracle.LogMinerThread)
connect | [2020-10-16 23:01:01,562] INFO WorkerSourceTask{id=star-connector-0} Committing offsets (org.apache.kafka.connect.runtime.WorkerSourceTask)

[erdemcer]

Hi,
I think you are using version from releases which is for specific test case ? Could you please download code and compile ?
thanks

[cheungtsl]

Thank you I’m also wondering if your connector can handle clob data type. I was testing the connector and I notice my column with clob data type return null value. Do you think I have misconfigure the connector? Please advise Thanks, Thomas From: Erdem Çer [mailto:[email protected]] Sent: Saturday, October 17, 2020 2:59 AM To: erdemcer/kafka-connect-oracle <[email protected]> Cc: Thomas Cheung <[email protected]>; Author <[email protected]> Subject: #EXTERNAL# Re: [erdemcer/kafka-connect-oracle] ORA-01306: dbms_logmnr.start_logmnr() must be invoked (#91) Hi, I think you are using version from releases which is for specific test case ? Could you please download code and compile ? thanks — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<https://urldefense.com/v3/__https:/github.com/erdemcer/kafka-connect-oracle/issues/91*issuecomment-710787962__;Iw!!M0kHpZtYffSamTt0iw!TGB13Cxhw6ORH1-629Q2BBibuPQHDQQl4MrcALeu13tIgcUJC0qmrsJYaX-VDo6DYeEZi8d7Fkot$>, or unsubscribe<https://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/AHNEFVMVVAVGFFD3SGSOHSLSLFTEVANCNFSM4ST5HS7Q__;!!M0kHpZtYffSamTt0iw!TGB13Cxhw6ORH1-629Q2BBibuPQHDQQl4MrcALeu13tIgcUJC0qmrsJYaX-VDo6DYeEZi1oeuTjY$>.

[erdemcer]

Hi,
Clob types will be handled soon. I am working on this.
Thanks

[cheungtsl]

Thank you for your hard work… We look forward for the CLOB type feature as it’s crucial for us to do to production. Thomas From: Erdem Çer [mailto:[email protected]] Sent: Sunday, October 18, 2020 9:54 PM To: erdemcer/kafka-connect-oracle <[email protected]> Cc: Thomas Cheung <[email protected]>; Author <[email protected]> Subject: #EXTERNAL# Re: [erdemcer/kafka-connect-oracle] ORA-01306: dbms_logmnr.start_logmnr() must be invoked (#91) Hi, Clob types will be handled soon. I am working on this. Thanks — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<https://urldefense.com/v3/__https:/github.com/erdemcer/kafka-connect-oracle/issues/91*issuecomment-711560554__;Iw!!M0kHpZtYffSamTt0iw!TYGgZ2b06oVQ0ht-Pi596_iDtb3VANFd05SDWOIMEOG0tiP-WVIq9GfuKal1F8D_QwvFNY_cbYJQ$>, or unsubscribe<https://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/AHNEFVLFPRJJXSBJUAJM5TTSLPA5NANCNFSM4ST5HS7Q__;!!M0kHpZtYffSamTt0iw!TYGgZ2b06oVQ0ht-Pi596_iDtb3VANFd05SDWOIMEOG0tiP-WVIq9GfuKal1F8D_QwvFNWoQ36lx$>.

[cheungtsl]

Do you have an estimate time for this feature to be released? Thomas From: Erdem Çer [mailto:[email protected]] Sent: Sunday, October 18, 2020 9:54 PM To: erdemcer/kafka-connect-oracle <[email protected]> Cc: Thomas Cheung <[email protected]>; Author <[email protected]> Subject: #EXTERNAL# Re: [erdemcer/kafka-connect-oracle] ORA-01306: dbms_logmnr.start_logmnr() must be invoked (#91) Hi, Clob types will be handled soon. I am working on this. Thanks — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub<https://urldefense.com/v3/__https:/github.com/erdemcer/kafka-connect-oracle/issues/91*issuecomment-711560554__;Iw!!M0kHpZtYffSamTt0iw!TYGgZ2b06oVQ0ht-Pi596_iDtb3VANFd05SDWOIMEOG0tiP-WVIq9GfuKal1F8D_QwvFNY_cbYJQ$>, or unsubscribe<https://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/AHNEFVLFPRJJXSBJUAJM5TTSLPA5NANCNFSM4ST5HS7Q__;!!M0kHpZtYffSamTt0iw!TYGgZ2b06oVQ0ht-Pi596_iDtb3VANFd05SDWOIMEOG0tiP-WVIq9GfuKal1F8D_QwvFNWoQ36lx$>.

[erdemcer]

Hi,
I have some works on this issue already done . I will merge code with new developments in 2-3 weeks i think.
Thanks.