I installed Confluent’s oracle cdc connector, configured database (Oracle 19c no-cdb) to activate logminer.
the connector got the snapshotting very well.
However when it is done from snapshotting, after certain time, an error occured.
below the configuration of the connector(used versions: 2.2.0 → 2.6.0).
name=oracle
tasks.max=1
connector.class=io.confluent.connect.oracle.cdc.OracleCdcSourceConnector
redo.log.consumer.bootstrap.servers=kafka.broker.local
confluent.topic.bootstrap.servers=kafka.broker.local
key.converter=io.confluent.connect.avro.AvroConverter
key.converter.schema.registry.url=http://schema-registry:8081
value.converter=io.confluent.connect.avro.AvroConverter
value.converter.schema.registry.url=http://schema-registry:8081
oracle.server=oracle.local
oracle.port=1521
oracle.sid=db
oracle.username=confluentminer
oracle.password=dbz
redo.log.topic.name=redo-log
table.inclusion.regex=db.schema.table
lob.topic.name.template=db.schema.table.xmlcolumn
start.from=snapshot
confluent.topic.replication.factor=1
topic.creation.groups=redo
topic.creation.redo.replication.factor=1
topic.creation.redo.partitions=1
topic.creation.redo.cleanup.policy=delete
topic.creation.redo.retention.ms=1209600000
topic.creation.default.replication.factor=1
topic.creation.default.partitions=1
topic.creation.default.cleanup.policy=delete
enable.large.lob.object.support=true
errors.tolerance=all
errors.deadletterqueue.topic.name=my_dlq
redo.log.corruption.topic=corruption-topic
heartbeat.interval.ms=500
heartbeat.topic.name=heartbeat-topic