Is Debezium compatible with Oracle XE 18c?

[Yuri Stapassoli de Sá]

Hi All,

For testing purposes, I am trying to configure debezium locally with Oracle XE 18c and logminer.

I followed the instructions on the link below, but when using endpoint to check status I am getting the following error message (see attached file):

"Supplemental logging not properly configured. Use: ALTER DATABASE ADD SUPPLEMENTAL LOG DATA".

https://debezium.io/documentation/reference/connectors/oracle.html#_preparing_the_database

When i try to run this command in oracle, i get the error: 

ORA-44608: Supplemental logging settings cannot be modified in Oracle Database Express Edition

Is there any way to activate debezium with Oracle XE or is it definitely not compatible with this version of Oracle ?

[Chris Cranford]

Hi Yuri -

Unfortunately Oracle XE doesn't allow enabling the necessary functionality in order to capture changes for replication which directly means that Debezium cannot work with an XE installation.  But if you're wanting to test Debezium locally, you don't need to necessarily use an XE installation to do that.  Oracle's docker registry provides versions of Oracle EE for all the most recent builds of Oracle.  In addition, you can also download the Oracle 19 EE installation from OTN and follow our instructions in the debezium/oracle-vagrant-box repository [1] if you want to install Oracle that way.  That repository covers the installation steps for Oracle 12c and 19c.

Thanks,
Chris

[1]: https://github.com/debezium/oracle-vagrant-box

--
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/1f2b69d9-fa7a-4c98-b96a-e679460a4b04n%40googlegroups.com.