.....
[2022-07-01 23:33:06,086] INFO Adding table myserver.O.REDACT to the list of capture schema tables (io.debezium.relational.RelationalSnapshotChangeEventSource)
[2022-07-01 23:33:06,302] INFO Snapshot step 3 - Locking captured tables [*redact 100 tables*] (io.debezium.r
elational.RelationalSnapshotChangeEventSource)
[2022-07-01 23:33:06,302] INFO Schema locking was disabled in connector configuration (io.debezium.connector.oracle.OracleSnapshotChangeEventSource)
[2022-07-01 23:33:06,302] INFO Snapshot step 4 - Determining snapshot offset (io.debezium.relational.RelationalSnapshotChangeEventSource)
[2022-07-01 23:33:07,213] INFO  No in-progress transactions will be captured. (io.debezium.connector.oracle.logminer.LogMinerAdapter)
[2022-07-01 23:33:07,222] INFO Connection gracefully closed (io.debezium.jdbc.JdbcConnection)
[2022-07-01 23:33:07,222] INFO Snapshot step 5 - Reading structure of captured tables (io.debezium.relational.RelationalSnapshotChangeEventSource)
[2022-07-01 23:33:07,233] INFO All eligible tables schema should be captured, capturing: [*redacted*..there are 32741 tables listed
...abbreviated log.... by not pasting all the 'flushing 0 outstanding messages for offset' commit lines
[2022-07-01 23:51:45,782] INFO WorkerSourceTask{id=kafka-connect-src-01-0} flushing 0 outstanding messages for offset commit (org.apache.kafka.connect.runtime.WorkerSourceTask)
[2022-07-01 23:51:46,867] INFO Snapshot - Final stage (io.debezium.pipeline.source.AbstractSnapshotChangeEventSource)
[2022-07-01 23:51:46,947] ERROR Producer failure (io.debezium.pipeline.ErrorHandler)
java.lang.RuntimeException: java.sql.SQLException: ORA-01003: no statement parsed        at io.debezium.connector.oracle.OracleConnection.resetSessionToCdb(OracleConnection.java:112)
        at io.debezium.connector.oracle.OracleSnapshotChangeEventSource.complete(OracleSnapshotChangeEventSource.java:258)
        at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:89)
        at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:155)
        at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:137)
        at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:109)
        at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
        at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: java.sql.SQLException: ORA-01003: no statement parsed        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:456)
        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:451)
        at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1123)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
        at oracle.jdbc.driver.T4C8Odscrarr.doODNY(T4C8Odscrarr.java:106)
        at oracle.jdbc.driver.T4CStatement.doDescribe(T4CStatement.java:713)
        at oracle.jdbc.driver.OracleStatement.computeNumberOfUserColumns(OracleStatement.java:1874)
        at oracle.jdbc.driver.OracleStatement.createResultSet(OracleStatement.java:1851)
        at oracle.jdbc.driver.OracleStatement.getResultSet(OracleStatement.java:3244)
        at oracle.jdbc.driver.PhysicalConnection.closeResultsets(PhysicalConnection.java:9788)
        at oracle.jdbc.driver.PhysicalConnection.onPDBChange(PhysicalConnection.java:9748)
        at oracle.jdbc.driver.T4CConnection.onPDBChange(T4CConnection.java:2498)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:264)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:41)
        at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:928)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205)
        at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1823)
        at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1778)
        at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:303)
        at io.debezium.connector.oracle.OracleConnection.resetSessionToCdb(OracleConnection.java:109)
        ... 10 more
[2022-07-01 23:51:46,948] INFO Connected metrics set to 'false' (io.debezium.pipeline.ChangeEventSourceCoordinator)
[2022-07-01 23:51:46,949] INFO WorkerSourceTask{id=kafka-connect-src-01-0} flushing 0 outstanding messages for offset commit (org.apache.kafka.connect.runtime.WorkerSourceTask)
[2022-07-01 23:51:46,949] ERROR WorkerSourceTask{id=kafka-connect-src-01-0} Task threw an uncaught and unrecoverable exception. Task is being killed and will not recover until manually restarted (org.apache.kafka.connect.runtime.WorkerTask)
org.apache.kafka.connect.errors.ConnectException: An exception occurred in the change event producer. This connector will be stopped.
        at io.debezium.pipeline.ErrorHandler.setProducerThrowable(ErrorHandler.java:50)
        at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:116)
        at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
        at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: java.lang.RuntimeException: java.sql.SQLException: ORA-01003: no statement parsed        at io.debezium.connector.oracle.OracleConnection.resetSessionToCdb(OracleConnection.java:112)
        at io.debezium.connector.oracle.OracleSnapshotChangeEventSource.complete(OracleSnapshotChangeEventSource.java:258)
        at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:89)
        at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:155)
        at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:137)
        at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:109)
        ... 5 more
Caused by: java.sql.SQLException: ORA-01003: no statement parsed        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:456)
        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:451)
        at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:1123)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
        at oracle.jdbc.driver.T4C8Odscrarr.doODNY(T4C8Odscrarr.java:106)
        at oracle.jdbc.driver.T4CStatement.doDescribe(T4CStatement.java:713)
        at oracle.jdbc.driver.OracleStatement.computeNumberOfUserColumns(OracleStatement.java:1874)
        at oracle.jdbc.driver.OracleStatement.createResultSet(OracleStatement.java:1851)
        at oracle.jdbc.driver.OracleStatement.getResultSet(OracleStatement.java:3244)
        at oracle.jdbc.driver.PhysicalConnection.closeResultsets(PhysicalConnection.java:9788)
        at oracle.jdbc.driver.PhysicalConnection.onPDBChange(PhysicalConnection.java:9748)
        at oracle.jdbc.driver.T4CConnection.onPDBChange(T4CConnection.java:2498)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:264)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:41)
        at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:928)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205)
        at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1823)
        at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1778)
        at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:303)
        at io.debezium.connector.oracle.OracleConnection.resetSessionToCdb(OracleConnection.java:109)
        ... 10 more
[2022-07-01 23:51:46,949] INFO Stopping down connector (io.debezium.connector.common.BaseSourceTask)
[2022-07-01 23:51:46,956] INFO Connection gracefully closed (io.debezium.jdbc.JdbcConnection)
[2022-07-01 23:51:46,956] INFO [Producer clientId=my-topicoracle-dbhistory] Closing the Kafka producer with timeoutMillis = 30000 ms. (org.apache.kafka.clients.producer.KafkaProducer)