Debezium Oracle Connector

[Aishwarya]

Hello all,

I am trying to use debezium oracle connector for Change Data Capture. Could anyone let me know if Oracle 11g Express Edition is compatible with debezium?

I am using Oracle XE 11.2.0.2.0, JDBC version 8- ojdbc8, Debezium 1.5/1.3. I am able to configure connector, but change events are not getting captured.

Please let me know if there is anything wrong in the version I am using. If there is no conflict in the version, please suggest any fix that I can try for the change events to be captured.

Thanks,

Aishwarya

[Chris Cranford]

Hi Aishwarya -

Are you using the XStream or LogMiner implementation?  Officially, the Oracle connector with LogMiner has not been tested so there could be limitations which we are unaware.  Specifically with Oracle XE, Oracle does limit certain behavior in the express editions.  Specifically in Oracle 18 XE, Debezium isn't supported because you cannot enable supplemental logging; however I recall that Oracle 11 XE may not have had this limitation. 

If I had to guess, the XE edition likely configures only 3 redo logs each with a size of 50mb just like we observed in Oracle 18 XE.  This configuration is **not** adequately tuned for LogMiner specifically and should be adjusted.  We recommend a minimum of 5 log groups each with a minimum of 400mb in size.  If adjusting the redo log groups & sizes don't help, I would enable trace logging and see if you notice any unusual behavior.

Also don't forget, checking the Oracle alert.log for LogMiner behavior can also be helpful to diagnose problems.

HTH,
Chris

--
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/c857f36e-340d-456b-9f2d-efb36b05bc5an%40googlegroups.com.