search

erdemcer / kafka-connect-oracle

Kafka Source Connector For Oracle
Apache License 2.0
348 stars 167 forks source link

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

Open cheungtsl opened 3 years ago

cheungtsl commented 3 years ago

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 commented 3 years ago

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

cheungtsl commented 3 years ago

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:notifications@github.com] Sent: Saturday, October 17, 2020 2:59 AM To: erdemcer/kafka-connect-oracle kafka-connect-oracle@noreply.github.com Cc: Thomas Cheung Thomas.Cheung@technicalsafetybc.ca; Author author@noreply.github.com 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 GitHubhttps://urldefense.com/v3/__https:/github.com/erdemcer/kafka-connect-oracle/issues/91*issuecomment-710787962__;Iw!!M0kHpZtYffSamTt0iw!TGB13Cxhw6ORH1-629Q2BBibuPQHDQQl4MrcALeu13tIgcUJC0qmrsJYaX-VDo6DYeEZi8d7Fkot$, or unsubscribehttps://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/AHNEFVMVVAVGFFD3SGSOHSLSLFTEVANCNFSM4ST5HS7Q__;!!M0kHpZtYffSamTt0iw!TGB13Cxhw6ORH1-629Q2BBibuPQHDQQl4MrcALeu13tIgcUJC0qmrsJYaX-VDo6DYeEZi1oeuTjY$.

erdemcer commented 3 years ago

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

cheungtsl commented 3 years ago

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:notifications@github.com] Sent: Sunday, October 18, 2020 9:54 PM To: erdemcer/kafka-connect-oracle kafka-connect-oracle@noreply.github.com Cc: Thomas Cheung Thomas.Cheung@technicalsafetybc.ca; Author author@noreply.github.com 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 GitHubhttps://urldefense.com/v3/__https:/github.com/erdemcer/kafka-connect-oracle/issues/91*issuecomment-711560554__;Iw!!M0kHpZtYffSamTt0iw!TYGgZ2b06oVQ0ht-Pi596_iDtb3VANFd05SDWOIMEOG0tiP-WVIq9GfuKal1F8D_QwvFNY_cbYJQ$, or unsubscribehttps://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/AHNEFVLFPRJJXSBJUAJM5TTSLPA5NANCNFSM4ST5HS7Q__;!!M0kHpZtYffSamTt0iw!TYGgZ2b06oVQ0ht-Pi596_iDtb3VANFd05SDWOIMEOG0tiP-WVIq9GfuKal1F8D_QwvFNWoQ36lx$.

cheungtsl commented 3 years ago

Do you have an estimate time for this feature to be released?

Thomas

From: Erdem Çer [mailto:notifications@github.com] Sent: Sunday, October 18, 2020 9:54 PM To: erdemcer/kafka-connect-oracle kafka-connect-oracle@noreply.github.com Cc: Thomas Cheung Thomas.Cheung@technicalsafetybc.ca; Author author@noreply.github.com 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 GitHubhttps://urldefense.com/v3/__https:/github.com/erdemcer/kafka-connect-oracle/issues/91*issuecomment-711560554__;Iw!!M0kHpZtYffSamTt0iw!TYGgZ2b06oVQ0ht-Pi596_iDtb3VANFd05SDWOIMEOG0tiP-WVIq9GfuKal1F8D_QwvFNY_cbYJQ$, or unsubscribehttps://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/AHNEFVLFPRJJXSBJUAJM5TTSLPA5NANCNFSM4ST5HS7Q__;!!M0kHpZtYffSamTt0iw!TYGgZ2b06oVQ0ht-Pi596_iDtb3VANFd05SDWOIMEOG0tiP-WVIq9GfuKal1F8D_QwvFNWoQ36lx$.

erdemcer commented 3 years ago

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