Debezium Server connector for Oracle fails on snapshot with the error -

an error used by: Error : 1737, Position : 42, SQL = LOCK TABLE "C##DBZUSER"."EMP_1" IN ACCESS SHARE MODE;, Original SQL = LOCK TABLE "C##DBZUSER"."EMP_1" IN ACCESS SHARE MODE;, Error Message = ORA-01737: valid modes: [ROW] SHARE, [[SHARE] ROW] EXCLUSIVE, SHARE UPDATE.rts, provide this information, please:

What Debezium connector do you use and what version?

Debezium Server 2.6.0.CR1 connector for Oracle

What is the connector configuration?

<Your answer>

What is the captured database version and mode of depoyment?

Oracle 19c

What behaviour do you expect?

What behaviour do you see?

The Debezium Server failed to do the snapshot and stopped

Do you see the same behaviour using the latest relesead Debezium version?

No, with 2.6 it is working

Do you have the connector logs, ideally from start till finish?

2024-04-02 17:15:32,858 INFO  [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-rdi-change-event-source-coordinator) According to the connector configuration both schema and data will be snapshot.
2024-04-02 17:15:32,870 INFO  [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-rdi-change-event-source-coordinator) Snapshot step 1 - Preparing
2024-04-02 17:15:32,870 INFO  [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-rdi-change-event-source-coordinator) Snapshot step 2 - Determining captured tables
2024-04-02 17:15:33,032 INFO  [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-rdi-change-event-source-coordinator) Adding table ORCLPDB1.C##DBZUSER.EMP_1 to the list of capture schema tables
2024-04-02 17:15:33,032 INFO  [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-rdi-change-event-source-coordinator) Adding table ORCLPDB1.C##DBZUSER.EMP to the list of capture schema tables
2024-04-02 17:15:33,046 INFO  [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-rdi-change-event-source-coordinator) Created connection pool with 1 threads
2024-04-02 17:15:33,047 INFO  [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-rdi-change-event-source-coordinator) Snapshot step 3 - Locking captured tables ORCLPDB1.C##DBZUSER.EMP_1, ORCLPDB1.C##DBZUSER.EMP
2024-04-02 17:15:33,059 DEBUG [io.deb.con.ora.OracleSnapshotChangeEventSource] (debezium-oracleconnector-rdi-change-event-source-coordinator) Locking table ORCLPDB1.C##DBZUSER.EMP_1
2024-04-02 17:15:33,065 ERROR [io.deb.rel.RelationalSnapshotChangeEventSource] (debezium-oracleconnector-rdi-change-event-source-coordinator) Error during snapshot: java.sql.SQLSyntaxErrorException: ORA-01737: valid modes: [ROW] SHARE, [[SHARE] ROW] EXCLUSIVE, SHARE UPDATE

https://docs.oracle.com/error-help/db/ora-01737/
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:702)
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:608)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1277)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:1102)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:456)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:482)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:170)
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1117)
    at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1652)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1417)
    at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2278)
    at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2227)
    at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:330)
    at io.debezium.connector.oracle.OracleSnapshotChangeEventSource.lockTablesForSchemaSnapshot(OracleSnapshotChangeEventSource.java:106)
    at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:147)
    at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:94)
    at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:253)
    at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:237)
    at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:189)
    at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:140)
    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: Error : 1737, Position : 42, SQL = LOCK TABLE "C##DBZUSER"."EMP_1" IN ACCESS SHARE MODE;, Original SQL = LOCK TABLE "C##DBZUSER"."EMP_1" IN ACCESS SHARE MODE;, Error Message = ORA-01737: valid modes: [ROW] SHARE, [[SHARE] ROW] EXCLUSIVE, SHARE UPDATE

    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:710)
    ... 24 more

2024-04-02 17:15:33,067 INFO  [io.deb.pip.sou.AbstractSnapshotChangeEventSource] (debezium-oracleconnector-rdi-change-event-source-coordinator) Snapshot - Final stage
2024-04-02 17:15:33,069 WARN  [io.deb.pip.sou.AbstractSnapshotChangeEventSource] (debezium-oracleconnector-rdi-change-event-source-coordinator) Snapshot was not completed successfully, it will be re-executed upon connector restart
2024-04-02 17:15:33,070 ERROR [io.deb.pip.ErrorHandler] (debezium-oracleconnector-rdi-change-event-source-coordinator) Producer failure: io.debezium.DebeziumException: java.sql.SQLSyntaxErrorException: ORA-01737: valid modes: [ROW] SHARE, [[SHARE] ROW] EXCLUSIVE, SHARE UPDATE

https://docs.oracle.com/error-help/db/ora-01737/
    at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:103)
    at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:253)
    at io.debezium.pipeline.ChangeEventSourceCoordinator.doSnapshot(ChangeEventSourceCoordinator.java:237)
    at io.debezium.pipeline.ChangeEventSourceCoordinator.executeChangeEventSources(ChangeEventSourceCoordinator.java:189)
    at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:140)
    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.SQLSyntaxErrorException: ORA-01737: valid modes: [ROW] SHARE, [[SHARE] ROW] EXCLUSIVE, SHARE UPDATE

https://docs.oracle.com/error-help/db/ora-01737/
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:702)
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:608)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1277)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:1102)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:456)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:482)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:170)
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1117)
    at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1652)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1417)
    at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2278)
    at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2227)
    at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:330)
    at io.debezium.connector.oracle.OracleSnapshotChangeEventSource.lockTablesForSchemaSnapshot(OracleSnapshotChangeEventSource.java:106)
    at io.debezium.relational.RelationalSnapshotChangeEventSource.doExecute(RelationalSnapshotChangeEventSource.java:147)
    at io.debezium.pipeline.source.AbstractSnapshotChangeEventSource.execute(AbstractSnapshotChangeEventSource.java:94)
    ... 9 more
Caused by: Error : 1737, Position : 42, SQL = LOCK TABLE "C##DBZUSER"."EMP_1" IN ACCESS SHARE MODE;, Original SQL = LOCK TABLE "C##DBZUSER"."EMP_1" IN ACCESS SHARE MODE;, Error Message = ORA-01737: valid modes: [ROW] SHARE, [[SHARE] ROW] EXCLUSIVE, SHARE UPDATE

    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:710)

How to reproduce the issue using our tutorial deployment?

<Your answer>

Feature request or enhancement

For feature requests or enhancements, provide this information, please:

Which use case/requirement will be addressed by the proposed feature?

<Your answer>

Implementation ideas (optional)

<Your answer>