Solved

ORA-00942 While running Oracle CDC on 19c Databases

  • 28 December 2021
  • 2 replies
  • 106 views

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

icon

Best answer by Rishi 17 January 2022, 07:21

View original

2 replies

Userlevel 4
Badge

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

 

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

Reply