Skip to main content
Solved

ORA-00942 While running Oracle CDC on 19c Databases

  • December 28, 2021
  • 2 replies
  • 122 views
S
Fan

The configuration is made according to the linked document

 CDC documentation

https://docs.streamsets.com/portal/datacollector/3.17.x/help/datacollector/UserGuide/Origins/OracleCDC.html#concept_rs5_hjj_tw

 

run into the below error

JDBC_52 - Error starting LogMiner 

Caused by: com.streamsets.pipeline.api.StageException: JDBC_603 - Error while retrieving LogMiner metadata: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Best answer by Rishi

Hii @shown , Please check out the below article , Hope this will help

https://community.streamsets.com/common-issues-47/ora-00942-while-running-oracle-cdc-on-19c-databases-389

 

View original
Did this topic help you find an answer to your question?

Rishi
StreamSets Employee
Forum|alt.badge.img
  • RishiStreamSets Employee
  • StreamSets Employee
  • January 17, 2022

Hii @shown , Please check out the below article , Hope this will help

 

S
Fan
  • shownFan
  • Fan
  • January 19, 2022

Thank you. Later we found that Oracle19c was caused by a problem with the Oracle driver, and the SQL syntax for obtaining the log was reported wrong

Drew Kreiger
1 person likes this
  • Drew Kreiger
    Drew Kreiger

Reply


Terms & Conditions