Ask Your Question
0

Oracle CDC Client (19c) fails to start with JDBC_52, JDBC_603 errors

asked 2020-06-11 13:39:43 -0500

KateF gravatar image

updated 2020-06-12 07:31:23 -0500

Hi, I am using SDC 3.16.0 and have the Oracle CDC Client running on several 18c databases, but after following all directions in the DataCollector User Guide for Oracle CDC Client, I cannot get it to run against a 19c database. Log error is mentioned below. I can run logminer myself from an Oracle client using the StreamSets user if I properly specify the log files, so I do not think it is a permissions issue. Any assistance is appreciated.

ERROR OracleCDCSource - Error while trying to setup record generator thread com.streamsets.pipeline.api.StageException: JDBC_603 - Error while retrieving LogMiner metadata: java.sql.SQLException: Fail to convert to internal representation at com.streamsets.pipeline.stage.origin.jdbc.cdc.oracle.LogMinerSession.findLogsCoveringDateTime(LogMinerSession.java:590) at com.streamsets.pipeline.stage.origin.jdbc.cdc.oracle.LogMinerSession.findEarliestLogCoveringDateTime(LogMinerSession.java:547) at com.streamsets.pipeline.stage.origin.jdbc.cdc.oracle.LogMinerSession.start(LogMinerSession.java:250) at com.streamsets.pipeline.stage.origin.jdbc.cdc.oracle.OracleCDCSource.startLogMiner(OracleCDCSource.java:478) at com.streamsets.pipeline.stage.origin.jdbc.cdc.oracle.OracleCDCSource.startGeneratorThread(OracleCDCSource.java:434)

etc.

edit retag flag offensive close merge delete

Comments

Can you be more specific about "after following all directions" and also updated your question with the SDC version you're running?

iamontheinet gravatar imageiamontheinet ( 2020-06-11 17:15:16 -0500 )edit

I am using SDC 3.16.0 and I meant the instructions in the DataCollector User Guide Oracle CDC Client entry for setup of logging in Oracle (edited the original post to add that info).

KateF gravatar imageKateF ( 2020-06-12 07:33:40 -0500 )edit

Hi Hugo, the current driver is ojdbc6 because the documentation says it was tested with version 11. Let me try with ojdbc8. Also maybe this is a different question but looking through the source code on GitHub I absolutely cannot find the method findLogsCoveringDateTime mentioned in the error.

KateF gravatar imageKateF ( 2020-06-15 15:41:39 -0500 )edit

HI Hugo, your suggestion worked, using ojdbc8 solved my problem. Do you want to add it as an answer? thanks very much.

KateF gravatar imageKateF ( 2020-06-15 16:26:57 -0500 )edit

Thanks for confirming, @KateF. I've converted Hugo's comment to be the answer.

iamontheinet gravatar imageiamontheinet ( 2020-06-15 16:38:46 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted
1

answered 2020-06-15 13:27:12 -0500

Hugo Prol gravatar image

Hi KateF, what Oracle jdbc driver version are you using? Could you please try with 18.3 (ojdbc8) or later if the current installed driver is older?

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-06-11 13:39:43 -0500

Seen: 102 times

Last updated: Jun 12