Debezium Oracle Connector Exception ORA-21560: argument last_position is null, invalid

[Bitros Wang]

ct.runtime.WorkerSourceTask:415)

[2019-05-21 05:10:11,039] ERROR Producer failure (io.debezium.pipeline.ErrorHandler:36)

java.lang.RuntimeException: oracle.streams.StreamsException: ORA-21560: argument last_position is null, invalid, or out of range

        at io.debezium.connector.oracle.OracleStreamingChangeEventSource.execute(OracleStreamingChangeEventSource.java:75)

        at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:86)

        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

        at java.util.concurrent.FutureTask.run(FutureTask.java:266)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

        at java.lang.Thread.run(Thread.java:748)

Caused by: oracle.streams.StreamsException: ORA-21560: argument last_position is null, invalid, or out of range

        at oracle.streams.XStreamOut.XStreamOutAttachNative(Native Method)

        at oracle.streams.XStreamOut.attachInternal(XStreamOut.java:373)

        at oracle.streams.XStreamOut.attach(XStreamOut.java:343)

        at io.debezium.connector.oracle.OracleStreamingChangeEventSource.execute(OracleStreamingChangeEventSource.java:63)

        ... 6 more

[2019-05-21 05:10:11,045] INFO Creating thread debezium-oracleconnector-server1-error-handler (io.debezium.util.Threads:267)

[2019-05-21 05:10:11,059] ERROR Interrupted while stopping (io.debezium.connector.oracle.OracleConnectorTask:159)

java.lang.InterruptedException

        at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2067)

        at java.util.concurrent.ThreadPoolExecutor.awaitTermination(ThreadPoolExecutor.java:1475)

        at java.util.concurrent.Executors$DelegatedExecutorService.awaitTermination(Executors.java:675)

        at io.debezium.pipeline.ErrorHandler.stop(ErrorHandler.java:52)

        at io.debezium.connector.oracle.OracleConnectorTask.cleanupResources(OracleConnectorTask.java:154)

        at io.debezium.pipeline.ErrorHandler.lambda$setProducerThrowable$0(ErrorHandler.java:42)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

        at java.lang.Thread.run(Thread.java:748)

I'm using Debezium 0.9.5.Final  I set up all the settings by tutorial, but met this exception.Blow is my configs

Centos7, Oracle 12cR1, Kafka2.2.0, Oracle Instant Client 19.3

name=cdc-test-connector

connector.class=io.debezium.connector.oracle.OracleConnector

tasks.max=1

database.server.name=server1

database.hostname=localhost

database.port=1521

database.user=c##xstrm

database.password=123

database.dbname=ORCL

database.pdb.name=ORCLPDB

database.out.server.name=dbzxout

database.history.kafka.bootstrap.servers=localhost:9092

database.history.kafka.topic=cdc-test-2

table.whitelist=CDC_TEST.CUSTOMERS

[王哲远]

Hi. I encountered the same problem a few days ago, and it is related to the default mode of XStream outbound server(XStreamOut.DEFAULT_MODE=0). The workaround is to change the mode  by adding following parameters according to https://github.com/debezium/debezium-incubator#for-oracle-11g.

"database.tablename.case.insensitive": "true"
"database.oracle.version": "11"

I hope it helps.

在 2019年5月21日星期二 UTC+8下午5:35:39，Bitros Wang写道：